• Tom Lane's avatar
    Doc: call out UPDATE syntax change as a v10 compatibility issue. · 86182b18
    Tom Lane authored
    The change made by commit 906bfcad means that if you're writing
    a parenthesized column list in UPDATE ... SET, but that column list
    is only one column, you now need to write ROW(expression) on the
    righthand side, not just a parenthesized expression.  This was an
    intentional change for spec compatibility and potential future
    expansion of the possibilities for the RHS, but I'd neglected to
    document it as a compatibility issue, figuring that hardly anyone
    would bother with parenthesized syntax for a single target column.
    I was wrong, as shown by questions from Justin Pryzby, Adam Brusselback,
    and others.  Move the release note item into the compatibility section
    and point out the behavior change for a single target column.
    
    Discussion: https://postgr.es/m/CAMjNa7cDLzPcs0xnRpkvqmJ6Vb6G3EH8CYGp9ZBjXdpFfTz6dg@mail.gmail.com
    86182b18
release-10.sgml 106 KB