Postgres Pro
Downloads
Home   >   mailing lists

overlaps behaviour - ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps ('2007-12-01'::TimeStamp, 'Infinity'::TimeStamp) - Mailing list pgsql-general

From Marek Lewczuk
Subject overlaps behaviour - ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps ('2007-12-01'::TimeStamp, 'Infinity'::TimeStamp)
Date
Msg-id daadfdc20902230810n535c2bccr1518eebcee97491c@mail.gmail.com
Whole thread Raw
Responses Re: overlaps behaviour - ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps ('2007-12-01'::TimeStamp, 'Infinity'::TimeStamp)
List pgsql-general
Tree view 
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 by date:

Previous
From: Keaton Adams
Date:
Subject: Product Roadmap question and request for recommendation
Next
From: Bill Herbert
Date:
Subject: Problem setting up PostgreSQL