selecting all records where a column is null

From: "Elmshauser, Erik" <erike(at)pbgnw(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: selecting all records where a column is null
Date: 2002-06-20 18:46:43
Message-ID: 0FD2E5E35F0C0D41AEA66C9C6F39F30D475F@HERMES.pbgnw.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

and some other stuff the is way more broken. I have flipped through the
docs a bit but I haven't found anything useful yet. If someone could
point me to the right place in the docs or give me an example of a
select that will do this I would be very grateful.
--Erik

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Wood 2002-06-20 19:00:09 Re: Yet another "Why won't PostgreSQL use my index?"
Previous Message Joshua D. Drake 2002-06-20 18:45:02 Re: URGENT: Performance tuning