query using a date field that isn't set

From: "John B(dot) Scalia" <jscalia(at)cityblueprinting(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: query using a date field that isn't set
Date: 2004-11-02 15:44:41
Message-ID: 0I6K008ES6EI0H@chimmx04.algx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

I've got a SQL problem that's stumping me. I have an employee table with a
field labeled:

Emp_terminated DATE

Obviously, some employees in this table won't have this field set. I want a
query to select only employees without this field being set, ie., only
current employees. I've got the inverse working by using:

SELECT * FROM employee WHERE ISFINITE(emp_terminated);

And that gives me all the old employees (where the field has a value), but
for the life of me, I can't figure out the syntax to use for employees that
haven't been terminated or quit. Everything I've tried returns no rows.

Anybody?

--

John

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Hammond 2004-11-02 18:46:41 Re: JOIN not being calculated correctly
Previous Message Markus Schaber 2004-11-02 15:42:36 Re: Update instead rules on Views