Re: Updating

Hello,

On Sun, 16 Mar 2008 15:32:27 -0700 Bob Pawley wrote:

> Is there a method available for triggering a function after an update on a
> particular column in a table?
>
> The only way that I have found is to trigger after an update on the whole
> table, which of course can lead to problems.

You can compare OLD.column and NEW.column and only continue your trigger
function, if you detect a change.


Kind regards

--
                Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors