Re: select * from mytable where myfield=null;

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)bg>
Cc: hoanui(at)excite(dot)com, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: select * from mytable where myfield=null;
Date: 2002-05-14 14:42:38
Message-ID: 25959.1021387358@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

"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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Hoanui Morangie 2002-05-14 14:57:27 Re: select * from mytable where myfield=null;
Previous Message Hoanui Morangie 2002-05-14 14:21:52 Re: select * from mytable where myfield=null;