Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: select * from mytable where myfield=null;
Date
Msg-id 25959.1021387358@sss.pgh.pa.us
Whole thread Raw
In response to Re: select * from mytable where myfield=null;  ("Marin Dimitrov" <marin.dimitrov@sirma.bg>)
List pgsql-jdbc
Tree view 
"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

pgsql-jdbc by date:

Previous
From: "Hoanui Morangie"
Date:
Subject: Re: select * from mytable where myfield=null;
Next
From: "Hoanui Morangie"
Date:
Subject: Re: select * from mytable where myfield=null;