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