Re: Attribute a value to a record - Mailing list pgsql-general

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

What do you mean by "the record doen't accept the new value"?

Can you show us some SQL statements that exhibit the problem?

Yours,
Laurenz Albe