That sort of query works fine on my install, Pg 7.2b3. If you're having
problems with the conversion, you could try using the round function on the
float to get it down to zero decimal places thusly:
select * from whatever where numeric_col = round(2001.2);
or you would try casting numeric_col like so:
select * from whatever where numeric_col::float = 2001.1;
J
Bob Jones wrote:
> I would like to correct a misprint on my original post. Earlier I stated:
>
> ... an error stating that the '-' operator is unidentified for numeric and
> float8 types....
>
> The "unidentified operator" should be the "=" operator (as shown correctly
> in the SQL query example of my original post), not the "-" operator as
> previously mentioned.
>
> My apologies,
> Bob