|Subject||Re: [firebird-support] Why does FB evaluate numbers this way?|
> select (3/2)3 is an integer, 2 is an integer. You are performing an integer
> from rdb$database
> The result should be 3/2 = 1.5. Instead I get 1. Why?
select (3.0/2) will also bring up 1.5
A float or decimal type is a "larger" type than integer and the larger
type will determine the type of the operation.