First you need to install plperl into your database if you haven't already.
createlang -h <host> -p <port> -U <user> plperl <db_name>
-h, -p aren't really needed if you work on the box where postgres is installed.
After that you just insert/install the function into the database where you have
installed plperl and it should work via select <function_name>.
--
Regards,
Jure Kobal
On Tuesday 25 of August 2009 19:01:44 Jignesh Shah wrote:
> Hi,
>
> I have taken below perl example form PostgreSQL documentation Chapter: 40.1
>
> CREATE FUNCTION perl_max (integer, integer) RETURNS integer AS $$
> if ($_[0] > $_[1]) { return $_[0]; }
> return $_[1];
> $$ LANGUAGE plperl;
>
> I understood everything but I don't know how to integrate/install this new
> function with PostgreSQL so that when I run "select perl_max(1,2)" query,
> it returns 2. I have PostgreSQL install on one of my UNIX Server and has
> root privileges. Please help me to install this function.
>
> Thanks,
> Jignesh