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 по дате отправления:

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Loading 8.2 data into 8.1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: dynmic column names inside trigger?