creating a trigger to write to a different table
can i use pl/pgsql to write a trigger to update a separate table?
for example if i have a table student:
name text,
id text,
group int,
stat int,
and another table status:
stat text
group int
count int
and i update the stat in the student table, can i update the count
column in the status table to reflect the change. in the documents, i
just see triggers used on one table.
peter choe
On Thu, 22 Mar 2001, Peter Choe wrote:
can i use pl/pgsql to write a trigger to update a separate table?
You should be able to. You can use update, etc, from the trigger.
For example a simple summing one might be (not really tested)
create function summer() returns opaque
as '
begin;
update table2 set val=val+NEW.val where id=NEW.id;
return NEW;
end;
' language 'plpgsql';
)
create trigger tr after insert on table1 for each row execute
procedure summer();