Subject Re: [ib-support] 3 * 1/3 = 0 ???
Author Aage Johansen
Martijn Tonies wrote:
> > Any chance of changing it next version? If integer operations are
> > desired, how about a div? Please don't tell me that current
> > behaviour is good. It isn't.
>
> Yes it is.

Agree with Martijn.

If you want floating point op's, you can use
SELECT (cast (1 as float)/3)*3 FROM RDB$DATABASE
which - in Fb/1 d=3 - returns 1 (in ib_sql) - this should be close enough.


Regards,
Aage J.