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