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?
2012/2/23 Navdeep Singh <navdeeps(dot)iitd(at)gmail(dot)com>
> I need to fire the trigger only when the number of houses is updated!
> Also, I'm considering only increment scenarios.
> Thanks and regards,
> On Thu, Feb 23, 2012 at 9:20 PM, Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl>wrote:
>> what about scenario when reach person lost his houses?
>> trigger should be fired only for new entries and/or updated?
>> 2012/2/23 Navdeep Singh <navdeeps(dot)iitd(at)gmail(dot)com>
>>> 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
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2012-02-23 23:51:30|
|Subject: Re: A little help interpreting a query plan |
|Previous:||From: Andy Chambers||Date: 2012-02-23 21:17:17|
|Subject: A little help interpreting a query plan|