Re: Casting numeric values to double

"Daniel Schregenberger" <npfdd@gmx.net> writes:
> If I compare a field of type "numeric" to a small decimal constant like
> "3.6", the constant is interpreted as a "double precision" value and the
> comparison fails with the following message:
> # SELECT * FROM tr_table_okpx WHERE prating >= 3.6;
> Unable to identify an operator '>=' for types 'double precision' and
> 'numeric'
>         You will have to retype this query using an explicit cast

> I'm using Postgre 7.2, which might be a bit outdated but I could not find
> any information whether this behaviour has changed in newer versions.

More than "a bit" outdated, and yes it has.

            regards, tom lane