dynmic column names inside trigger?
От | Louis-David Mitterrand |
---|---|
Тема | dynmic column names inside trigger? |
Дата | |
Msg-id | 20071120161258.GA27106@apartia.fr обсуждение исходный текст |
Ответы |
Re: dynmic column names inside trigger?
Re: dynmic column names inside trigger? |
Список | pgsql-sql |
Hi, I've got this trigger to clean up text entered in web forms: CREATE or replace FUNCTION sanitize_text() RETURNS "trigger" AS $$declarebegin if old.story is not null and new.story!= old.story then new.story = translate(new.story, E'\x92\x96', '''-'); new.story = regexp_replace(new.story,E'\x9c', 'oe', 'g'); new.story = regexp_replace(new.story, E'\x85', '...', 'g'); end if; return new;end;$$ LANGUAGE plpgsql; CREATE TRIGGER sanitize_text_trig BEFORE INSERT or update ON story FOR EACH ROW EXECUTE PROCEDURE sanitize_text(); I'd like to use it on other tables an columns but how can the column name be dynamic inside the procedure. Passing the column name in the trigger declaration and using it as NEW.TG_ARGV[0] seems out of the question. Is there another solution out there? Thanks,
В списке pgsql-sql по дате отправления: