Re: Commit every N rows in PL/pgsql

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