Postgres Pro
Downloads
Home   >   mailing lists

Re: nested view with outer joins - best practices - Mailing list pgsql-general

From Tom Lane
Subject Re: nested view with outer joins - best practices
Date
Msg-id 19113.1213022476@sss.pgh.pa.us
Whole thread Raw
In response to nested view with outer joins - best practices  (Bohdan Linda <bohdan.linda@seznam.cz>)
Responses Re: nested view with outer joins - best practices
List pgsql-general
Tree view 
Bohdan Linda <bohdan.linda@seznam.cz> writes:
> 2) Will my plan get better with new version of pgsql ( currently its 8.0.x )

8.0 is incapable of reordering outer joins, which is likely the cause of
your problem.

            regards, tom lane

pgsql-general by date:

Previous
From: Bohdan Linda
Date:
Subject: nested view with outer joins - best practices
Next
From: "Roberts, Jon"
Date:
Subject: "connect by"