[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] numeric fields and null
From:       Stephan Szabo <sszabo () megazone23 ! bigpanda ! com>
Date:       2003-05-22 22:25:56
[Download RAW message or body]

On Thu, 22 May 2003, 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?

Because NULL=NULL is not true (it's unknown).  Use IS NULL if you want to
see if something is NULL.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
[prev in list] [next in list] [prev in thread] [next in thread]