SQL2011 and writeable CTE

From: Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: SQL2011 and writeable CTE
Date: 2010-11-07 12:28:30
Message-ID: AANLkTinHRL+20=G--EO0D5WsJSY2=9d-pQ5WHg5LHerb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I've read this Peter's post:

http://petereisentraut.blogspot.com/2010/04/news-from-sql-standard.html

which says in SQL2011 has a new feature:

> Combined data change and retrieval. PostgreSQL does something like this with RETURNING, but this feature is more elaborate and allows the writing of "delta tables".

And I heard from sources that this "delta table" contains something
like writeable CTEs. Couldn't you share something about it if
possible? I just don't like to design something that will be similar
to but different from the standard.

Regards,

--
Hitoshi Harada

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hitoshi Harada 2010-11-07 13:02:21 How to share the result data of separated plan
Previous Message Daniel Farina 2010-11-07 11:42:12 Re: ALTER TABLE ... IF EXISTS feature?