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

[Adrian Klaver]

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.kla...@aklaver.com