Thanks Tom. This is wonderful On Thu, Nov 20, 2008 at 4:21 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Josh Harrison" <[EMAIL PROTECTED]> writes: > > My question is when I don't use the Recursive term does the optimizer > just > > consider it as a subquery or does it work like Oracle's WITH CLAUSE > > (Subquery Factoring) ? Oracle's WITH CLAUSE boosts the performance of the > > queries. So does this do the same? > > See the fine manual, for instance last para here: > http://developer.postgresql.org/pgdocs/postgres/queries-with.html > > regards, tom lane >
