From postgresql-sql  Fri May 23 05:51:49 2003
From: Alexey Dashevsky <alex () kpgaz ! chernigov ! ua>
Date: Fri, 23 May 2003 05:51:49 +0000
To: postgresql-sql
Subject: Re: [SQL] numeric fields and null
X-MARC-Message: https://marc.info/?l=postgresql-sql&m=105368368804227

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