Re: Trigger to identify which column(s) updated - Mailing list pgsql-sql

From V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Subject Re: Trigger to identify which column(s) updated
Date
Msg-id 400CBC3B.9030902@sancharnet.in
Whole thread Raw
In response to Trigger to identify which column(s) updated  ("Jack Kerkhof" <jack.kerkhof@guest-tek.com>)
List pgsql-sql
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@jabber.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.
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*



pgsql-sql by date:

Previous
From: Robert Creager
Date:
Subject: Re: How can I get the last element out of GROUP BY sets?
Next
From: "Ganesan Kanavathy"
Date:
Subject: Database diagram