On Sep 3, 2009, at 7:44 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
> 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.
That is thorougly bizarre, IMO.
...Robert