Determine column name from trigger

Поиск
Список
Период
Сортировка
От Envex Developments
Тема Determine column name from trigger
Дата
Msg-id as80em$758$1@news.hub.org
обсуждение исходный текст
Ответы Re: Determine column name from trigger  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hey there,

I have a table named "program1", which looks like:

id INT NOT NULL
u1 INT
u2 INT
u3 INT
ds INT

I'm trying to keep a consitent summary of this table through the use of a
trigger, and function written in PL/pgSQL.  The problem I'm having is when
the trigger is executed AFTER an UPDATE statement, there's no way to
determine which uX column was updated.  I need to know if it's u1, u2, or
u3.

I've been trying for loops such as:

-------------------
FOR x IN 1 .. 3 LOOP
    IF OLD.ux NOT = NEW.ux THEN
        .... do this ...
    END IF;
END LOOP;
-------------------

Obviously, that doesn't work, and I just receive errors stating the column
ux doesn't exist.  Was wondering if anyone out there knew how to get the
column name which was updated through a trigger?  Anyway to pass it as an
argument to the function or anything?

Any help would be greatly appreciated.

Thanks,
Matt





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

Предыдущее
От: Tomas Berndtsson
Дата:
Сообщение: message type 0x44 arrived from server while idle
Следующее
От: Tom Lane
Дата:
Сообщение: Re: What could cause total crash of a postgres installation?