The ability to update multiple columns (tuples) with a single SET operator

UPDATE foo
  SET (a,b) = (SELECT c,d FROM bar WHERE bar.f_id = foo.id);
An alternative to this are joins in the UPDATE statement

Back to the SQL Feature Comparison