Re: Iterating through individual fields of OLD/NEW

--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