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