Received: from akirason.se.verio.net (akirason.se.verio.net [204.27.64.122]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7KETSP36363 for ; Mon, 20 Aug 2001 10:29:29 -0400 (EDT) (envelope-from jeckermann@verio.net) Received: from beancounter (no-wkstns.gs.verio.net [204.27.67.225]) (authenticated) by akirason.se.verio.net (8.11.4/8.11.4) with ESMTP id f7KERhI40159; Mon, 20 Aug 2001 09:27:43 -0500 (CDT) (envelope-from jeckermann@verio.net) Message-ID: <01af01c12984$80c48830$279c10ac@INTERNAL> From: "Jeff Eckermann" To: "Fredrik Thunberg" , References: <01a501c12969$6e397a10$7100000a@intern.datessa.se> Subject: Re: Simple SQL-syntax Date: Mon, 20 Aug 2001 09:29:21 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01AC_01C1295A.97B45D60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200108/245 X-Sequence-Number: 4480 This is a multi-part message in MIME format. ------=_NextPart_000_01AC_01C1295A.97B45D60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable UPDATE TableA SET nrA =3D TableB.nrB WHERE nrA =3D TableB.nrA; UPDATE statements don't take FROM clauses. I don't think they like aliasin= g, either. ----- Original Message -----=20 From: Fredrik Thunberg=20 To: pgsql-sql@postgresql.org=20 Sent: Monday, August 20, 2001 6:15 AM Subject: Simple SQL-syntax Hello. I have a very simple sql-question from an sql-beginner: Suppose I have Table A looking something like this: Index Text NrA And Table B like this: NrA NrB Then I want to change all occurences of NrA in Table A to NrB... I've tried: UPDATE tableA Set tableA.nrA =3D B.nrB From tableB B Where tableA.nrA =3D= B.nrA; But that doesn't seem to work... Best regards /Fredrik Thunberg ------=_NextPart_000_01AC_01C1295A.97B45D60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
UPDATE TableA SET nrA =3D TableB.nrB WHERE= nrA =3D=20 TableB.nrA;
 
UPDATE statements don't take FROM=20 clauses.  I don't think they like aliasing, either.
----- Original Message -----
Fro= m:=20 Fredrik= =20 Thunberg
To: pgsql-sql@postgresql.org
Sent: Monday, August 20, 2001 6:15= =20 AM
Subject: Simple SQL-syntax

Hello.
 
I have a very simple sql-question from&n= bsp;an=20 sql-beginner:
 
Suppose I have Table A looking something= like=20 this:
 
Index    Text  =  =20 NrA
 
And Table B like this:
 
NrA    NrB
 
Then I want to change all occurences of = NrA in=20 Table A to NrB...
 
I've tried:
 
UPDATE tableA Set tableA.nrA =3D B.= nrB From=20 tableB B Where tableA.nrA =3D B.nrA;
 
But that doesn't seem to work...<= /DIV>
 
Best regards
 
/Fredrik=20 Thunberg
------=_NextPart_000_01AC_01C1295A.97B45D60--