Re: Triggers on columns

Peter Eisentraut <peter_e@gmx.net> wrote:

> 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.

Hmmm, what does the SQL standard say about modification of NEW values?
Should we fire column triggers when their columns are mentioned in the
UPDATE statement, but modified by another triggers?

I believe we should fire them, but it is inconsistent because we will
make different decisions whether NEW values are modified or not.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center