Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A259A475E75 for ; Tue, 12 Nov 2002 13:35:06 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id B3F49475DC0 for ; Tue, 12 Nov 2002 13:35:05 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id gACIYlhR010296; Tue, 12 Nov 2002 13:34:48 -0500 (EST) To: pogden@claresco.com Cc: pgsql-sql@postgresql.org Subject: Re: Inconsistent or incomplete behavior obverse in where clause In-reply-to: References: Comments: In-reply-to Paul Ogden message dated "Tue, 12 Nov 2002 09:39:13 -0800" Date: Tue, 12 Nov 2002 13:34:47 -0500 Message-ID: <10295.1037126087@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/194 X-Sequence-Number: 10336 Paul Ogden 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