| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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:10:25 |
| Message-ID: | 20070410011025.GJ27243@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
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.
Cheers,
D
--
David Fetter <david(at)fetter(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-04-10 01:15:12 | Re: Clear up strxfrm() in UTF-8 with locale on Windows |
| Previous Message | Tom Lane | 2007-04-10 01:08:31 | Re: non-recursive WITH clause support |