Re: [SQL] Inconsistent or incomplete behavior obverse in where clause

2002-11-12 Thread Tom Lane
Paul Ogden <[EMAIL PROTECTED]> 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. (

[SQL] Inconsistent or incomplete behavior obverse in where clause

2002-11-12 Thread Paul Ogden
Hello, Our application development group has observed what we feel is inconsistent behavior when comparing numeric column references to constant/literal values in SQL. I would appreciate comments on the best approach to this problem that will allow for the highest portability of our applicati