From 51aebcd78a4a0674737319a804ff761800fa6830 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 22 Nov 2016 18:07:43 -0500 Subject: [PATCH] Doc: in back branches, don't call it a row constructor if it isn't really. Before commit 906bfcad7, we were not actually processing the righthand side of a multiple-column assignment in UPDATE as a row constructor: it was just a parenthesized list of expressions. Call it that rather than risking confusion by people who would expect the documented behaviors of row constructors to apply. Back-patch to 9.5; before that, the text correctly described the construct as a "list of independent expressions". Discussion: <16288.1479610770@sss.pgh.pa.us> --- doc/src/sgml/ref/update.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/ref/update.sgml b/doc/src/sgml/ref/update.sgml index c50434f85f..e80cf9cb78 100644 --- a/doc/src/sgml/ref/update.sgml +++ b/doc/src/sgml/ref/update.sgml @@ -422,9 +422,9 @@ UPDATE films SET kind = 'Dramatic' WHERE CURRENT OF c_films; According to the standard, the source value for a parenthesized sub-list of column names can be any row-valued expression yielding the correct number of columns. PostgreSQL only allows the source - value to be a parenthesized list of expressions (a row constructor) or a + value to be a parenthesized list of expressions or a sub-SELECT. An individual column's updated value can be - specified as DEFAULT in the row-constructor case, but not + specified as DEFAULT in the list-of-expressions case, but not inside a sub-SELECT. -- 2.40.0