Received: from ns1.prima.net.id ([202.57.0.8]) by hub.org (8.9.3/8.9.1) with ESMTP id VAA98752 for ; Tue, 20 Apr 1999 21:37:00 -0400 (EDT) (envelope-from chairudin@prima.net.id) Received: from prima.net.id (mail.prima.net.id [202.57.0.8]) by ns1.prima.net.id (8.8.4/8.7.2) with ESMTP id PAA18398; Wed, 21 Apr 1999 15:36:31 +0700 (GMT) Sender: root@ns1.prima.net.id Message-ID: <371D8E0F.C2097B01@prima.net.id> Date: Wed, 21 Apr 1999 01:36:31 -0700 From: Chairudin Sentosa Reply-To: chairudin@prima.net.id Organization: PT. Khasanah Timur Indonesia X-Mailer: Mozilla 4.5 [en] (X11; I; SunOS 5.5.1 sun4u) X-Accept-Language: en MIME-Version: 1.0 To: =?iso-8859-1?Q?Jos=E9?= Soares CC: pgsql-sql@postgresql.org Subject: Re: [SQL] Update on 6.5 References: <199904152011.QAA26538@fnur.3skel.com> <37175B7B.F6DD87E2@prima.net.id> <37173AE2.4FB7C0D5@sferacarta.com> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit José Soares wrote: > Chairudin Sentosa ha scritto: > > > Hi, > > > > I am using postgresql 6.5 snapshot. > > I can not update. > > Could anyone tell me what's wrong, please? > > > > update ibs_br_all_total_units tr set first_name= > > (select first_name from ibs_subscriber tn > > where tr.pin = tn.pin > > ); > > > > "/tmp/psql.60000.13342" 4 lines, 117 characters > > ERROR: parser: syntax error at or near "tr" > > > > AFAIK PostgreSQL doesn't allow subselects on UPDATE. > > José Hi Jose, How should I do it in PostgreSQL? Thanks Regards, Chai