Implementing Trigger problem

From: oca(at)mvc(dot)edu(dot)ph
To: pgsql-students(at)postgresql(dot)org
Subject: Implementing Trigger problem
Date: 2008-08-10 21:11:59
Message-ID: 20080811051159.pug1flvkr4coso4o@mail.mvc.edu.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-students

Hi,

No matter how i read the manual i can't understand it. :(

Here is what i would like to do.

for example i have

table:   classes
column:  classno,...,schedule_count

table:  schedules
column:   classno,time

I would like to create a trigger that everytime there is an insert
or delete in schedules
classes.schedule_count will be updated with number of schedules
entered in schedules for that particular class.  this way i could
track the number of schedules for that particular class
without counting the schedules.

how do i implement it?

thank you,
oscar
 

Browse pgsql-students by date

  From Date Subject
Next Message Gregory S. Youngblood 2008-09-29 18:19:33 Announcing PostgreSQL Certification Project Job Task Analysis Survey
Previous Message oca 2008-08-09 22:09:13 Re: Problem accessing View in VB6