Re: Need help with sql select on null dates!

Поиск
Список
Период
Сортировка
От Diogo Biazus
Тема Re: Need help with sql select on null dates!
Дата
Msg-id 3DE37EC9.8060600@ikono.com.br
обсуждение исходный текст
Ответ на Need help with sql select on null dates!  (Jeff Sacksteder <jwsacksteder@ramprecision.com>)
Список pgsql-general
Дерево обсуждения 
Jeff Sacksteder wrote:

>I'm having trouble doing a select on empty date fields.
>
>Suppose my table is composed of employee_number(char), hire_date(date), and
>termination_date(date).
>I would expect to be able to say:
>
>    'select * from employee_tables where termination_date = null'
>
>
Isntead of '= null' you should use the 'IS NULL' operator.
For example:

'select * from employee_tables where termination_date is null'

--
Diogo de Oliveira Biazus
diogo@ikono.com.br
Ikono Sistemas e Automação
http://www.ikono.com.br

В списке pgsql-general по дате отправления:

Предыдущее
От: "Henshall, Stuart - Design & Print"
Дата:
Сообщение: Re: Need help with sql select on null dates!
Следующее
От: "Peter Alberer"
Дата:
Сообщение: pgsql-function called twice in the same second -> Double Insert -> Error