*** /home/jjanes/pgsql/git/src/test/regress/expected/update.out Tue Feb 14 12:42:48 2017 --- /home/jjanes/pgsql/git/src/test/regress/results/update.out Tue Feb 14 15:15:30 2017 *************** *** 148,154 **** WHERE update_test.a = v.i; ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression LINE 1: UPDATE update_test SET (a,b) = (v.*) FROM (VALUES(21, 101)) ... ! ^ -- if an alias for the target table is specified, don't allow references -- to the original table name UPDATE update_test AS t SET b = update_test.b + 10 WHERE t.a = 10; --- 148,154 ---- WHERE update_test.a = v.i; ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression LINE 1: UPDATE update_test SET (a,b) = (v.*) FROM (VALUES(21, 101)) ... ! ^ -- if an alias for the target table is specified, don't allow references -- to the original table name UPDATE update_test AS t SET b = update_test.b + 10 WHERE t.a = 10; ======================================================================