Postgres Pro
Downloads
Home   >   mailing lists

Re: Constraining overlapping date ranges - Mailing list pgsql-general

From Richard Broersma
Subject Re: Constraining overlapping date ranges
Date
Msg-id AANLkTimCJ4N9AMLYBfjuoUKzv4SMKFgQHNi4_uSDXhv1@mail.gmail.com
Whole thread Raw
In response to Constraining overlapping date ranges  ("McGehee, Robert" <Robert.McGehee@geodecapital.com>)
List pgsql-general
Tree view 
On Tue, Dec 21, 2010 at 7:49 AM, McGehee, Robert
<Robert.McGehee@geodecapital.com> wrote:
> PostgreSQLers,
> I'm hoping for some help creating a constraint/key on a table such that there are no overlapping ranges of dates for
anyid. 

 There is something you can try, but it is not exactly what you want
since it is based on timestamps rather than dates:

http://temporal.projects.postgresql.org/


--
Regards,
Richard Broersma Jr.

pgsql-general by date:

Previous
From: "McGehee, Robert"
Date:
Subject: Constraining overlapping date ranges
Next
From: Kelly Burkhart
Date:
Subject: libpq sendQuery -- getResult not returning until all queries complete