On Tue, Dec 21, 2010 at 7:49 AM, McGehee, Robert <Robert.McGehee@xxxxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general