Message-ID: <3A36A0A5.E778EECA@ipinc.com>
Date: Tue, 12 Dec 2000 14:03:17 -0800
From: Jie Liang <jliang@ipinc.com>
Organization: ipinc.com
MIME-Version: 1.0
CC: pgsql-sql@postgresql.org
Subject: select ... for update
References: <Pine.BSF.4.21.0012121033570.25667-100000@jliang.ipinc.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> Hi,

How can I use select ... for update to update limit to update what I
select??
somewhat like:
select url,id from mytable for update order by priority,id limit 5;
I want update the id in above return like:
update mytable set allocatedto='whatever' where id in above return set.
Could I do it in one stmt.
And what is class_name in following:
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
    expression [ AS name ] [, ...]
    [ INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table ]
    [ FROM table [ alias ] [, ...] ]
    [ WHERE condition ]
    [ GROUP BY column [, ...] ]
    [ HAVING condition [, ...] ]
    [ { UNION [ ALL ] | INTERSECT | EXCEPT } select ]
    [ ORDER BY column [ ASC | DESC | USING operator ] [, ...] ]
    [ FOR UPDATE [ OF class_name [, ...] ] ]
    LIMIT { count | ALL } [ { OFFSET | , } start ]
can any one give me a example??

--
Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.ipinc.com