UPDATE [ ONLY ] table SET col = expression [, ...] [ FROM fromlist ] [ WHERE condition ]
Is this valid:
UPDATE table1 SET col = table2.col FROM table2 WHERE col = table2.id;