Thanks guys but I cannot use C on the database server. I am a lowly coder in a large organization and even getting pl/PGSQL loaded into the production database practically took an act of congress. So for now solutions that require stored procedures to be written in C are not an option. pl/Perl would almost work. They loaded it onto the production database when I requested pl/PGSQL but they didn't load it into my sandbox (development) database. You have no idea has bureaucratic a place can be. :o) I think I'm just going to build a SQL statement by comparing each field in turn between OLD and NEW. Thanks for all your help everyone! Its highly appreciated. Maybe in the next version of postgresql some of this stuff will be built in since appearantly it is so desirable to people. -Robert
