Why overlaps is not working

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Why overlaps is not working
Date: 2006-11-09 13:46:50
Message-ID: eivbgg$2agq$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthias.Pitzl 2006-11-09 13:47:14 Re: Why overlaps is not working
Previous Message Leif B. Kristensen 2006-11-09 13:26:13 Re: Table design - unknown number of column