Peter, Referring to
http://src.doc.ic.ac.uk/packages/dbperl/refinfo/sql3/sql3bnf.sep93.txt the following grammar exists is the reference above valid? as for tom's reply there are left paren, and right paren. Dave On Wed, 2003-02-19 at 10:37, Peter Eisentraut wrote: > 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.) -- Dave Cramer <[EMAIL PROTECTED]> Cramer Consulting ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])