From: Franco Bruno Borghesi <franco@akyasociados.com.ar>
Organization: AK y Asociados S.R.L.
To: Don Park <donp+postgresql@klickitat.st>, pgsql-sql@postgresql.org
Subject: Re: numeric fields and null
Date: Thu, 22 May 2003 19:40:48 -0300
User-Agent: KMail/1.5.1
References: <Pine.LNX.4.51.0305221317360.17969@amidala.klickitat.st>
In-Reply-To: <Pine.LNX.4.51.0305221317360.17969@amidala.klickitat.st>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200305221940.49755.franco@akyasociados.com.ar>

the correct way to do it is 
select id,postaladdressid from users where postaladdressid IS null;

I could tell you way, but this explanation (http://techdocs.postgresql.org/guides/BriefGuideToNulls)  is
so good that I'would waste your time :)

On Thursday 22 May 2003 17:17, 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