Postgres Pro
Downloads
Home   >   mailing lists

Re: Need help with sql select on null dates! - Mailing list pgsql-general

From Diogo Biazus
Subject Re: Need help with sql select on null dates!
Date
Msg-id 3DE37EC9.8060600@ikono.com.br
Whole thread Raw
In response to Need help with sql select on null dates!  (Jeff Sacksteder <jwsacksteder@ramprecision.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: "Henshall, Stuart - Design & Print"
Date:
Subject: Re: Need help with sql select on null dates!
Next
From: "Peter Alberer"
Date:
Subject: pgsql-function called twice in the same second -> Double Insert -> Error