On Saturday 10 April 2004 02:32 pm, Kemin Zhou wrote:
begin; Note the semi-colon
Then the update query;
commit; or rollback;
> I was trying to speed up a simple update query
>
> fri=# begin
> fri-# update tabA set nobegin=tmp.nobegin, noend=tmp.noend
> fri-# from tmp
> fri-# where tabA.acc=tmp.acc;
try a semicolon after the begin ?
begin;
commit;
Greg Williamson
DBA
GlobeXplorer LLC
-Original Message-
From: Kemin Zhou [mailto:[EMAIL PROTECTED]
Sent: Sat 4/10/2004 2:32 PM
To: [EMAIL PROTECTED]
Cc:
Subject:[SQL] begin update ... syntax error
I was trying to spe
