Re: [BUGS] float8 comparison failure

[Tom Lane]

Radek Kanovsky <[EMAIL PROTECTED]> writes:
> [ float8 values that appear equal are not always equal ]

This is not a bug, it's an inherent consequence of the inaccuracy of
floating-point math.  Use some other data type (numeric, maybe) if
you expect to be able to do exact equality comparisons.

                        regards, tom lane