Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)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