Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 0CD35632777 for ; Thu, 27 May 2010 07:27:24 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 66822-09 for ; Thu, 27 May 2010 10:27:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.10]) by mail.postgresql.org (Postfix) with ESMTP id 4138B63221C for ; Thu, 27 May 2010 07:27:16 -0300 (ADT) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrbap2) with ESMTP (Nemesis) id 0Lf0KF-1NRndF1hnz-00qiLl; Thu, 27 May 2010 12:27:14 +0200 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1OHaIz-0007on-00 for pgsql-sql@postgresql.org; Thu, 27 May 2010 12:27:13 +0200 Date: Thu, 27 May 2010 12:27:13 +0200 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: Check set of date intervals Message-ID: <20100527102713.GC6907@a-kretschmer.de> References: Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX1+pc/n8tZ39HEqpGNPNvqTAWxs0Dz8kq9FaxGu iBLtDb3A7lzzLtXSwehA/OwFZeYTolRCQwhjvosE9ye9HQ10Ka wKlQCXYbg3oa1KHmvNRaw== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.81 tagged_above=-5 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001, T_FRT_CONTACT=0.01 X-Spam-Level: X-Archive-Number: 201005/123 X-Sequence-Number: 34171 In response to Anton Gavazuk : > 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. There are a really nice additional contrib module from Jeff Davis, described here: http://thoughts.j-davis.com/2010/03/09/temporal-postgresql-roadmap/ Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99