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 <[EMAIL PROTECTED]> 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
