Re: "two time periods with only an endpoint in common do not overlap" ???

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bryn Llewellyn <bryn(at)yugabyte(dot)com>
Cc: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: "two time periods with only an endpoint in common do not overlap" ???
Date: 2021-10-14 23:54:54
Message-ID: 911807.1634255694@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bryn Llewellyn <bryn(at)yugabyte(dot)com> writes:
> I tried this obvious test (using Version 13.4):

> with c as (
> select
> '2000-01-15'::timestamp as start_1,
> '2000-02-15'::timestamp as start_2,
> '2000-03-15'::timestamp as common_endpoint)
> select (
> (start_1, common_endpoint) overlaps
> (start_2, common_endpoint)
> )::text
> from c;

> The result is "true". Seems to me that the doc is therefore wrong

Huh? Those intervals have lots of points in common, not only a
single point. The documentation is referring to a case like your
second example.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2021-10-15 00:02:22 Re: "two time periods with only an endpoint in common do not overlap" ???
Previous Message Bryn Llewellyn 2021-10-14 23:38:38 "two time periods with only an endpoint in common do not overlap" ???