What you meant to test is:
select (date '20060101'::timestamp,
coalesce(NULL, 'infinity'::timestamp))
overlaps
(date '20060102'::timestamp,
coalesce(NULL, 'infinity'::timestamp))
Which returns true.
Alban,If first period end and second period start dates are the same, I need that in this case expression returns true.
Is it possible to implement this using OVERLAPS operator ?Andrus.
