Help needed
От | NosyMan |
---|---|
Тема | Help needed |
Дата | |
Msg-id | 200511301118.28795.nosyman@gmail.com обсуждение исходный текст |
Ответ на | Re: Strange bug ("Leif B. Kristensen" <leif@solumslekt.org>) |
Ответы |
Re: Help needed
|
Список | 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 по дате отправления: