Received: from wallace.ece.rice.edu (root@wallace.ece.rice.edu [128.42.12.154]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA11145 for ; Mon, 28 Jun 1999 10:37:00 -0400 (EDT) (envelope-from reedstrm@wallace.ece.rice.edu) Received: by wallace.ece.rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-sql@postgresql.org; Mon, 28 Jun 1999 09:37:00 -0500 (CDT) Date: Mon, 28 Jun 1999 09:37:00 -0500 From: "Ross J. Reedstrom" To: pgsql-sql@postgresql.org Subject: Re: [SQL] Using Update Message-ID: <19990628093700.A27076@wallace.ece.rice.edu> References: <377731EB.AACAEA8B@thinx.ch> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.3i In-Reply-To: ; from Herouth Maoz on Mon, Jun 28, 1999 at 12:13:49PM +0300 On Mon, Jun 28, 1999 at 12:13:49PM +0300, Herouth Maoz wrote: A minor nit here. postgresql doesn't like class qualifications on the field name tagets in an update (at least with 6.4.2), so the set line needs to lose the "b." part, as below: > > So, it appears that the correct syntax in Postgres would be: > > UPDATE b > SET b.a_id = a.aid SET a_id=a.aid > FROM a > WHERE b.custno = a.custno; > Ross