I was just wondering if one could use something like this
CREATE FUNCTION funcname (argument-types) RETURNS return-type AS $$ require "abc.pl"
$$ LANGUAGE plperl;
To include abc.pl here, how is the path of abc.pl specified. Also, just wondering if the structure of above function is correct atall at the first place
~Harpreet
On 1/16/07, John DeSoi <desoi@pgedit.com> wrote:I assume your choices are to include the entire script in a
PostgreSQL function or simply create a small stub function that calls
a function you have loaded with use or require (as mentioned by the
other poster). But either way, you have to create a function so you
can tell PostgreSQL what to call, what the parameters are, and what
values should be returned.
John
On Jan 16, 2007, at 10:25 AM, Jasbinder Singh Bali wrote:
> So there is nothing called dynamic loading of perl code in postgres.
> I'll have to include the whole perl script in the postgres function
> you mean?
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster