From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Florent THOMAS *EXTERN*" <mailinglist(at)tdeo(dot)fr>, "postgesql general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Attribute a value to a record |
Date: | 2010-02-03 13:13:20 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C203938147@exadv11.host.magwien.gv.at |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | vijayalakshmi thiruvengadam | 2010-02-03 13:26:14 | |
Previous Message | Alban Hertroys | 2010-02-03 12:06:15 | Re: Is it necessary to have index for child table in following case? |