Re: pl/perl function life and variable scope - concurrency problem? - Mailing list pgsql-general

On Wed, Nov 12, 2003 at 03:05:34PM -0500, Christopher Murtagh wrote:

> CREATE or REPLACE FUNCTION perltest(integer)
> returns integer as '
>   $MyInt = $MyInt + 1;
>   return $MyInt;
> ' language plperlu;

Use a local variable:

 CREATE or REPLACE FUNCTION perltest(integer)
 returns integer as '
   my $MyInt = $MyInt + 1;
   return $MyInt;
 ' language plperlu;

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The problem with the future is that it keeps turning into the present"
(Hobbes)