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

From Tom Lane
Subject Re: non-recursive WITH clause support
Date
Msg-id 15913.1176167311@sss.pgh.pa.us
Whole thread Raw
In response to Re: non-recursive WITH clause support  (David Fetter <david@fetter.org>)
Responses Re: non-recursive WITH clause support  (David Fetter <david@fetter.org>)
List pgsql-patches
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.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: UTF8MatchText
Next
From: David Fetter
Date:
Subject: Re: non-recursive WITH clause support