Re: [GENERAL] Field names and NEW

2006-05-05 Thread Hogan, James F. Jr.
quot; located on http://www.berlios.de/index.php.en http://svn.berlios.de/svnroot/repos/pglog/trunk Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martijn van Oosterhout Sent: Friday, May 05, 2006 10:02 AM To: Tuukka Norri Cc: pgsql-general@postgresql.or

Re: [GENERAL] Field names and NEW

2006-05-05 Thread Martijn van Oosterhout
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 l

[GENERAL] Field names and NEW

2006-05-05 Thread Tuukka Norri
Greetings to everyone on the list I am attempting to write a system which would copy primary key values to another table after insert. To achieve this, I wrote a trigger function in Perl. I also wanted to make the function reusable, so the fields included in the query are passed as function