creating a trigger to write to a different table

From: Peter Choe <choepete(at)mindspring(dot)com>
To: postgres <pgsql-general(at)postgresql(dot)org>
Subject: creating a trigger to write to a different table
Date: 2001-03-22 15:16:00
Message-ID: 3ABA1730.5F126793@mindspring.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2001-03-22 15:19:36 Re: String REPLACE function
Previous Message Thomas Lockhart 2001-03-22 15:15:40 Re: Re: Call for platforms