Re: [PERFORM] Best practices for update timestamp with/without triggers

2014-04-23 Thread hubert depesz lubaczewski
On Tue, Apr 22, 2014 at 01:16:15AM +, Verghese, Riya wrote: > I am going to add a new column to a table for modify_date that needs > to be updated every time the table is updated. Is it better to just > update application code to set the modify_date to current_time, or > create a Before-Update

[PERFORM] Best practices for update timestamp with/without triggers

2014-04-22 Thread Verghese, Riya
Hi I am going to add a new column to a table for modify_date that needs to be updated every time the table is updated. Is it better to just update application code to set the modify_date to current_time, or create a Before-Update trigger on the table that will update the modify_date column to c