Re: 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 Re: overlaps behaviour - ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps ('2007-12-01'::TimeStamp, 'Infinity'::TimeStamp)
Date
Msg-id daadfdc20902231338q3851fa13kbeea36d7abe30686@mail.gmail.com
Whole thread Raw
List pgsql-general
2009/2/23 Marek Lewczuk <marek@lewczuk.com>:
> 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
Ok. Sorry for that question. I found SQL92 definition and it seems,
that PG implementation is just fine.

Best regards,
ML

pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Re: Backup Strategy Second Opinion
Next
From: Scott Marlowe
Date:
Subject: Re: Product Roadmap question and request for recommendation