Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA25990 for ; Mon, 10 Apr 2000 20:51:58 -0400 (EDT) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id UAA16523; Mon, 10 Apr 2000 20:44:01 -0400 (EDT) From: Bruce Momjian Message-Id: <200004110044.UAA16523@candle.pha.pa.us> Subject: Re: Using overlaps() In-Reply-To: from Andrew Perrin - Demography at "Apr 10, 2000 04:45:22 pm" To: Andrew Perrin - Demography Date: Mon, 10 Apr 2000 20:44:01 -0400 (EDT) CC: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL72 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/101 Perhaps only 7.0beta. Sorry > Greetings. > > The Postgres Book implies that there is a function overlaps() that takes > two pairs of dates and returns true if they overlap. However, I get an > error trying to use it: > > demogdata=> select event_id from event_detail where overlaps > (date_effective, date_expires, '1-mar-2000'::datetime , now()::datetime); > ERROR: No such function 'overlaps' with the specified attributes > demogdata=> select event_id from event_detail where (date_effective, > date_expires) overlaps ('1-mar-2000'::date , now()::date); > ERROR: parser: parse error at or near "overlaps" > > Any advice? > > Thanks. > > --------------------------------------------------------------------- > Andrew J. Perrin - aperrin@demog.berkeley.edu - NT/Unix Admin/Support > Department of Demography - University of California at Berkeley > 2232 Piedmont Avenue #2120 - Berkeley, California, 94720-2120 USA > http://demog.berkeley.edu/~aperrin --------------------------SEIU1199 > > -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026