Re: Improving planning of outer joins - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Improving planning of outer joins
Date
Msg-id 28851.1134764284@sss.pgh.pa.us
Whole thread Raw
In response to Re: Improving planning of outer joins  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Improving planning of outer joins  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Improving planning of outer joins
Next
From: Alvaro Herrera
Date:
Subject: Re: Improving planning of outer joins