creating a trigger to write to a different table - Mailing list pgsql-general

From Peter Choe
Subject creating a trigger to write to a different table
Date
Msg-id 3ABA1730.5F126793@mindspring.com
Whole thread Raw
Responses Re: creating a trigger to write to a different table  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Jonas Bengtsson
Date:
Subject: Re: Re: OID as Primary Key
Next
From: "Brent R.Matzelle"
Date:
Subject: Re: Changing from rpm to Compiled version