Re: select * from mytable where myfield=null;

From: Jeremy Buchmann <jeremy(at)wellsgaming(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: select * from mytable where myfield=null;
Date: 2002-05-14 18:21:53
Message-ID: 3CE155C1.2060602@wellsgaming.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Tom Lane wrote:
> "Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Andrew Sullivan 2002-05-14 19:57:47 Re: [JDBC] select * from mytable where myfield=null;
Previous Message Jeremy Buchmann 2002-05-14 15:29:06 Re: [JDBC] select * from mytable where myfield=null;