Hi,
I tried the 8.4-devel version and the CTE (Common Table Expression -WITH
RECURSIVE ) patch is working pretty good.
I just have a question
These are the queries their plan .
The first query uses RECURSIVE keyword (and has a recursive and
non-recursive term as CTE) while the second query uses
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?
On Nov 20, 2008, at 1:21 PM, Tom Lane wrote:
See the fine manual, for instance last para here:
http://developer.postgresql.org/pgdocs/postgres/queries-with.html
Fine manual indeed... this the best explanation of WITH RECURSIVE
I've ever read. Kudos to the documentation writer(s).
--
Sent
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
Tom Lane wrote on 20.11.2008 22:21:
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
Thomas Kellerer wrote:
Tom Lane wrote on 20.11.2008 22:21:
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
Bruce Momjian wrote on 20.11.2008 22:56:
From http://umitanuki.net/pgsql/wfv08/design.html I got the impression that
windowing functions will make into (at least partially) into 8.4 because on that
page several items are marked with [DONE].
I can't see anything in the developer docs regarding
Thomas Kellerer wrote:
Bruce Momjian wrote on 20.11.2008 22:56:
From http://umitanuki.net/pgsql/wfv08/design.html I got the impression
that
windowing functions will make into (at least partially) into 8.4 because
on that
page several items are marked with [DONE].
I can't see