Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 90432633638 for ; Fri, 19 Feb 2010 06:33:29 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 83541-08 for ; Fri, 19 Feb 2010 10:33:18 +0000 (UTC) Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by mail.postgresql.org (Postfix) with ESMTP id A0557632E94 for ; Fri, 19 Feb 2010 06:33:15 -0400 (AST) X-Greylist: delayed 01:06:15.085449 by SQLgrey-1.7.6 Received: from ppsw-6.csi.cam.ac.uk (ppsw-6.csi.cam.ac.uk [131.111.8.136]) by mx3.hub.org (Postfix) with ESMTP id 0183437B4F5 for ; Fri, 19 Feb 2010 06:33:14 -0400 (AST) X-Cam-AntiVirus: no malware found X-Cam-SpamDetails: not scanned X-Cam-ScannerInfo: http://www.cam.ac.uk/cs/email/scanner/ Received: from pantagruel.csi.private.cam.ac.uk ([172.28.10.198]:6155 helo=panurge.staff-ad.csi.cam.ac.uk) by ppsw-6.csi.cam.ac.uk (ppsw.cam.ac.uk [131.111.8.136]:25) with esmtp id 1NiQ9V-0002MW-Jr (Exim 4.70) for pgsql-sql@postgresql.org (return-path ); Fri, 19 Feb 2010 10:32:05 +0000 Received: from Panurge.staff-ad.csi.cam.ac.uk (131.111.10.208) by pantagruel.staff-ad.csi.private.cam.ac.uk (172.28.10.198) with Microsoft SMTP Server (TLS) id 8.1.393.1; Fri, 19 Feb 2010 10:32:56 +0000 Received: from gargantua.staff-ad.csi.cam.ac.uk ([172.28.10.197]) by Panurge.staff-ad.csi.cam.ac.uk ([131.111.10.208]) with mapi; Fri, 19 Feb 2010 10:33:46 +0000 From: Gordon Ross To: "pgsql-sql@postgresql.org" Date: Fri, 19 Feb 2010 10:32:03 +0000 Subject: Re: Unable to get UPDATE ... FROM syntax correct Thread-Topic: [SQL] Unable to get UPDATE ... FROM syntax correct Thread-Index: AcqxTnu398aNMCWWRSelqZTh7NKaAAAAErSR Message-ID: In-Reply-To: Accept-Language: en-US Content-Language: en X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201002/77 X-Sequence-Number: 33676 On 19/02/2010 10:28, "zkn" wrote: > update audit set key =3D (select extension.number from extension where > audit.record_id =3D extension_id) No joy, I still get "UPDATE 0" :-( GTG