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.
Attachment:
signature.asc
Description: Digital signature