Re: UPDATE COMPATIBILITY

Gera Mel Handumon, 17.01.2012 07:31:
> What version of postgresql that the update compatibility below will be
> implemented?
>
> UPDATE COMPATIBILITY
>
>
> UPDATE accounts SET (contact_last_name, contact_first_name) =
>      (SELECT last_name, first_name FROM salesmen
>       WHERE salesmen.id = accounts.sales_id);

None as far as I know.

You need to rewrite it to:

UPDATE accounts  SET contact_last_name = s.last_name,      contact_first_name = s.first_name
FROM salesmen s
WHERE s.id = accounts.sales_id