From: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
---|---|
To: | "Furesz Peter" <spam(at)srv(dot)hu> |
Cc: | "postgres levlista" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: loop plpgsql recordset variable |
Date: | 2007-01-25 20:28:03 |
Message-ID: | b42b73150701251228w71856896p6edf6a78109244ad@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 1/25/07, Furesz Peter <spam(at)srv(dot)hu> wrote:
> 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;
I think what you want to do is this:
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_temp_regi IN SELECT * FROM sulyozas_futamido sf WHERE
sf.termekfajta_id = a_termekfajta_id AND sf.marka_id=a_marka_id LOOP
END LOOP;
FOR v_tmp IN v_tmp_regi LOOP
--I would like to work here with the old recordset!
END LOOP;
^^^^^^^^^^^^^^
END;
From | Date | Subject | |
---|---|---|---|
Next Message | gustavo halperin | 2007-01-25 20:33:55 | triggers vs b-tree |
Previous Message | Bruce Momjian | 2007-01-25 20:19:34 | Re: replication choices |