|
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; 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
|
