Trigger once again

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Trigger once again
Дата
Msg-id 200211281355.21387.aklaver@attbi.com
обсуждение исходный текст
Ответы Re: Trigger once again
Re: Trigger once again
Re: Trigger once again
Список pgsql-general
I have created the following function:

CREATE OR REPLACE FUNCTION validate_tag_number()
    RETURNS OPAQUE AS '
    BEGIN
    IF new.tag_number=old.tag_number THEN
    RAISE EXCEPTION ''Number is already present '';
    END IF;
    RETURN NEW;
    END;
    'LANGUAGE 'plpgsql';

 I used it to create a trigger as follows;

    CREATE TRIGGER  validate_tag_number BEFORE UPDATE ON tag_vendor FOR EACH ROW
    EXECUTE PROCEDURE validate_tag_number();

The trigger seems to work to well. If I update values other than the
tag_number I get the 'Number is already present' message. I am somewhat
confused as their is no new.tag_number value being passed to the function.
Can anyone set me straight?

                       Thank you
                       Adrain Klaver

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Trigger
Следующее
От: Tom Lane
Дата:
Сообщение: Re: compiler error with 7.3