The following bug has been logged online:
Bug reference: 3469
Logged by: SRIDHARAN
Email address: sridharan(at)avanttec(dot)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