Help needed - Mailing list pgsql-sql

From NosyMan
Subject Help needed
Date
Msg-id 200511301118.28795.nosyman@gmail.com
Whole thread Raw
In response to Re: Strange bug  ("Leif B. Kristensen" <leif@solumslekt.org>)
Responses Re: Help needed
List pgsql-sql
Hi everyone,

I have some kind of strange problem. I want to build general parametrized 
trigger for my database. The parameter sent to the trigger contains a column 
name that trigger should be check.  

CREATE OR REPLACE FUNCTION F_T_IU__check() RETURNS trigger AS $$DECLARE    vt VARCHAR;BEGIN
...........................................................        vt:='constant_value_id';        RAISE EXCEPTION
'aaa=%',NEW.vt;
 
.............................................................

The 'vt' variable contains the column name. In the above statement I want that 
NEW.vt to be interpreted as NEW.constant_value_id. It is possible to do this?

Thanks,
Nosy


pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Triggers
Next
From: Richard Huxton
Date:
Subject: Re: Help needed