Re: Improving planning of outer joins

Tom Lane wrote:
> 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.

Why the thing about the mergejoinable conditions then?  Is that even
true?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support