Re: Updating

From: Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Updating
Date: 2008-03-17 00:28:52
Message-ID: 20080317012852.18ada9af@iridium.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

  • Updating at 2008-03-16 22:32:27 from Bob Pawley

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2008-03-17 00:36:35 Re: Updating
Previous Message Adrian Klaver 2008-03-17 00:14:56 Re: Updating