Alvaro Herrera <[EMAIL PROTECTED]> writes: > Alexander Staubo escribió: >> Are you sure? I was under the impression that PostgreSQL could reorder >> "where" clauses, but did not yet reorder explicit joins (as opposed >> to implicit ones through, say, "in"). But perhaps it only applied to >> some types of joins.
> Postgres does flatten joins, and reorders the resulting range tables as > convenient. Only in 8.2 it learned how to to reorder outer joins, but > for inner joins this has been in place for a lot longer. The rules for this have changed over time, and you can affect them through planner parameters too. Consult http://www.postgresql.org/docs/8.2/static/explicit-joins.html ^^^ with URL adjusted for your PG version. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
