Синяя социальная система управления закладками и публикациями.
Log in with your username.
Я забыл свой пароль.
Log in with your OpenID-Provider.
Postgres allows:
UPDATE dummy SET customer=subquery.customer, address=subquery.address, partn=subquery.partn FROM (SELECT address_id, customer, address, partn FROM /* big hairy SQL */ ...) AS subquery WHERE dummy.address_id=subquery.address_id;
This syntax is not standard SQL