Thread: BUG #3469: SELECT QRY

The following bug has been logged online:

Bug reference:      3469
Logged by:          SRIDHARAN
Email address:      sridharan@avanttec.net
PostgreSQL version: 1.4.2
Operating system:   WinXP
Description:        SELECT QRY
Details:

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

But it is : t
How to acheive correct result


SELECT (DATE '2007-07-30', DATE '2007-08-01') OVERLAPS (DATE '2007-07-31',
DATE '2007-07-31')
Returns : t

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