Re: Loop plpgsql recordset
От | George Weaver |
---|---|
Тема | Re: Loop plpgsql recordset |
Дата | |
Msg-id | 008e01c741a3$6ee34010$6400a8c0@Dell4500 обсуждение исходный текст |
Ответ на | Loop plpgsql recordset ("Furesz Peter" <fureszpeter@srv.hu>) |
Список | pgsql-general |
On Thursday, January 25 Furesz Peter 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;
>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;
Its difficult to determine what you're trying to accomplish in the loop, but you may want to refer to 37.7.4. Looping Through Query Results in http://www.postgresql.org/docs/8.2/interactive/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING
Note that DELETE FROM sulyozas_futamido; will delete ALL records in sulyozas_futamido!
Perhaps:
FOR v_tmp IN SELECT * FROM sulyozas_futamido sf
WHERE sf.termekfajta_id = a_termekfajta_id AND sf.marka_id=a_marka_id;
LOOP
DELETE FROM sulyozas_futamido WHERE (some condition related to v_tmp???)
Work with old record now in v_tmp
END LOOP;
Regards,
George
В списке pgsql-general по дате отправления: