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