Re: "two time periods with only an endpoint in common do not overlap" ??? - Mailing list 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.klaver@aklaver.com