I would add that I also found on the pgsql-admin list a similar pltcl way to do what you're after posted in October of 04 by Ian. One way or the other though likely you will need to install first the ActiveTCL AND/OR ActivePerl From http://www.activestate.com if may also want to read in the PGDoc's about trusted vs untrusted languages Then run createlang "<pltcl or plperl>" --dbname=yourdatabase --username=superuser If you're unable to find Ian's post (if you go looking) let me know I will forward you a copy There is also a project started called "pglog" located on http://www.berlios.de/index.php.en http://svn.berlios.de/svnroot/repos/pglog/trunk Jim -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Martijn van Oosterhout Sent: Friday, May 05, 2006 10:02 AM To: Tuukka Norri Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] Field names and NEW On Fri, May 05, 2006 at 11:50:05AM +0300, Tuukka Norri wrote: > However, I would rather use PL/PgSQL, since the Perl interpreter > might not be installed by default. Is there a way to access the NEW > record without knowing the field names in advance? No. pl/pgsql is not flexible enough as a language to handle transformations like this effectively. If you know the table name you may be able to use EXECUTE to build query strings, but it won't be easy... Have a ncie day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
