X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 83BF1D1D32C for ; Tue, 20 Jan 2004 15:04:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 43094-02 for ; Tue, 20 Jan 2004 11:03:34 -0400 (AST) Received: from ganymede.hub.org (u46n208.hfx.eastlink.ca [24.222.46.208]) by svr1.postgresql.org (Postfix) with ESMTP id 5702CD1E3D5 for ; Tue, 20 Jan 2004 11:03:06 -0400 (AST) Received: from [192.168.1.106] (unknown [192.168.1.106]) by ganymede.hub.org (Postfix) with ESMTP id 897353C463; Tue, 20 Jan 2004 11:00:25 -0400 (AST) Subject: Re: comparing nulls From: Chris Bowlby Reply-To: chris@hub.org To: Kenneth Gonsalves Cc: chris@hub.org, pgsql-sql@postgresql.org In-Reply-To: <04012019542108.01434@thenilgiris.com> References: <04012019131206.01434@thenilgiris.com> <1074607016.49673.23.camel@morpheus.hub.org> <04012019542108.01434@thenilgiris.com> Content-Type: text/plain Organization: Hub.Org Networking Services Message-Id: <1074611042.49673.25.camel@morpheus.hub.org> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Tue, 20 Jan 2004 11:04:02 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/183 X-Sequence-Number: 16576 To achieve a higher level of SQL compliancy.. On Tue, 2004-01-20 at 10:24, Kenneth Gonsalves wrote: > On Tuesday 20 January 2004 19:26, Chris Bowlby wrote: > > Hi Ken, > > > > Under 7.3.x this option was removed, you need to test via: > > > > SELECT * from table where field IS NULL; > thanx - works in both 7.1 and 7.3 - why do these guys keep fooling around > with these thangs? -- Chris Bowlby Hub.Org Networking Services