Re: "writable CTEs"

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