Re: Rangejoin rebased

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Rangejoin rebased
Дата
Msg-id CAMp0ubfDLLtnbaHUFEThK5gOx01j4gEAL65UD565oBYx1KszWA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Rangejoin rebased  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Rangejoin rebased
Список pgsql-hackers
On Fri, Jan 19, 2018 at 2:07 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> err... that isn't correct. An empty range matches nothing, so can be
> ignored in joins.
>
> So probably best to explain some more, please.

The semantics of R1 @> R2 will return true if R1 is a non-NULL range
and R2 is empty.

It's set semantics, and all sets contain the empty set.

But I understand @> is an important case so I am looking into it.

Regards,
    Jeff Davis


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Refactoring identifier checks to consistently usestrcmp
Следующее
От: Ashutosh Sharma
Дата:
Сообщение: Query related to alter table ... attach partition