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

List:       postgresql-sql
Subject:    Re: [SQL] numeric fields and null
From:       Alexey Dashevsky <alex () kpgaz ! chernigov ! ua>
Date:       2003-05-23 5:51:49
[Download RAW message or body]

> > 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.

If in postgresql.conf set parameter    transform_null_equals=TRUE  ????

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]