Re: Detecting changes to certain fields in 'before update' trigger functions

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Detecting changes to certain fields in 'before update' trigger functions
Дата
Msg-id 200812010755.38141.aklaver@comcast.net
обсуждение исходный текст
Ответ на Detecting changes to certain fields in 'before update' trigger functions  (Sebastian Tennant <sebyte@smolny.plus.com>)
Список pgsql-general
On Monday 01 December 2008 7:18:51 am Sebastian Tennant wrote:
> Hi list,
>
> First steps in trigger functions and PL/pgSQL so please bear with me...
>
> How can one detect changes to certain fields in before update trigger
> functions?
>
>  IF (NEW.<column-name> != OLD.<column-name>) THEN ...
>
> doesn't work, so obviously my understanding of the values of the
> varriables NEW and OLD in before update trigger functions is wrong; I
> had thought that OLD holds the record as it was before the update, and
> that NEW holds the record as it is since the update (but before the
> update has been committed)?
>
> How should one go about detecting changes to certain fields in before
> update trigger functions?
>
> Any help/advice much appreciated.
>
> Sebastian

It works here. Can you be more specific? Full function code, table schema,etc.


Thanks,
--
Adrian Klaver
aklaver@comcast.net

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Trigger before delete does fire before, but delete doesn't not happen
Следующее
От: "Richard Broersma"
Дата:
Сообщение: Re: Detecting changes to certain fields in 'before update' trigger functions