Re: selecting all records where a column is null

-----Original Message-----
From: Fran Fabrizio [mailto:ffabrizio@mmrd.com]
Sent: Thursday, June 20, 2002 12:49 PM
To: Elmshauser, Erik; pgsql-general@postgresql.org
Subject: Re: [GENERAL] selecting all records where a column is null

select * from table where field is null;

is rather than =.  Since null is undefined, it's not appropriate to test

for equality to null.

-Fran


Thanks to everybody who replied, that's exactly what I needed.
    --Erik