X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 6F54E924CAD for ; Thu, 22 May 2003 20:32:50 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 00893-08 for ; Thu, 22 May 2003 20:32:19 -0400 (EDT) Received: from bach.ccinet.ab.ca (bach.ccinet.ab.ca [198.161.96.1]) by developer.postgresql.org (Postfix) with ESMTP id DA0D3924D20 for ; Thu, 22 May 2003 18:27:04 -0400 (EDT) Received: from incentre.net (squid.incentre.net [206.75.213.195]) by bach.ccinet.ab.ca (8.12.6/8.12.6) with ESMTP id h4MMTCMc092118 for ; Thu, 22 May 2003 16:29:12 -0600 (MDT) (envelope-from guy@incentre.net) Message-ID: <3ECD4EB7.1080407@incentre.net> Date: Thu, 22 May 2003 16:27:03 -0600 From: Guy Fraser User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003 X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: numeric fields and null References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/434 X-Sequence-Number: 13599 Use: SELECT id,postaladdressid FROM users WHERE postaladdressid IS NULL; Don Park wrote: >Im trying to pull out all records in a table where field >'postaladdressid=null' but I cant figure this out. > >\d users >.... >id | numeric >postaladdressid | numeric >.... > >adhoc=# update users set postaladdressid=null where id=50; >UPDATE 1 > >adhoc=# select id,postaladdressid from users where postaladdressid=null; > id | postaladdressid >----+----------------- >(0 rows) > >Why did it not select record 50? > >just for your info, this is what record 50 looks like. >adhoc=# select id,postaladdressid from users where id=50; > id | postaladdressid >----+----------------- > 50 | >(1 row) > > >Don > >