Re: postgresql 7.0.3 -- but NO plperl ?

["Eric G . Miller" <egm2@jps.net>]

On Tue, Feb 06, 2001 at 10:09:48PM -0600, will trillich wrote:
> 
> well that makes a difference... i'm sure :(

sorry, brain fart.

> % locate plperl
> /usr/share/doc/postgresql-doc/src/pl/plperl
> /usr/share/doc/postgresql-doc/src/pl/plperl/README

$ dpkg -S plperl.so
postgresql: /usr/lib/postgresql/lib/plperl.so
$ dpkg -l postgresql
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err:
uppercase=bad)
||/ Name                Version             Description
+++-===================-===================-======================================================
ii  postgresql          7.0.3-4             Object-relational SQL database, descended from POSTGRE

·
·
·

Okay, I got it working...

----- < modified mklang_pl.sql > ---------
--  
-- PL/pgSQL language declaration
--
-- $Header: /cvs/pgsql-deb/postgresql/src/pl/plpgsql/src/mklang.sql.in,v 1.1.1.2 2000/11/14 10:40:20 elphick Exp $
-- Modified for plperl

-- drop procedural language 'plperl';
-- drop function plperl_call_handler();

create function plperl_call_handler() returns opaque
	as '/usr/lib/postgresql/lib/plperl.so'
	language 'C';

create trusted procedural language 'plperl'
	handler plperl_call_handler
	lancompiler 'PL/Perl';

------ <end mklang_pl.sql> --------------

$ psql
template1=# \i mklang_pl.sql
CREATE
CREATE
template1=# create function one_and_two(int4,int4) returns int4 as
'return $_[0] + $_[1];' language 'plperl';
CREATE
template1=# select one_and_two(7,8);
 one_and_two 
 -------------
           15
(1 row)


Luck,
-- 
Eric G. Miller <egm2@jps.net>