Looping recordset - Mailing list pgsql-sql

From Furesz Peter
Subject Looping recordset
Date
Msg-id 002901c740b9$56fff190$6500a8c0@bixerverintel
Whole thread Raw
List pgsql-sql
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;



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using Temporary Tables in postgres functions
Next
From: Tom Lane
Date:
Subject: Re: shared_buffers and shmall,shmmax