Hi,
I have a table, say "customers" which is triggered, so before each
update, the previous version of the record goes to "customers_history"
with date of insert. So in "customers_history" I could have records
like:
cutomer_ID first_name last_name country creationdate
--------------------------------------------------------------------
1 John Doe USA 2008-01-01
2 Jack Smith UK 2008-03-21
1 John Doe Australia 2008-04-15
And i have to make a re****t with date of last modification and
information WHAT WAS MODIFIED.
So I would like to get:
cutomer_ID date what_changed
---------------------------------------------
1 2008-04-15 country
I haven't found any way to fetch through column names in plpgsql. Is
there any language in which I could write such function?
