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.