Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 1201F1DA4C1D
	for <pgsql-sql@postgresql.org>; Tue, 17 Jan 2012 04:49:04 -0400 (AST)
Received: from lo.gmane.org ([80.91.229.12])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1Rn4iw-0005wM-NH
	for pgsql-sql@postgresql.org; Tue, 17 Jan 2012 08:49:05 +0000
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1Rn4ii-0008Tg-SG
	for pgsql-sql@postgresql.org; Tue, 17 Jan 2012 09:48:44 +0100
Received: from 217.110.94.67 ([217.110.94.67])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Tue, 17 Jan 2012 09:48:44 +0100
Received: from spam_eater by 217.110.94.67 with local (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Tue, 17 Jan 2012 09:48:44 +0100
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-sql@postgresql.org
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: Re: UPDATE COMPATIBILITY
Date: Tue, 17 Jan 2012 09:49:44 +0100
Lines: 21
Message-ID: <jf3cl1$bap$1@dough.gmane.org>
References: 
 <CAOeONq5n2B8VNTghx1=_=zOjNbVRff4YE=kVngGfL2etrg79Pw@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: 217.110.94.67
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
In-Reply-To: 
 <CAOeONq5n2B8VNTghx1=_=zOjNbVRff4YE=kVngGfL2etrg79Pw@mail.gmail.com>
X-Pg-Spam-Score: -3.0 (---)
X-Archive-Number: 201201/69
X-Sequence-Number: 36240

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