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