c: pgsql-sql@postgresql.orgSubject: Re: [SQL]
Start up question about triggers
Why not just create a history table and have the trigger copy the
data out of the table into the history table with a time stamp of the
change. Then you don't need the query.For exampleTable
A
Why not just create a history table and have the trigger copy the data out of the table into the history table with a time stamp of the change. Then you don't need the query.For exampleTable Aa_id,a_value1,
a_value2Table A_hista_id,a_dt,a_value1,a_value2Then A_hist has a PK of a_id, a_dtThis would
Sorry This is the complete message
Hello
all,
I know that this
question may be really simple, but I have decided to ask here due to fact that I
don't know how to search for this on google or on the docs.
I created a trigger
fuction which updates a specific row in some table A. Is it p
