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
Re: How to update rows from a cursor in PostgreSQL
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