Re: [HACKERS] The 85/0.0085 mistery ?

[Tom Lane]

"Frederick W. Reimer" <[EMAIL PROTECTED]> writes:
> In general, it's recommended you don't check for exact equivalence when
> doing calculations on real numbers and instead check for "almost exactness."

Or use datatype NUMERIC, which behaves in a more intuitive way (at least
for people who are accustomed to thinking in decimal).  But yes, exact
equality checks on float values are usually foolish.

                        regards, tom lane