Re: Question about the WITH RECURSIVE patch

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about the WITH RECURSIVE patch
Date: 2008-11-20 21:52:49
Message-ID: gg4m7h$tij$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote on 20.11.2008 22:21:
> "Josh Harrison" <joshques(at)gmail(dot)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
>

Cool :)

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 them. Does that mean they
won't make it or that simply the documentation isnt't yet there?

Cheers
Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2008-11-20 21:56:37 Re: Question about the WITH RECURSIVE patch
Previous Message Josh Harrison 2008-11-20 21:33:16 Re: Question about the WITH RECURSIVE patch