Re: What's the difference?

Victor Wagner <vitus@ice.ru> writes:
>> Same results, but the second two constrain the planner's choice of join
>> order.  See

>> http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/explicit-joins.html

>> Whether this is a feature or a bug depends on context...

>> regards, tom lane

> I can agree that this is feature if one uses natural or inner joins.

> But if query semantic needs outer joins there is no way to tell the
> planner that it is free to choose order of joining.

But it is *not* free to alter the join order of outer joins; if it does,
that will change the result.  See the discussion on the above-linked
page.

            regards, tom lane