"Incorrect result from operator "overlaps"" <wolfmoon(at)o2(dot)pl> writes:
> SELECT ('2011-08-31'::date,'2011-08-31'::date) overlaps
> 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
In response to
pgsql-bugs by date
|Next:||From: farta||Date: 2011-09-01 16:57:33|
|Subject: BUG #6193: The one-click installer failed to unpack|
|Previous:||From: Vik Reykja||Date: 2011-09-01 15:31:58|
|Subject: Re: BUG #6192: Incorrect result from operator "overlaps"|