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