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  (Alban Hertroys <alban@magproductions.nl>)
Re: Why overlaps is not working  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список 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 по дате отправления:

Предыдущее
От: "Leif B. Kristensen"
Дата:
Сообщение: Re: Table design - unknown number of column
Следующее
От: Matthias.Pitzl@izb.de
Дата:
Сообщение: Re: Why overlaps is not working