Why overlaps is not working

Поиск
Список
Период
Сортировка
От Andrus
Тема Why overlaps is not working
Дата
Msg-id eivbgg$2agq$1@news.hub.org
обсуждение исходный текст
Ответы Re: Why overlaps is not working
Re: Why overlaps is not working
Список pgsql-general
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.



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