Thanks a lot for this precision.
unfortunately, the cursor doesn't accept "complicated" queries whereas
record type stay more powerfull on this aspect.
I found a solution and BTW it has considerably simplfy my code!
A clue can make you think better!
Le mercredi 03 février 2010 à 14:33 +0100, Wapp
Le mercredi 03 février 2010 à 14:38 +0100, Florent THOMAS a écrit :
> Thank you,
>
> As I posted on a french list, whene I start to develop trigger bigger
> than 10lines, I always come back on developper habits and forget
> database aspects.
> So I WILL PRINT IT ON MY WALL : With records everyt
On 2010-02-03, Florent THOMAS wrote:
> Dear laurenz Albe,
>
> Thank you for answering so fast. for me, the variable ventilation_local
> is defined as a record type. So as I wrote on the other mail, I made
> some additionnal test because the doc precise that the syntax above is
> allowed : http:
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
Dear laurenz Albe,
Thank you for answering so fast.
for me, the variable ventilation_local is defined as a record type.
So as I wrote on the other mail, I made some additionnal test because
the doc precise that the syntax above is allowed :
http://www.postgresql.org/docs/8.4/interactive/plpgsql-s
Florent THOMAS wrote:
> I'm currently running on pg8.4 and I have a trigger with a loop :
>
> FOR ventilation_local IN (SELECT * FROM XXX) LOOP
> IF (mytest) THEN
> ventilation_local.myfield:=mynewvalue;
> END IF;
> END LOOP;
>
> my problem is that the record doen't accept the new
Hy
I made an additionnal test
FOR ventilation_local IN (SELECT * FROM XXX) LOOP
IF (mytest) THEN
RAISE NOTICE 'ventilation %', ventilation_local;
ventilation_local.myfield:=10;
RAISE NOTICE 'ventilation %', ventilation_local;
END IF;
END LOOP;
the
