Looping recordset

From: "Furesz Peter" <spam(at)srv(dot)hu>
To: "pgsql" <pgsql-sql(at)postgresql(dot)org>
Subject: Looping recordset
Date: 2007-01-25 19:45:17
Message-ID: 002901c740b9$56fff190$6500a8c0@bixerverintel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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;

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jie Liang 2007-01-25 20:11:32 shared_buffers and shmall,shmmax
Previous Message Oisin Glynn 2007-01-25 18:28:43 Re: Windows 2K Installation difficulties...