| 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: | Whole Thread | Raw Message | 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
| 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 |