selecting all records where a column is null

Поиск
Список
Период
Сортировка
Искать
От
Elmshauser, Erik
Тема
selecting all records where a column is null
Дата
Msg-id
0FD2E5E35F0C0D41AEA66C9C6F39F30D475F@HERMES.pbgnw.com
Список
Дерево обсуждения
Re: selecting all records where a column is null "Dave Page" <dpage@vale-housing.co.uk>
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
 
В списке pgsql-general по дате отправления
От: Joshua D. Drake
Дата:
Сообщение: Re: URGENT: Performance tuning
От: Gregory Wood
Дата:
FAQ