0.99999998 (was: Unknown SQL)

From: Robert Vazan <robova_at_nextra.sk>
Date: Fri, 01 Jun 2001 19:37:37 GMT
Message-ID: <3b169b50.17317778@news.nextra.sk>

"Bob Badour" <bbadour_at_golden.net> wrote:
>[...] The value 1 does
>not change significantly among different representations. Whether
>represented with a character string, packed decimal, binary integer, IEEE
>floating point number or any other representation, the value 1 remains the
>value 1.

IEEE? Interesting. Do you mean 0.99999998=1? Moving that value from representation to representation causes rounding problems. Does database recognize it as 1?

And what about TShape#1 = TShape#2? Just curious.

/Robert Received on Fri Jun 01 2001 - 14:37:37 CDT