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