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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
