Tom Lane wrote:
Jan Wieck <[EMAIL PROTECTED]> writes:
Unfortunately, you're right. There is no way do distinguish in a trigger
or rule if a value in the new row did result from the UPDATE query or
from target list expansion with OLD values.
It would not be terribly hard to examine the original
Jan Wieck <[EMAIL PROTECTED]> writes:
> Unfortunately, you're right. There is no way do distinguish in a trigger
> or rule if a value in the new row did result from the UPDATE query or
> from target list expansion with OLD values.
> It would not be terribly hard to examine the original query dur
Chris Anderson wrote:
PostgreSQL Version: 7.2.3
Procedural Language: PL/pgSQL
I have a table which contains a field for the user who last modified
the record. Whenever a row in this table is updated, I want to have an
UPDATE trigger do the following things:
1) Ensure the UPDATE query supplied
PostgreSQL Version: 7.2.3
Procedural Language: PL/pgSQL
I have a table which contains a field for the user who last modified
the record. Whenever a row in this table is updated, I want to have an
UPDATE trigger do the following things:
1) Ensure the UPDATE query supplied a value for the action_u