Re: select * from mytable where myfield=null; - Mailing list pgsql-jdbc

From Jeremy Buchmann
Subject Re: select * from mytable where myfield=null;
Date
Msg-id 3CE155C1.2060602@wellsgaming.com
Whole thread Raw
In response to Re: select * from mytable where myfield=null;  ("Hoanui Morangie" <hoanui@excite.com>)
List pgsql-jdbc
Tom Lane wrote:
> "Marin Dimitrov" <marin.dimitrov@sirma.bg> writes:
>
>>don't use NULLs
>
>
> I agree with Marin.  If you think you need x = NULL to act like x IS
> NULL, then you should rethink the way you are using NULL in your data
> design.  You are really swimming against the tide of the way that SQL
> specifies NULL to work.
>
>             regards, tom lane


Has this change affected the behavior of the isnull
operator/keyword/whatever it is...

select * from tablename where foo isnull;

I use that on occasion (in 7.1.2)...did this change in 7.2 also?

--Jeremy



pgsql-jdbc by date:

Previous
From: Cathal de Brun
Date:
Subject: Re: j2ee compatiable jdbc driver on jdbc.postgresql.org?
Next
From: Haug Bürger
Date:
Subject: Re: insert blocking?