Subject | Re: [ib-support] 3 * 1/3 = 0 ??? |
---|---|
Author | Aage Johansen |
Post date | 2002-08-30T18:40:45Z |
Martijn Tonies wrote:
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.
> > Any chance of changing it next version? If integer operations areAgree with Martijn.
> > desired, how about a div? Please don't tell me that current
> > behaviour is good. It isn't.
>
> Yes it is.
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.