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

Or in other words... code to "strict"

J

Doug McNaught wrote:

>Christopher Murtagh <christopher(dot)murtagh(at)mcgill(dot)ca> writes:
>
>
>
>> Thanks to a lot of help on this list, I've managed to get my pl/perl
>>function working. However, I have an unexpected result. Here's a simple
>>way to reproduce this problem:
>>
>>CREATE or REPLACE FUNCTION perltest(integer)
>>returns integer as '
>> $MyInt = $MyInt + 1;
>> return $MyInt;
>>' language plperlu;
>>
>>
>
>There's a reason Perl has "my" variables. Use them. ;)
>
>-Doug
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org