[EMAIL PROTECTED] writes:
> real or float4 '=' operator is broken in 7.1.2
No, it isn't --- try coercing the values you are comparing against
to be float4. Your error is in assuming that 29.92::float8 should
equal 29.92::float4 coerced back to float8. Which might be a nice
property to have, but
More information to add to this bug.
I get the same behavior as the original poster, but the following on these
queries:
sszabo=> select myfloat-29.92 from "test_f4";
?column?
--
7.62939436071974e-08
7.62939436071974e-08
(2 rows)
sszabo=> select myfloat-'29.92
David Dodsworth ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
real or float4 '=' operator is broken in 7.1.2
Long Description
As the example shows, a select for on a 'real' or 'float4' value
value will not return any rows wh
