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

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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.klaver@xxxxxxxxxxx