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