Re: "writable CTEs"

On Tue, Dec 28, 2010 at 11:07:59PM +0000, Peter Geoghegan wrote:
> On 28 December 2010 20:07, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> > The phrase "common table expression" does not appear anywhere in the SQL
> > standard.  The standard uses the grammar symbol <with clause>.
>
> I think we're losing sight of the issue a bit here.
>
> No one is proposing that we call WITH queries common table
> expressions. As I think we all agree, the term "WITH query" and
> "common table expression" are not synonymous. A WITH query is
> comprised of one or more common table expressions, plus a conventional
> SELECT query.

As of 9.1, the thing appended to the CTE(s) can be a conventional DML
query (SELECT, INSERT, UPDATE or DELETE). I'm hoping to expand this
in future versions. :)

> All that I'm asking is that we /specify/ that the "subqueries"
> already mentioned in the docs are common table expressions.

+1

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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