Check set of date intervals

From: Anton Gavazuk <antongavazuk(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Check set of date intervals
Date: 2010-05-27 10:07:20
Message-ID: AANLkTil8uYMMxel-SmWLDEuHPu0l2DHM0CjetnxAX3GL@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

have such relation A:

PERIOD_ID | DATE_START | DATE_END | OTHER_ATTRIBUTES...
1 | 01.01.2010 | 01.02.2010 ....
2 | 03.02.2010 | 04.03.2010 .....
......

I want to search among periods for the set of periods which completely
covers passed search period.
As example - if I pass search period '15.01.2010 to 15.02.2010' the result
set must be empty because there is gap between 01.02 and 03.02.

please, suggest an idea how to implement this in SQL without writing a
procedure.

Thanks,
Anton

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2010-05-27 10:27:13 Re: Check set of date intervals
Previous Message Harrie Rodenbach 2010-05-27 08:23:03 Do not understand "SETOF RECORD" - therefore can not use ODBC-link