Need help with sql select on null dates!

From: Jeff Sacksteder <jwsacksteder(at)ramprecision(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Need help with sql select on null dates!
Date: 2002-11-26 13:47:02
Message-ID: 71650A6F73F1D411BE8000805F65E3CB198197@SRV-03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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'
or:
'select * from employee_tables where isfinite(termination_date) <>
1'

...but no luck. What is the proper way to select undefined dates?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Choe 2002-11-26 13:49:16 process time of update
Previous Message peter 2002-11-26 13:23:46 postgres taking longer to update