"Incorrect result from operator "overlaps"" <wolfm...@o2.pl> writes: > SELECT ('2011-08-31'::date,'2011-08-31'::date) overlaps > ('2011-08-1'::date,'2011-08-31'::date); > Returns false, should return true.
This is correct per SQL standard. The spec is written such that an interval is considered half-open, ie ['2011-08-01', '2011-08-31'). So that does not overlap the point '2011-08-31'. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs