Re: Trouble with float4 after upgrading from 6.5.3 to 7.0.2

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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 retype this 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.