Re: [HACKERS] DB2-style INS/UPD/DEL RETURNING

[Jonah H. Harris]

On 3/13/06, Tom Lane <[EMAIL PROTECTED]> wrote:

Also, is the front SELECT allowed to have its own WHERE, or is it
constrained to return exactly one row per inserted/updated/deleted row?
If it can have a WHERE then there's a syntactic ambiguity in
        SELECT ... FROM NEW TABLE UPDATE ... WHERE ...

Yes, I believe it supports SELECT .. FROM NEW TABLE (UPDATE .. WHERE ..) WHERE

IBM's paper, "Returning Modified Rows--SELECT Statements with Side Effects" is here:
 http://www.isys.ucl.ac.be/vldb04/eProceedings/contents/pdf/IND1P1.PDF

I'll look up more.

--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324