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

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: "two time periods with only an endpoint in common do not overlap" ???
Дата
Msg-id 5084ffda-c04a-98ba-db01-3fec9c735863@aklaver.com
обсуждение исходный текст
Ответ на Re: "two time periods with only an endpoint in common do not overlap" ???  (Guyren Howe <guyren@gmail.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Seref Arikan
Дата:
Сообщение: Re: Stuck: how can I disable automatic json array unwrapping?
Следующее
От: Ron
Дата:
Сообщение: Re: "two time periods with only an endpoint in common do not overlap" ???