Content-Type: text/plain;
  charset="iso-8859-1"
From: Adrian Klaver <aklaver@comcast.net>
Reply-To: aklaver@attbi.com
To: pgsql-sql@postgresql.org
Subject: Re: begin update ... syntax error
Date: Sat, 10 Apr 2004 15:07:26 -0700
User-Agent: KMail/1.4.3
References: <407867FE.1030501@ferring.com>
In-Reply-To: <407867FE.1030501@ferring.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200404101507.26993.aklaver@comcast.net>

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=3D# begin
> fri-# update tabA set nobegin=3Dtmp.nobegin, noend=3Dtmp.noend
> fri-# from tmp
> fri-# where tabA.acc=3Dtmp.acc;
> ERROR:  syntax error at or near "update" at character 7
>
> The same query can be run with no problem if not starting with BEGIN.
>
> Does mean that BEGIN cannot preceed UPDATE?
>
> Or I am making some obvious miskate?
>
> Kemin
>
>
>
>
> **********************************************************************
> Proprietary or confidential information belonging to Ferring Holding SA or
> to one of its affiliated companies may be contained in the message. If you
> are not the addressee indicated in this message (or responsible for the
> delivery of the message to such person), please do not copy or deliver th=
is
> message to anyone. In such case, please destroy this message and notify t=
he
> sender by reply e-mail. Please advise the sender immediately if you or yo=
ur
> employer do not consent to e-mail for messages of this kind. Opinions,
> conclusions and other information in this message represent the opinion of
> the sender and do not necessarily represent or reflect the views and
> opinions of Ferring.
> **********************************************************************
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html

--=20
Adrian Klaver=09
aklaver@comcast.net