Referring to the syntax for updating a table from a temp table at "Update a field in a table using a value from another table ..." at
http://www.cryer.co.uk/brian/sql/sql_crib_sheet.htm
Is this the correct syntax for PG for updating a table from a temp table?