Re: pl/perl function life and variable scope - concurrency problem?

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)