trigger column update

Bolden, Thomas a écrit:

I am porting over a trigger from oracle.

"CREATE TRIGGER TR_CLUSCODE_UPD AFTER UPDATE OF STFIPS, CLUSCODE,
CLUSTITLE, CLUSDESC ON CLUSCODE
FOR EACH ROW EXECUTE"

The trigger is column dependent and according to the online docs.
"

The CREATE TRIGGER statement in PostgreSQL implements a subset of the SQL99
standard. The following functionality is missing:

*
SQL99 allows triggers to fire on updates to specific columns (e.g., AFTER
UPDATE OF col1, col2).

"
anyone know a work around.

you can put the columns you want to "trigger" in another table
and put a trigger on the update of this table.