Re: Field names and NEW - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Field names and NEW
Date
Msg-id 20060505150146.GE23972@svana.org
Whole thread Raw
In response to Field names and NEW  (Tuukka Norri <tuukka.norri@iki.fi>)
List pgsql-general
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@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: "robert"
Date:
Subject: simple md5 authentication problems
Next
From: "Hogan, James F. Jr."
Date:
Subject: Re: Field names and NEW