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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Guyren Howe <guyren(at)gmail(dot)com>, Ron <ronljohnsonjr(at)gmail(dot)com>, Brian Dunavant <dunavant(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <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-15 20:01:11
Message-ID: 5084ffda-c04a-98ba-db01-3fec9c735863@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/15/21 12:26, Guyren Howe wrote:
> I’m a bit confused by this conversation. Open- and closed-ended ranges
> behave as I would expect.

What is the part that confused you?

>
> select tsrange('2016-01-10 17:00', '2016-01-11 17:00', '[)') &&
> tsrange('2016-01-11 17:00', '2016-01-12 17:00', '[]')
> false
>
> select tsrange('2016-01-10 17:00', '2016-01-11 17:00', '[]') &&
> tsrange('2016-01-11 17:00', '2016-01-12 17:00', '[]')
> true

>>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2021-10-16 02:42:36 Re: "two time periods with only an endpoint in common do not overlap" ???
Previous Message Seref Arikan 2021-10-15 19:28:29 Re: Stuck: how can I disable automatic json array unwrapping?