How to update rows from a cursor in PostgreSQL - Mailing list pgsql-general

From Ruben
Subject How to update rows from a cursor in PostgreSQL
Date
Msg-id 3E568767.2040509@superguai.com
Whole thread Raw
Responses Re: How to update rows from a cursor in PostgreSQL  (Peter Eisentraut <peter_e@gmx.net>)
Re: How to update rows from a cursor in PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I was trying something like:

select * from t1, t2, t3, t4
where ...
for update of t1

while(fetch...)
{
    update
    where current
}

Since "FOR UPDATE" cursors are not supported in PostgreSQL, can I update
the current row of table t1?

Thanks a lot!


pgsql-general by date:

Previous
From: Eric B.Ridge
Date:
Subject: Views + Rules + Triggers + 7.3.2 = Upgrade Problems (was: Re: REWRITE_INVOKE_MAX and "query may contain cycles" )
Next
From: "scott.marlowe"
Date:
Subject: Re: Problem with functional indexes