I see. I think I'm going to restructure my logic so I won't have to use
the outer join after all, but thanks for the pointers anyway.
Tom Lane wrote:
Ben <bench@xxxxxxxxxxxxxxx> writes:
Hrm, as I understand that page, there's not much that can be done about
the join order for outer joins. At least, not when there's on 3 tables
and 1 outer join involved. Am I missing something?
Without knowing what you want the query to do, it's difficult to say if
it's OK to rearrange the join order.
Frequently it's OK to rearrange the join order even without risking any
change in the query results, but PG doesn't currently have any smarts
about that, so you have to do it manually by changing the query.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
