> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org