Re: selecting all records where a column is null

> -----Original Message-----
> From: Elmshauser, Erik [mailto:erike@pbgnw.com] 
> Sent: 20 June 2002 19:47
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] selecting all records where a column is null
> 
> 
> Hi, I am trying to select every record from a table where a 
> specific column does not have a value in it yet.  Is there a 
> way to express that in a SQL statement?  Here are the few I tried:
>  
> select * from table where field;
> select * from table where field = '';
> select * from table where field = NULL;

select * from table where field IS NULL;

Regards, Dave.