Re: Why overlaps is not working

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: Why overlaps is not working
Дата
Msg-id 033601c7071e$c1684d40$2300b3a8@Andrus
обсуждение исходный текст
Ответ на Re: Why overlaps is not working  (Richard Broersma Jr <rabroersma@yahoo.com>)
Ответы Overlap flags (Was: Re: Why overlaps is not working)  (Alban Hertroys <alban@magproductions.nl>)
Re: Why overlaps is not working  ("Ian Harding" <iharding@destinydata.com>)
Список pgsql-general
> What you meant to test is:
>
>  select (date '20060101'::timestamp,
>     coalesce(NULL, 'infinity'::timestamp))
>  overlaps
>  (date '20060102'::timestamp,
>     coalesce(NULL, 'infinity'::timestamp))
>
> Which returns true.

Alban,

If first period end and second period start dates are the same, I need that in this case expression
returns true.
Is it possible to implement this using OVERLAPS operator ?

Andrus.


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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Why overlaps is not working
Следующее
От: Alban Hertroys
Дата:
Сообщение: Overlap flags (Was: Re: Why overlaps is not working)