Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about the WITH RECURSIVE patch - Mailing list pgsql-general

From Tom Lane
Subject Re: Question about the WITH RECURSIVE patch
Date
Msg-id 8164.1227216064@sss.pgh.pa.us
Whole thread Raw
In response to Question about the WITH RECURSIVE patch  ("Josh Harrison" <joshques@gmail.com>)
Responses Re: Question about the WITH RECURSIVE patch
Re: Question about the WITH RECURSIVE patch
Re: Question about the WITH RECURSIVE patch
List pgsql-general
Tree view 
"Josh Harrison" <joshques@gmail.com> 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

pgsql-general by date:

Previous
From: "Josh Harrison"
Date:
Subject: Question about the WITH RECURSIVE patch
Next
From: Christophe
Date:
Subject: Re: Question about the WITH RECURSIVE patch