The following bug has been logged online: Bug reference: 3469 Logged by: SRIDHARAN Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
