Help on Trigger functions

Поиск
Список
Период
Сортировка
От Pradeepkumar, Pyatalo (IE10)
Тема Help on Trigger functions
Дата
Msg-id 77ED2BF75D59D1439F90412CC5B109741A6419BF@ie10-sahara.hiso.honeywell.com
обсуждение исходный текст
Ответы Re: Help on Trigger functions  (Keith Worthington <KeithW@NarrowPathInc.com>)
Список pgsql-novice


Hi all,

I have a table something like this -

PointTable(PointName varchar, PointType integer, PointValue integer);

I have to write a trigger before UPDATE on this table. In the trigger function, I need to check which field of the table is going to be updated...based on this I need to do some operation.

CREATE FUNCTION Trg_UpdPointTable RETURNS TRIGGER AS'
BEGIN
        IF PointType is being modified THEN
                // do some operation.
        ELSIF PointValue is being modified THEN
                // Do some operation
        END IF;
END;

CREATE TRIGGER PTableTrg BEFORE UPDATE ON PointTable FOR EVERY ROW EXECUTE PROCEDURE Trg_UpdPointTable();

Is this functionality possible. I am using PostgreSQL version 7.4.3.

Thanks in advance.

Regards,
Pradeep

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

Предыдущее
От: "Ross Gohlke"
Дата:
Сообщение: Re: Form Design Advice
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: User right management concerning functions