Re: Attribute a value to a record

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 first notice  and the second one are different.
Unfortunately, when I get out from the LOOP, the result doesn't seems to be updated in the table

Best regards


Le mercredi 03 février 2010 à 00:28 +0100, Florent THOMAS a écrit :

Hello,

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 value.
I've chek before the value that is not null.
Is it a fonctionnality accepted in pg8.4 on record type?

Best regards