Subject RE: [ib-support] 3 * 1/3 = 0 ???
Author Daniel Rail
At 30/08/2002 11:12 AM, you wrote:
>Well, you'll be happy to know, that on FB1.0, using QuickDesk
>
>SELECT (1/3)*3 FROM RDB$DATABASE = 1.000

Using which dialect? I'm using Dialect 3 and get an answer of 0. The
operation (1/3) seems to result as an integer, so the result would be 0,
because of the rounding algorithm.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)