From: | Adrian Klaver <aklaver(at)comcast(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: begin update ... syntax error |
Date: | 2004-04-10 22:07:26 |
Message-ID: | 200404101507.26993.aklaver@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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;
> 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 this
> message to anyone. In such case, please destroy this message and notify the
> sender by reply e-mail. Please advise the sender immediately if you or your
> 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
--
Adrian Klaver
aklaver(at)comcast(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Troels Arvin | 2004-04-10 22:13:17 | Re: SQL challenge--top 10 for each key value? |
Previous Message | Gregory S. Williamson | 2004-04-10 21:51:27 | Re: begin update ... syntax error |