> While I don't see the syntax of:
>
> update table set (col...) = ( val...)
>
> as valuable compared to separate col=val assignments, I do see a value
> in allowing subqueries in such assignments:
>
> update table set (col...) = ( select val ..)
>
> Without it, you have to do separate subquery statements, and if they are
> complex, that is a waste. I assume that was the motivation for the
> feature.
The number of times I've needed this feature... :)
Chris