postgres.git / summary / log / commit / refs

commit    51aebcd78a4a0674737319a804ff761800fa6830
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Tue Nov 22 23:07:43 2016 +0000

    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 c50434f85f9..e80cf9cb785 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. <productname>PostgreSQL</productname> 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-<literal>SELECT</>. An individual column's updated value can be - specified as <literal>DEFAULT</> in the row-constructor case, but not + specified as <literal>DEFAULT</> in the list-of-expressions case, but not inside a sub-<literal>SELECT</>. </para> </refsect1> [parent: 112676f59033]