Re: selecting all records where a column is null

-----Original Message-----
From: Fran Fabrizio [mailto:ffabrizio(at)mmrd(dot)com]
Sent: Thursday, June 20, 2002 12:49 PM
To: Elmshauser, Erik; pgsql-general(at)postgresql(dot)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