Victor Wagner <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster