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>