Skip site navigation (1)
Skip section navigation (2)
I have a On Insert Trigger that updates one of the columns in that same table.
Is there a way for the trigger to run only for the newly inserted records?
Instead of all records in the database?
E.g.:
ID Start_Date End_Date
001 08-01-2006
002 08-02-2006
On Insert/Update, Update End_Date=now().
I want that to run only on new records.or the updated
record. How can I do this?
Thank you so much.
Peripheral Links
Header And Logo
|
Site Navigation
Trigger on Insert to Update only newly inserted fields?
- From: "Henry Ortega" <juandelacruz(at)gmail(dot)com>
- To: pgsql-sql(at)postgresql(dot)org
- Subject: Trigger on Insert to Update only newly inserted fields?
- Date: Mon, 28 Aug 2006 10:02:32 -0400
I have a On Insert Trigger that updates one of the columns in that same table.
Is there a way for the trigger to run only for the newly inserted records?
Instead of all records in the database?
E.g.:
ID Start_Date End_Date
001 08-01-2006
002 08-02-2006
On Insert/Update, Update End_Date=now().
I want that to run only on new records.or the updated
record. How can I do this?
Thank you so much.
- Follow-Ups:
- Re: Trigger on Insert to Update only newly inserted fields?
- From: Michael Fuhr
- Re: Trigger on Insert to Update only newly inserted fields?
- Prev by Date: Re: double precision vs. numeric
- Next by Date: Re: Create Assertion -- Question from a newbie
- Previous by thread: hi ........i have a query related to MS reporting services
- Next by thread: Re: Trigger on Insert to Update only newly inserted fields?
- Indexes: