Thread: which attribute was UPDATEd in a trigger?

which attribute was UPDATEd in a trigger?

From
Louis-David Mitterrand
Date:
Hello,

I have this C trigger that sets a "modified" timestamp column to the
present date on each UPDATE to a row. This is fine unless I want to play
with the "modified" column itself, as the trigger dutifully resets it to
now() on any UPDATE. Is there a way inside the trigger to detect on
which column the UPDATE was called?

Thanks in advance,

--
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.org

There are no Debian developers in any part of Hell, because the good
karma incurred by being one takes you straight to the pearly gates. Of
course, the frequent flame wars you put up with on the Debian lists make
up for this on Earth.     - Seth Cohn