Why overlaps is not working - Mailing list pgsql-general

From Andrus
Subject Why overlaps is not working
Date
Msg-id eivbgg$2agq$1@news.hub.org
Whole thread Raw
Responses Re: Why overlaps is not working
Re: Why overlaps is not working
List pgsql-general
set datestyle to iso,iso;

select 1 where ('2006-10-31'::date, '9999-12-31'::date) OVERLAPS
   ('2006-10-16'::DATE, '2006-10-31':: DATE)


does not return any rows.

Why ?
How to make overlaps to return correct result?

Andrus.



pgsql-general by date:

Previous
From: "Leif B. Kristensen"
Date:
Subject: Re: Table design - unknown number of column
Next
From: Matthias.Pitzl@izb.de
Date:
Subject: Re: Why overlaps is not working