Re: Constraining overlapping date ranges

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: "McGehee, Robert" <Robert(dot)McGehee(at)geodecapital(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Constraining overlapping date ranges
Date: 2010-12-21 18:18:07
Message-ID: AANLkTimCJ4N9AMLYBfjuoUKzv4SMKFgQHNi4_uSDXhv1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 21, 2010 at 7:49 AM, McGehee, Robert
<Robert(dot)McGehee(at)geodecapital(dot)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 any id.

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kelly Burkhart 2010-12-21 18:42:40 libpq sendQuery -- getResult not returning until all queries complete
Previous Message Andreas Kretschmer 2010-12-21 18:05:09 Re: How to use pgbouncer