[SQL] Looping recordset

[Furesz Peter]

Hello,

How can I loop a PL/PgSQL recorset variable? The example:
   DECLARE
       v_tmp_regi RECORD;
       v_tmp RECORD;
   BEGIN
     SELECT * INTO v_tmp_regi FROM sulyozas_futamido sf WHERE 
sf.termekfajta_id=
     a_termekfajta_id AND sf.marka_id=a_marka_id;

       DELETE FROM sulyozas_futamido;

       FOR v_tmp IN v_tmp_regi LOOP
           --I would like to work here with the old recordset!
       END LOOP;
       ^^^^^^^^^^^^^^
      -- This is not working !!!

   END;


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org