Skip site navigation (1) Skip section navigation (2)

Re: non-recursive WITH clause support

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: David Fetter <david(at)fetter(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: non-recursive WITH clause support
Date: 2007-04-27 01:02:15
Message-ID: 200704270102.l3R12Fe19759@momjian.us (view raw or flat)
Thread:
Lists: pgsql-patches
This has been saved for the 8.4 release:

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

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

Gregory Stark 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.
> 
> 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(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

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

In response to

pgsql-patches by date

Next:From: Bruce MomjianDate: 2007-04-27 01:05:51
Subject: Re: [HACKERS] CIC and deadlocks
Previous:From: Bruce MomjianDate: 2007-04-27 01:01:40
Subject: Re: Reviewers Guide to Deferred Transactions/TransactionGuarantee

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group