Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 53410633AA7
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 19 Feb 2010 06:59:04 -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 88725-03-3 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 19 Feb 2010 10:58:53 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from ppsw-0.csi.cam.ac.uk (ppsw-0.csi.cam.ac.uk [131.111.8.130])
	by mail.postgresql.org (Postfix) with ESMTP id 0E85F633128
	for <pgsql-sql@postgresql.org>; Fri, 19 Feb 2010 06:58:30 -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]:6201
	helo=panurge.staff-ad.csi.cam.ac.uk)
	by ppsw-0.csi.cam.ac.uk (ppsw.cam.ac.uk [131.111.8.130]:25)
	with esmtp id 1NiQZ2-0002vU-0o (Exim 4.70) for pgsql-sql@postgresql.org
	(return-path <gr306@ucs.cam.ac.uk>); Fri, 19 Feb 2010 10:58:28 +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:59:19 +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 11:00:09 +0000
From: Gordon Ross <gr306@ucs.cam.ac.uk>
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Date: Fri, 19 Feb 2010 10:58:24 +0000
Subject: Re: Unable to get UPDATE ... FROM syntax correct
Thread-Topic: [SQL] Unable to get UPDATE ... FROM syntax correct
Thread-Index: AcqxT57pofycAbAsTk6oRwEFzNZrtgAAtX46
Message-ID: <C7A41F50.4759%gr306@staff-ad.csi.cam.ac.uk>
In-Reply-To: <4B7E69A5.4060705@archonet.com>
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/80
X-Sequence-Number: 33679

On 19/02/2010 10:36, "Richard Huxton" <dev@archonet.com> wrote:

> Works here - are you sure you don't have any triggers interfering?

Doh ! *blush*

Yes, I did, to stop anyone tampering with the audit table ;-)

Thanks for that.

GTG