Trigger to identify which column(s) updated

Поиск
Список
Период
Сортировка
От Jack Kerkhof
Тема Trigger to identify which column(s) updated
Дата
Msg-id ENEIKKAEJOFHOIHMMOIDKEAFCJAA.jack.kerkhof@guest-tek.com
обсуждение исходный текст
Ответы Re: Trigger to identify which column(s) updated
Список pgsql-sql
Does anyone know how to write a trigger that would identify which columns
have actually changed in an update (and then log them to an archive).

I suspect that the function would look something like;

CREATE FUNCTION FIND_CHANGED_COLUMNS() RETURNS OPAQUE AS '
BEGIN
  -- FOR EACH COLUMN IN THE RECORD:     -- IF ( NEW COLUMNx <> OLD COLUMNx)        -- LOG THE RECORD PRIMARY KEY,
COLUMNNAME, OLD VALUE
 
  RETURN NEW;
END;
' LANGUAGE 'plpgsql';

In other words- How might you parse, in general, old and new records to compare like
columns?     - How can you find out the primary key of a record?

Thanks, Jack



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

Предыдущее
От: sad
Дата:
Сообщение: DROP TRIGGER
Следующее
От: denis@coralindia.com
Дата:
Сообщение: Initially Deffered - FK