Re: [HACKERS] plperl intial pass - Mailing list pgsql-hackers

From Oleg Bartunov
Subject Re: [HACKERS] plperl intial pass
Date
Msg-id Pine.GSO.3.96.SK.990726042649.4164B-100000@ra
Whole thread Raw
In response to Re: [HACKERS] plperl intial pass  (Mark Hollomon <mhh@mindspring.com>)
List pgsql-hackers
Great !

at least your examples works:
test=> select hello();
NOTICE:  plperl_func_handler: have been asked to call __PLperl_proc_329289
NOTICE:  plperl_func_handler: __PLperl_proc_329289 was in the hash
NOTICE:  plperl_call_perl_func: calling __PLperl_proc_329289
NOTICE:  plperl_func_handler: returned from plperl_call_perl_func
NOTICE:  plperl_func_handler: return as string = Hello world!
NOTICE:  plperl_func_handler: Datum is 826ee30
hello       
------------
Hello world!
(1 row)
test=> create function sum2 (int4, int4) returns int4 as '
test'> $_[0] + $_[1];' language 'plperl';
CREATE
test=> select sum2(4,2);
NOTICE:  plperl_func_handler: have been asked to call __PLperl_proc_329290
NOTICE:  plperl_func_handler: __PLperl_proc_329290 doesn't exist yet
NOTICE:  plperl_create_sub: creating the sub
NOTICE:  plperl_call_perl_func: calling __PLperl_proc_329290
NOTICE:  plperl_func_handler: returned from plperl_call_perl_func
NOTICE:  plperl_func_handler: return as string = 6
NOTICE:  plperl_func_handler: Datum is 6
sum2
----  6
(1 row)
Regards,        Oleg
On Sun, 25 Jul 1999, Mark Hollomon wrote:

> Date: Sun, 25 Jul 1999 12:08:51 -0400
> From: Mark Hollomon <mhh@mindspring.com>
> To: Oleg Bartunov <oleg@sai.msu.su>
> Cc: pgsql-hackers@postgreSQL.org
> Subject: Re: [HACKERS] plperl intial pass
> 
> On Sat, Jul 24, 1999 at 10:26:33PM +0400, Oleg Bartunov wrote:
> > Great,
> > 
> > just compiled and install but need to look at some examples :-)
> > btw, here is a patch for createlang command to enable plperl
> > I'm not sure about trusted field.
> 
> At this point it definitely should not be trusted. (Trust me).
> 
> How about the famous hello world:
> 
> create function hello () returns text as '
> return "Hello world!";' language 'plperl';
> 
> or a quick sum:
> 
> create function sum2 (int4, int4) returns int4 as '
> $_[0] + $_[1];' language 'plperl';
> 
> The args are in @_ (naturally). Tuples are passed as
> hash references.
> 
> Access to SPI functionality is coming.
> 
> 
> 
> -- 
> Mark Hollomon
> mhh@mindspring.com
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83



pgsql-hackers by date:

Previous
From: Mark Hollomon
Date:
Subject: Re: [HACKERS] plperl intial pass
Next
From: Vadim Mikheev
Date:
Subject: don't lose me :)