| From: | Vik Reykja <vikreykja(at)gmail(dot)com> |
|---|---|
| To: | Incorrect result from operator <wolfmoon(at)o2(dot)pl> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #6192: Incorrect result from operator "overlaps" |
| Date: | 2011-09-01 15:31:58 |
| Message-ID: | CALDgxVsBuicp6N74CG3+A6bNcOwHkwFooU+JE=SQzU1_bZERWg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thu, Sep 1, 2011 at 10:27, Incorrect result from operator <wolfmoon(at)o2(dot)pl
> wrote:
>
> SELECT ('2011-08-31'::date,'2011-08-31'::date) overlaps
> ('2011-08-1'::date,'2011-08-31'::date);
> Returns false, should return true.
>
According to the documentation, it should return false.
"Each time period is considered to represent the half-open interval start <=
time < end, unless start and end are equal in which case it represents that
single time instant. This means for instance that two time periods with only
an endpoint in common do not overlap."
http://www.postgresql.org/docs/current/static/functions-datetime.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-09-01 15:39:19 | Re: BUG #6192: Incorrect result from operator "overlaps" |
| Previous Message | Michael Meskes | 2011-09-01 13:48:37 | Re: ECPGdo fails to restore LC_NUMERIC |