[moved to hackers] On Mon, 24 Sep 2001, Stephan Szabo wrote:
> > Postgres should understand that left outer join does not constrict join > > order... > > But it can. If your condition was a joining between the other table > and the right side of the left outer join, you'd have the same condition > as a right outer join and the left side. The real condition I think > is that you can join a non-explicitly joined table to the <x> side of an > <x> outer join before the outer join but not to the other side. Yes yes. Maybe I was imprecise. Right join and left join are the same, only the ordering is different. Lets call the table that will always be included in a join a "complete" table. Then, joins should not impose join order on "complete" table. Of course, joins against 'incomplete' table must be done only after outer join is done. Anyone who can actually fix it? :) -alex ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
