Re: non-recursive WITH clause support - Mailing list pgsql-patches

From David Fetter
Subject Re: non-recursive WITH clause support
Date
Msg-id 20070410011025.GJ27243@fetter.org
Whole thread Raw
In response to Re: non-recursive WITH clause support  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
On Mon, Apr 09, 2007 at 09:08:31PM -0400, Tom Lane wrote:
> David Fetter <david@fetter.org> writes:
> > On Mon, Apr 09, 2007 at 06:43:08PM -0400, Tom Lane wrote:
> >> So this does not really add any new functionality, it's just variant
> >> syntax for something you can do about as easily without it, right?
>
> > Not totally as easily.  For example, you can do some kinds of
> > aggregation with a few fewer keystrokes.
>
> Example please?  It's not obvious to me what this does that wouldn't be
> exactly isomorphic to creating a temporary view.

It would be isomorphic, but happens automagically for the scope of the
query instead of being three queries.

Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: non-recursive WITH clause support
Next
From: Bruce Momjian
Date:
Subject: Re: Clear up strxfrm() in UTF-8 with locale on Windows