Re: [SQL] outer joins strangeness

[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