Search Postgresql Archives

Re: Field names and NEW

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux