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.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to