这是Postgres UPDATe JOIN格式:
UPDATE address SET cid = customers.idFROM customers WHERe customers.id = address.id
这是其他变体:http : //mssql-to-
postgresql.blogspot.com/2007/12/updates-in-postgresql-ms-sql-
mysql.html

这是Postgres UPDATe JOIN格式:
UPDATE address SET cid = customers.idFROM customers WHERe customers.id = address.id
这是其他变体:http : //mssql-to-
postgresql.blogspot.com/2007/12/updates-in-postgresql-ms-sql-
mysql.html