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.