Using overlaps()

From: Andrew Perrin - Demography <aperrin(at)demog(dot)berkeley(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Using overlaps()
Date: 2000-04-10 23:45:22
Message-ID: Pine.LNX.4.10.10004101643440.10219-100000@famine.DEMOG.Berkeley.EDU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)demog(dot)berkeley(dot)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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2000-04-11 00:44:01 Re: Using overlaps()
Previous Message Tom Lane 2000-04-10 23:35:12 Re: Finding primary keys