Re: Install new perl test function in PostgreSQL

Thanks Jure. I have already plperl installed because I could see that many
new perl functions have been installed but I don't know where it plperl
installed. Could you tell me if there is any way to find out where it is
installed? Morever, if I get the location plperl install location, how to
insert/install my perl function? Is there any command available for this. My
questions might be silly but this is first time I am using PostgreSQL.

Thanks for being there.
Jignesh

On Tue, Aug 25, 2009 at 11:24 PM, Jure Kobal <j(dot)kobal(at)gmx(dot)com> wrote:

> 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
>
>