Install new perl test function in PostgreSQL - Mailing list pgsql-novice

From Jignesh Shah
Subject Install new perl test function in PostgreSQL
Date
Msg-id c11950270908251001q51fcb29j75b73fb8f1cf6510@mail.gmail.com
Whole thread Raw
Responses Re: Install new perl test function in PostgreSQL
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Lennin Caro
Date:
Subject: Re: compilation error
Next
From: Jure Kobal
Date:
Subject: Re: Install new perl test function in PostgreSQL