On 2010-12-22 8:28 PM, Peter Eisentraut wrote:
As a side note, I think the term "writable CTE" is a misnomer. The CTE
is not writable. The CTE is the result of a write operation.
A writable CTE would look like this:
WITH foo AS (SELECT ...) UPDATE foo SET ...
a bit like an updatable view.
AFAICT, the current patch doesn't use the term, so there is no problem,
but just for those who are preparing propaganda and such.
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.
Regards,
Marko Tiikkaja
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers