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
Re: selecting all records where a column is null Re: selecting all records where a column is null Re: selecting all records where a column is null |
| Список | 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
В списке pgsql-general по дате отправления: