On Wed, May 26, 2010 at 1:27 AM, Len Walter <len.walter@gmail.com> wrote:
>
> PL/pgsql doesn't allow that because it doesn't support nested transactions.
> Is there an equivalent Postgres way of doing this?
what about this?
create function f() returns void as $$
declare
r record;
begin
for r in select col_a from t loop
update t set col_c = col_a + col_b where col_a = r.a;
end loop;
return;
end;
$$ language plpgsql;
--
Jaime Casanova www.2ndQuadrant.com
Soporte y capacitación de PostgreSQL