Re: request for sql3 compliance for the update command - Mailing list pgsql-hackers

Dave Cramer writes:

> update table set (col...) = ( val...)

> It would appear that this is SQL3 compliant
>
> <set clause> ::=
>  <update target> <equals operator> <row value designator>
>
> <update target> ::=
>  <object column>
>  | <left paren> <object column list> <right paren>

That's not what my copy says.
        <set clause list> ::=             <set clause> [ { <comma> <set clause> }... ]
        <set clause> ::=               <update target> <equals operator> <update source>             | <mutated set
clause><equals operator> <update source>
 
        <update target> ::=               <object column>             | ROW             | <object column>
 <left bracket or trigraph> <simple value specification> <right bracket or trigraph>
 
        <object column> ::= <column name>

        <mutated set clause> ::=             <mutated target> <period> <method name>
        <mutated target> ::=               <object column>             | <mutated set clause>
        <update source> ::=               <value expression>             | <contextually typed value specification>

(And I'm pretty sure I have the right version of the standard.)

-- 
Peter Eisentraut   peter_e@gmx.net