And from _PostgreSQL Interactive Documentation (http://www.postgresql.org/idocs/index.php?sql-update.html):
UPDATE [ ONLY ] table SET col = expression [, ...] [ FROM fromlist ] [ WHERE condition ] fromlist A Postgres non-standard extension to allow columns from other ... ^^^^^^^^^^^^^^^^^^^^^^ -- Jeff