Re: Trigger to identify which column(s) updated

Dear Jack ,

>for each column in new:
> if (new.column(1) != old.column(1)) ...
>
> ...and then some snippet of code to determine the primary key column
>of new (or old)
>
>
Check the following link

http://gborg.postgresql.org/project/tablelog/projdisplay.php

Hope this helps

--
Regards,
Vishal Kashyap

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
I Know you believe my words so logon to Jabber.org
and add vishalkashyap(at)jabber(dot)org to your roster.
~*~*~*~*~*~*~*~*
I am usually called as Vishal Kashyap
but my Girl friend calls me as Vishal CASH UP.
This is because others know me because of my generosity
and my Girlfriend knows me because of my CASH.
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*