[SQL] cursor and for update

[Maciej Piekielniak]

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:[EMAIL PROTECTED]


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend