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 2A5C0D1D4DA for ; Tue, 20 Jan 2004 13:56:32 +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 26026-01 for ; Tue, 20 Jan 2004 09:56:03 -0400 (AST) Received: from ganymede.hub.org (u46n208.hfx.eastlink.ca [24.222.46.208]) by svr1.postgresql.org (Postfix) with ESMTP id 44F38D1D299 for ; Tue, 20 Jan 2004 09:56:00 -0400 (AST) Received: from [192.168.1.106] (unknown [192.168.1.106]) by ganymede.hub.org (Postfix) with ESMTP id A1AE63CD3D; Tue, 20 Jan 2004 09:53:19 -0400 (AST) Subject: Re: comparing nulls From: Chris Bowlby Reply-To: chris@hub.org To: Kenneth Gonsalves Cc: pgsql-sql@postgresql.org In-Reply-To: <04012019131206.01434@thenilgiris.com> References: <04012019131206.01434@thenilgiris.com> Content-Type: text/plain Organization: Hub.Org Networking Services Message-Id: <1074607016.49673.23.camel@morpheus.hub.org> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Tue, 20 Jan 2004 09:56:57 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/178 X-Sequence-Number: 16571 Hi Ken, Under 7.3.x this option was removed, you need to test via: SELECT * from table where field IS NULL; On Tue, 2004-01-20 at 09:43, Kenneth Gonsalves wrote: > in postgres7.1 i had a table where an integer field could be null. There was > no default value. a select statement like so: > 'select * from table where field = null' > would give all the rows where that field had no value. > on porting to 7.3.2, this doesnt work. How to do this? -- Chris Bowlby Hub.Org Networking Services