| 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: | Whole Thread | Raw Message | 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
 
| 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 |