set datestyle to iso,iso; select 1 where ('2006-10-31'::date, '9999-12-31'::date) OVERLAPS ('2006-10-16'::DATE, '2006-10-31':: DATE) does not return any rows. Why ? How to make overlaps to return correct result? Andrus.
set datestyle to iso,iso; select 1 where ('2006-10-31'::date, '9999-12-31'::date) OVERLAPS ('2006-10-16'::DATE, '2006-10-31':: DATE) does not return any rows. Why ? How to make overlaps to return correct result? Andrus.