Re: non-recursive WITH clause support

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Fetter <david(at)fetter(dot)org>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: non-recursive WITH clause support
Date: 2007-04-10 01:08:31
Message-ID: 15913.1176167311@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

David Fetter <david(at)fetter(dot)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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message David Fetter 2007-04-10 01:10:25 Re: non-recursive WITH clause support
Previous Message Bruce Momjian 2007-04-10 01:07:49 Re: UTF8MatchText