function / trigger problem

Поиск
Список
Период
Сортировка
От F. Masselink
Тема function / trigger problem
Дата
Msg-id 3B27292D.3090506@xs4all.nl
обсуждение исходный текст
Ответы Re: function / trigger problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Hello,

i've stumbled upon a problem with triggers and functions.

this function doesn't work.
It gives an error when creating the trigger: set_leentype() does not exist.

CREATE FUNCTION set_leentype (int4) RETURNS opaque AS '
    BEGIN
        NEW.type := $1;
        RETURN NEW;
    END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER is_boek
    BEFORE INSERT ON boek
    FOR EACH ROW
    EXECUTE PROCEDURE set_leentype (1);

but if i use the same function and triggers, with the little
modification that i don't pass a parameter, it works fine!

does anyone know why this is and does anyone know a solution to this. (I
want to use the code with passing parameters).


thanx,
   F.H.A. Masselink



В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: Re: Does PostgreSQL support EXISTS?
Следующее
От: "Itzinger, Oskar"
Дата:
Сообщение: [Help] AGGREGATE problem w/v7.0