"Frederick W. Reimer" <fwr@ga.prestige.net> 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