On Thu, Oct 05, 2006 at 09:30:45AM -0400, Merlin Moncure wrote: > I personally only use explicit joins when doing outer joins and even > them push them out as far as possible.
I used to be like that too, until I actually started using join syntax. I now find it's *way* easier to identify what the join conditions are, and to seperate them from the rest of the where clause. It also makes it pretty much impossible to mess up a join clause and get a cartesian product. If you are going to put the join clauses in the WHERE clause, at least put a space between the join stuff and the rest of the WHERE clause. In any case, this is nothing but a matter of taste in this case, unless you set join_collapse_limit to less than 3 (or maybe 4). -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq