cursor and for update

Hello ,

I try to translate my old functions from oracle but don't understand what is wrong.

create or replace function uporzadkuj_reguly(text,text) RETURNS integer AS
'
DECLARE
tabela ALIAS FOR $1;
lancuch ALIAS FOR $2;
ret integer:=0;
licznik integer:=1;
rekord firewall%ROWTYPE;

reguly CURSOR FOR SELECT * from firewall ORDER BY id_firewall WHERE tabela=tabela and lancuch=lancuch for UPDATE;
BEGIN
for i in reguly LOOP
UPDATE firewall SET id_firewall=licznik WHERE CURRENT OF reguly;
licznik:=licznik+1;
END LOOP;

return ret;
END;'
LANGUAGE 'plpgsql';

--
Best regards,
Maciej mailto:piechcio(at)isb(dot)com(dot)pl