Re: Iterating through individual fields of OLD/NEW

--On Friday, May 23, 2003 16:34:58 +0200 j(dot)sachanbinski(at)coroplast(dot)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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749