Re: creating triggers: need help

Hi,
what about scenario when reach person lost his houses?
trigger should be fired only for new entries and/or updated?

Regards,
Bartek

2012/2/23 Navdeep Singh <navdeeps(dot)iitd(at)gmail(dot)com>

> Hey!
>
> I am a penultimate year student of computer science and engg. I am looking
> for a way to create a trigger in postgresql. I've found some abstract
> methods for this on web but could not implement it. The description of the
> trigger is as follows:
> I have two tables, one named people and other named rich. The people
> table contains two columns: name, no. of houses. The rich table contains
> the same columns. I need to create a trigger to insert the tuple of the
> people table into the rich table when the number of houses of the given
> person (name) reaches, lets say 10.
>
> Please help me with the sql commands to implement the aforementioned
> transaction.
>
> Thanks,
> Navdeep
> navdeeps(dot)iitd(at)gmail(dot)com
>