Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id VAA27369 for ; Mon, 10 Apr 2000 21:04:43 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id VAA28653; Mon, 10 Apr 2000 21:04:30 -0400 (EDT) To: Andrew Perrin - Demography cc: pgsql-sql@postgresql.org Subject: Re: Using overlaps() In-reply-to: References: Comments: In-reply-to Andrew Perrin - Demography message dated "Mon, 10 Apr 2000 16:45:22 -0700" Date: Mon, 10 Apr 2000 21:04:30 -0400 Message-ID: <28650.955415070@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200004/102 Andrew Perrin - Demography writes: > The Postgres Book implies that there is a function overlaps() that takes > two pairs of dates and returns true if they overlap. It's new in 7.0, I believe. regards, tom lane