| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Tuukka Norri <tuukka(dot)norri(at)iki(dot)fi> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Field names and NEW |
| Date: | 2006-05-05 15:01:46 |
| Message-ID: | 20060505150146.GE23972@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hogan, James F. Jr. | 2006-05-05 15:14:25 | Re: Field names and NEW |
| Previous Message | Douglas McNaught | 2006-05-05 11:06:46 | Re: Function query plan |