From: Franco Bruno Borghesi <franco@akyasociados.com.ar>
To: Don Park <donp+postgresql@klickitat.st>
To: pgsql-sql@postgresql.org
Subject: Re: numeric fields and null
Date: Thu, 22 May 2003 19:40:48 -0300
Message-ID: <200305221940.49755.franco@akyasociados.com.ar> (raw)
In-Reply-To: <Pine.LNX.4.51.0305221317360.17969@amidala.klickitat.st>
References: <Pine.LNX.4.51.0305221317360.17969@amidala.klickitat.st>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: franco@akyasociados.com.ar, donp+postgresql@klickitat.st
Subject: Re: numeric fields and null
In-Reply-To: <200305221940.49755.franco@akyasociados.com.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox