Re: Trouble with float4 after upgrading from 6.5.3 to 7.0.2

Tom Lane <tgl@sss.pgh.pa.us> writes:

> A general comment on your table design though: anyone who expects exact
> equality tests on fractional float values to succeed is going to get
> burnt sooner or later.  If you must use this style of coding then
> I recommend using numeric fields not float fields, and certainly not
> float4 fields.
>
> regards, tom lane

I try 'numeric', 'decimal', and 'float8' types and only 'float8' works. Both 'decimal' and 'numeric' failed (as
'float4'did) with error message: "Unable to identify an operator '=' for type numeric and 'float8' You will have to
retypethis query using an explicite cast". 

And though my problem is solved, thank you for the help, I thought perhaps this information will be usefull for you.

Mikhail.