Re: Question about the WITH RECURSIVE patch

["Josh Harrison" <joshques@xxxxxxxxx>]

Thanks Tom. This is wonderful

On Thu, Nov 20, 2008 at 4:21 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

"Josh Harrison" <joshques@xxxxxxxxx> 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