Any ideas on how to impliment history within perform?
Would like to keep a row-by-row running history. That is, prior to when a row is
updated or deleted, it is saved. And, would like this to happen when using
perform. Sorry, don't have esql/c yet.
item_id entry_date other_columns...
Note the changes can be traced back in time by grouping on the item_id. Once
entered, the item_id never changes.
Can this be done within perform? Any better ideas on how to impliment history?
P.S. The Daily SQL Quiz is being very helpful for grouping the data.