which attribute was UPDATEd in a trigger? - Mailing list pgsql-general

From Louis-David Mitterrand
Subject which attribute was UPDATEd in a trigger?
Date
Msg-id 20000925171744.A2678@styx
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: SPI vs. libpq for function programming
Next
From: "Adam Lang"
Date:
Subject: Security- ODBC over Internet