On Wed, 6 Jul 2005, Dario wrote:
>
> (first at all, sorry for my english)
> Hi.
> - Does "left join" restrict the order in which the planner must join
> tables? I've read about join, but i'm not sure about left join...
Yes. Reordering the outer joins can change the results in some cases which
would be invalid. Before we can change the ordering behavior, we really
need to know under what conditions it is safe to do the reordering.