Re: [SQL] Trigger to identify which column(s) updated

[V i s h a l Kashyap @ [Sai Hertz And Control Systems]]

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 [EMAIL PROTECTED] 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.
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend