Florent THOMAS wrote:
> I understood that in the Loop you can change the values of a
> variable! Exactly what I needed.
> but unfortunately all of this seems to be temporary.
> Consequently, the record in the table won't be updated by the
> changes we made on the local variable even if it points to a
> record in the table.
> I forgot the aspect of the cursor that is temporary.
I get you now - you expected that the underlying table would
be updated if you change a variable in PL/pgSQL.
I don't think that you need dynamic SQL for that -
all it takes is an UPDATE statement in your loop, like
UPDATE XXX SET XXX.myfield = mynewvalue
WHERE XXX.pkey = ventilation_local.pkey;
(using the names from your sample)
Yours,
Laurenz Albe