On Mon, Apr 09, 2007 at 09:08:31PM -0400, Tom Lane wrote:
> 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.
It would be isomorphic, but happens automagically for the scope of the
query instead of being three queries.
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate
In response to
pgsql-patches by date
|Next:||From: Bruce Momjian||Date: 2007-04-10 01:15:12|
|Subject: Re: Clear up strxfrm() in UTF-8 with locale on
|Previous:||From: Tom Lane||Date: 2007-04-10 01:08:31|
|Subject: Re: non-recursive WITH clause support |