pl/pgsql trigger function - compare *most* columns in NEW vs. OLD

Поиск
Список
Период
Сортировка
От Mike Blackwell
Тема pl/pgsql trigger function - compare *most* columns in NEW vs. OLD
Дата
Msg-id CANPAkgu8-Fh+=nNpPWDvjGkAZuNMA0AhpCAKOEef_Rg9db1_wA@mail.gmail.com
обсуждение исходный текст
Ответы Re: pl/pgsql trigger function - compare *most* columns in NEW vs. OLD  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
Is there a simple notation for comparing most columns in the new and old records in a pl/pgsql trigger function?  Something like

(new.b, new.c, new.d) = (old.b, old.c, old.d)

works to compare all the columns except 'a', but is fragile in that it needs to be updated any time a column is added to the table, and is rather messy looking when the actual table has many columns.

Is there a better approach to detecting a change in any column except a few specific ones?


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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: SSL Certificates in Windows 7 & Postgres 9.3
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: SSL Certificates in Windows 7 & Postgres 9.3