We're updating the issue view to help you get more done. 

Implement UPDATE with result set

Description

Add an UPDATE operation that returns a result set of the changed rows to the client.

1 2 3 4 5 6 UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ... [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] RETURNING select_expr [, select_expr ...]

I'm not exactly sure how the corresponding multiple-table syntax should look like, or if it is possible at all. But already having it for single-table updates would be a nice feature.

Environment

None

Status

Assignee

Unassigned

Reporter

Heinz Wiesinger

Priority

Minor