--On Friday, May 23, 2003 16:34:58 +0200 j.sachanbinski@coroplast.de wrote:
> Hello everyone,
>
> is there a way to loop/iterate through every individual field of the
> OLD/NEW records in plpgsql trigger function?
>
> I'm attempting to write a function that logs all the changes the user
> makes to the table, sth. like: (sketch only)
See a similar thread I had on the SQL list last week. Joe Conway posted a
wonderful solution using contrib/dblink.
I've asked this before, and have had no luck. Joe's solution logs the
exact SQL statement used.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749