Re: creating triggers: need help

Hi,
few more questions...

Should new rich person be removed from table "persons"?
Does "rich" table inherits from "persons", or it is separate table?

btw. which PostgreSQL version - that is important when answer for first
question is YES?

Regards,
Bartek

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

> Hey!
>
> I need to fire the trigger only when the number of houses is updated!
> Also, I'm considering only increment scenarios.
>
> Thanks and regards,
> Navdeep
>
> On Thu, Feb 23, 2012 at 9:20 PM, Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl>wrote:
>
>> 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
>>>
>>
>>
>