Allow update table a,b,c = (select x,y,z )
Allow to update multiple field in a table with a subselect
Why this is still marked as Planned?
Hans Castorp commented
This has been implemented for 9.5
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?