Re: Query help... - Mailing list pgsql-general

From missive@frontiernet.net (Lee Harr)
Subject Re: Query help...
Date
Msg-id 9l48fr$3hla$3@node21.cwnet.roc.gblx.net
Whole thread Raw
In response to Re: Query help...  (Thomas Lockhart <lockhart@fourpalms.org>)
List pgsql-general
On Sat, 11 Aug 2001 16:57:10 +0000 (UTC), <lockhart@fourpalms.org>:
> Perhaps not a helpful one... but I would be inclined to reorganize that
> third table to have a "start date" *and* a "stop date" field, and ditch
> the "dropped" boolean:
>

This is how I would do it, then query for employees with
records that have NULL in the "stop date" field.

pgsql-general by date:

Previous
From: missive@frontiernet.net (Lee Harr)
Date:
Subject: Re: Postmaster Question ?
Next
From: lbayuk@mindspring.com (ljb)
Date:
Subject: Re: copy to/from stdout using libpgtcl