Allow update table a,b,c = (select x,y,z )
Allow to update multiple field in a table with a subselect
Well, in that case not much, but the subselect could of course be more complex.
Radomirs Cirskis commented
What's wrong with:
UPDATE table SET a = x, b = y, ...
Mike Christensen commented
Oh, can this include the IN statement as well. Such as: select * from Foo where x, y in ((1,2), (3,4));
That would rock! Yes, it's just syntax sugar but sugar is tasty.
Because this syntax would be standard-conforming.
This is possible to do now http://stackoverflow.com/q/3645704/159550
Why this special syntax required?