Postgres Pro
Downloads
Home   >   mailing lists

Re: check for overlapping time intervals - Mailing list pgsql-sql

From Thomas Kellerer
Subject Re: check for overlapping time intervals
Date
Msg-id kl33os$hkc$1@ger.gmane.org
Whole thread Raw
In response to check for overlapping time intervals  (Wolfgang Meiners <WolfgangMeiners01@web.de>)
Responses Re: check for overlapping time intervals  (Wolfgang Meiners <WolfgangMeiners01@web.de>)
List pgsql-sql
Tree view 
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 by date:

Previous
From: Wolfgang Meiners
Date:
Subject: check for overlapping time intervals
Next
From: Wolfgang Meiners
Date:
Subject: Re: check for overlapping time intervals