Attribute a value to a record

From: Florent THOMAS <mailinglist(at)tdeo(dot)fr>
To: postgesql general <pgsql-general(at)postgresql(dot)org>
Subject: Attribute a value to a record
Date: 2010-02-02 23:28:13
Message-ID: 1265153293.19341.42.camel@Dell_Inspiron
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DM 2010-02-02 23:41:14 Re: pg_dump issues
Previous Message Jean-Yves F. Barbier 2010-02-02 23:21:09 Re: pg_dump issues