select an entry with a NULL date field
От | Web Manager |
---|---|
Тема | select an entry with a NULL date field |
Дата | |
Msg-id | 3997FC0F.96ACA1A8@inter-resa.com обсуждение исходный текст |
Ответы |
Re: select an entry with a NULL date field
Re: select an entry with a NULL date field |
Список | pgsql-sql |
Hello, I have a problem with PostgreSQL when I try to select or delete an entry with an empty date. That's a typical entry Table tbl_date ----------------------------- entry_id 154 date_01 2000-01-15 date_02 this date is NULL name my_test ----------------------------- I want to select every entry containing date_02 as NULL I tried : >select entry_id from tbl_date where date_02=NULL; ERROR: parser: parse error at or near "null" >select entry_id from tbl_date where date_02=''; Not work, that's a wrong date format >select entry_id from tbl_date where date_02=""; Not work, "" considered as an attribute Thank you for your time! -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Marc Andre Paquin
В списке pgsql-sql по дате отправления: