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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
