How to update rows from a cursor in PostgreSQL

Поиск
Список
Период
Сортировка
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 по дате отправления: