Re: "writable CTEs" - Mailing list pgsql-hackers

From David Fetter
Subject Re: "writable CTEs"
Date
Msg-id 20101222195449.GA25028@fetter.org
Whole thread Raw
In response to Re: "writable CTEs"  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Wed, Dec 22, 2010 at 12:54:39PM -0600, Kevin Grittner wrote:
> Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi> wrote:
>  
> > I think I've used "DML WITH" in the patch, but I don't like that
> > either.  Naming this feature seems to be quite a challenge.
> > 
> > I'd prefer something short but easily understandable, but those
> > two might be mutually exclusive.
>  
> How about?:
>  
> DML CTEs
> DML-based CTEs
> RETURNING-based CTEs

When I designed the feature, I'd planned to be able to put most kinds
of statement inside or outside the CTE, not just DML writes.  You can
imagine cases for DCL (GRANT/REVOKE based on a catalog query) or DDL
(partition management), and I did.

We could call them, "Expanded CTEs," but that only freezes the prior
norm making them read-only, so I think "Writeable CTEs" captures it
pretty well.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: "writable CTEs"
Next
From: Alex Hunsaker
Date:
Subject: Re: plperlu problem with utf8