Re: Constraining overlapping date ranges

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: Constraining overlapping date ranges
Дата
Msg-id AANLkTimCJ4N9AMLYBfjuoUKzv4SMKFgQHNi4_uSDXhv1@mail.gmail.com
обсуждение исходный текст
Ответ на Constraining overlapping date ranges  ("McGehee, Robert" <Robert.McGehee@geodecapital.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: "McGehee, Robert"
Дата:
Сообщение: Constraining overlapping date ranges
Следующее
От: Kelly Burkhart
Дата:
Сообщение: libpq sendQuery -- getResult not returning until all queries complete