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