Re: Inconsistent or incomplete behavior obverse in where clause - Mailing list pgsql-sql

Paul Ogden <pogden@claresco.com> writes:
>   select count(wuid) from WU where wuActive = 0.0 --throws the 
> following exception:

> "Unable to identify an operator '=' for types 'numeric' and 'double
> precision' You will have to retype this query using an explicit cast"

This is fixed as of 7.3.  (We still have related issues for smallint
and bigint columns, unfortunately.)
        regards, tom lane