On 10/16/07, Hans-Peter Oeri <hp@oeri.ch> wrote:
> Any help or link greatly appreciated
You could have main_table + audit_table, store all main_table changes
on audit_table using triggers, thus main_table always has the
"current" data. Then create the view on top of main_table.
