Re: [GENERAL] plperl question: how to specifiy perl version?

2007-03-15 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > I setup a plperl handler in Postgres 8.1 running under Solaris. The > machine has multiple versions of Perl installed, and plperl is not using > the correct Perl binary. How do I set which Perl binary plperl should use? You need to set the

Re: [GENERAL] Plperl Question

2007-03-15 Thread Chris Coleman
@postgresql.org Subject: Re: [GENERAL] Plperl Question Answers in place: > I'm trying to write a plperl function to copy the new row e.g. NEW in > plpgsql into another table. I was looking for a similar effect to the > INSERT INTO blah VALUES (NEW.*) > Syntax that can be used in

Re: [GENERAL] Plperl Question

2007-03-14 Thread Stuart Cooper
Answers in place: I'm trying to write a plperl function to copy the new row e.g. NEW in plpgsql into another table. I was looking for a similar effect to the INSERT INTO blah VALUES (NEW.*) Syntax that can be used in plpgsql. So fat the best I have come up with is: $collist = ""; $val