From: | "Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)uk> |
---|---|
To: | 'Jeff Sacksteder' <jwsacksteder(at)ramprecision(dot)com>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Need help with sql select on null dates! |
Date: | 2002-11-26 13:49:52 |
Message-ID: | E382B5D8EDE1D6118DBE0008C759BCD6116ADC@WCPEXCHANGE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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' or:
> 'select * from employee_tables where
> isfinite(termination_date) <>
> 1'
>
> ...but no luck. What is the proper way to select undefined dates?
>
NULLs are unknown and therefore there equality can not be tested.
select * from employee_tables where termination_date is null;
ought to work however
hth,
- Stuart
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Alberer | 2002-11-26 13:55:16 | pgsql-function called twice in the same second -> Double Insert -> Error |
Previous Message | Peter Choe | 2002-11-26 13:49:16 | process time of update |