Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Workaround to get arrays for plperl


  • From: CaT <cat(at)zip(dot)com(dot)au>
  • To: Eugen(dot)Konkov(at)aldec(dot)com
  • Cc: pgsql-bugs(at)postgresql(dot)org
  • Subject: Re: Workaround to get arrays for plperl
  • Date: Mon, 31 Mar 2008 00:27:19 +1100
  • Message-id: <20080330132718.GD4736@zip.com.au> <text/plain>

On Sun, Mar 30, 2008 at 04:23:07PM +0300, Eugen(dot)Konkov(at)aldec(dot)com wrote:
> It seems that function get arrays as strings in plperl.
> This is a little workaround who want pass arrays to plperl functions
> 
> my( $strarr )= @_;
> $strarr =~ s/{/[/g;
> $strarr =~ s/}/]/g;
> my $arr= eval $strarr;
> 
> NOTICE:
> you must create you function as plperlu
> and add language:
> create language plperlu;

It's late and I'm sleepy, but, that looks extremely hazardous to ones
health. Esp if the arrays you speak of have any chance of containing
anything that might look like perl code to begin with. ie think sql
injection, but with perl code rather then sql.

cat



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group