View Single Post

   
  #8 (permalink)  
Old 04-18-2008, 09:59 AM
Bruce Momjian
 
Posts: n/a
Default Re: non-recursive WITH clause support


This has been saved for the 8.4 release:

http://momjian.postgresql.org/cgi-bin/pgpatches_hold

---------------------------------------------------------------------------

Gregory Stark 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.

>
> I think "fewer keystrokes" is exactly what Tom meant by a variant syntax
> without new functionality. That's an accurate description.
>
> I suppose it depends in part on how important we think it is to add variant
> syntaxes just because they're blessed by the ANSI standard. If this were a
> syntax we were creating just for our user's convenience it would be a pretty
> weak justification for an incompatibility. But if there are users who expect
> this syntax to work because it's standard then it could be considered an
> omission in our standards compliance.
>
> I'm actually not too sure what the answer is. I hadn't heard of it before the
> discussion about recursive queries myself.
>
> --
> Gregory Stark
> EnterpriseDB http://www.enterprisedb.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster


--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply With Quote