Re: check for overlapping time intervals

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: check for overlapping time intervals
Дата
Msg-id kl33os$hkc$1@ger.gmane.org
обсуждение исходный текст
Ответ на check for overlapping time intervals  (Wolfgang Meiners <WolfgangMeiners01@web.de>)
Ответы Re: check for overlapping time intervals  (Wolfgang Meiners <WolfgangMeiners01@web.de>)
Список pgsql-sql
Wolfgang Meiners, 22.04.2013 12:19:
> Is there a simpler way to check for overlapping timeintervals? I ask
> this question, because i have more similar tables with similar layout
> and would have to write similar functions again and again.

Do you have the possibility to upgrade to 9.2?

The range types introduced with 9.2 seem to be *exactly* what you need.

Regards
Thomas






В списке pgsql-sql по дате отправления:

Предыдущее
От: Wolfgang Meiners
Дата:
Сообщение: check for overlapping time intervals
Следующее
От: Wolfgang Meiners
Дата:
Сообщение: Re: check for overlapping time intervals