Re: selecting all records where a column is null

> -----Original Message-----
> From: Elmshauser, Erik [mailto:erike(at)pbgnw(dot)com]
> Sent: 20 June 2002 19:47
> To: pgsql-general(at)postgresql(dot)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.