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
'
DECLAREtabela 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;
BEGINfor 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@isb.com.pl