Received: from ns1.prima.net.id ([202.57.0.8]) by hub.org (8.9.2/8.9.1) with ESMTP id EAA31620 for ; Fri, 16 Apr 1999 04:48:05 -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 WAA13954 for ; Fri, 16 Apr 1999 22:47:08 +0700 (GMT) Sender: root@ns1.prima.net.id Message-ID: <37175B7B.F6DD87E2@prima.net.id> Date: Fri, 16 Apr 1999 08:47:07 -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 CC: pgsql-sql@postgreSQL.org Subject: Update on 6.5 References: <199904152011.QAA26538@fnur.3skel.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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" Thanks. Regards, Chai