which attribute was UPDATEd in a trigger?

From: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: which attribute was UPDATEd in a trigger?
Date: 2000-09-25 15:17:44
Message-ID: 20000925171744.A2678@styx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)apartia(dot)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

Browse pgsql-general by date

  From Date Subject
Next Message Adam Lang 2000-09-25 16:26:19 Security- ODBC over Internet
Previous Message Louis-David Mitterrand 2000-09-25 13:44:18 SPI vs. libpq for function programming