Re: BUG #6192: Incorrect result from operator "overlaps"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #6192: Incorrect result from operator "overlaps"
Дата
Msg-id 10338.1314891559@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #6192: Incorrect result from operator "overlaps"  ("Incorrect result from operator "overlaps"" <wolfmoon@o2.pl>)
Список pgsql-bugs
"Incorrect result from operator "overlaps"" <wolfmoon@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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Vik Reykja
Дата:
Сообщение: Re: BUG #6192: Incorrect result from operator "overlaps"
Следующее
От: "farta"
Дата:
Сообщение: BUG #6193: The one-click installer failed to unpack