overlaps behaviour - ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps ('2007-12-01'::TimeStamp, 'Infinity'::TimeStamp)

Поиск
Список
Период
Сортировка
От Marek Lewczuk
Тема overlaps behaviour - ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps ('2007-12-01'::TimeStamp, 'Infinity'::TimeStamp)
Дата
Msg-id daadfdc20902230810n535c2bccr1518eebcee97491c@mail.gmail.com
обсуждение исходный текст
Ответы Re: overlaps behaviour - ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps ('2007-12-01'::TimeStamp, 'Infinity'::TimeStamp)  (Adrian Klaver <aklaver@comcast.net>)
Список pgsql-general
Дерево обсуждения 
Hello,
I can't find SQL definition for OVERLAPS operator so I don't know
whether following expression's result (false) is appropriate
behaviour:
select ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps
('2007-12-01'::TimeStamp, 'Infinity'::TimeStamp)

Can anyone confirm that ? In my understanding of "overlaps" it should
result true, as those two periods overlaps in 2007-12-01.

psql (PostgreSQL) 8.3.5

Best regards,
ML

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

Предыдущее
От: Keaton Adams
Дата:
Сообщение: Product Roadmap question and request for recommendation
Следующее
От: Bill Herbert
Дата:
Сообщение: Problem setting up PostgreSQL