Re: BUG #3469: SELECT QRY - Mailing list pgsql-bugs

SRIDHARAN wrote:
> SELECT (DATE '2001-07-30', DATE '2001-08-31') OVERLAPS (DATE '2001-08-04',
> DATE '2002-08-04')
> Retrutns : t
>
> SELECT (DATE '2007-07-30', DATE '2007-07-31') OVERLAPS (DATE '2007-07-31',
> DATE '2007-07-31')
> Returns : f

That's intentional. SQL OVERLAPS operator treats the intervals as open
from the end-side.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com