Re: Improving planning of outer joins

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Improving planning of outer joins
Дата
Msg-id 28851.1134764284@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Improving planning of outer joins  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Improving planning of outer joins  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> I wonder if the code is already able to transform right joins to left
> joins, like
>     (A rightjoin B on (Pab)) = (B leftjoin A on (Pab))

Yeah, we already know that part.  It's a freebie --- I didn't even
bother mentioning rightjoin in my post, since it's equivalent to
leftjoin after swapping the inputs.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Improving planning of outer joins
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Improving planning of outer joins