Re: Triggers on columns - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Triggers on columns
Date
Msg-id 1251978293.4154.2.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to Re: Triggers on columns  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: Triggers on columns
Re: Triggers on columns
Re: Triggers on columns
List pgsql-hackers
On Thu, 2009-09-03 at 16:25 +0900, Itagaki Takahiro wrote:
> I'd like to check conditions by comparing actual values but not
> a target of UPDATE statement because I think almost user expects
> the former behavior. Unmodified UPDATE-targets are common case
> if we use a framework that generates SQL statements internally.

The SQL standard specifies that a trigger is fired if the column is
mentioned in the UPDATE statement, independent of whether the value is
actually changed through the update.



pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Fwd: Copy out wording
Next
From: Robert Haas
Date:
Subject: Re: Triggers on columns