Re: Array as parameter for plpgsql function

argh!!!  It was telling me I had an error in select statement. Thanks
Tom!

Regards
David

On Wednesday, July 13, 2005, at 11:08 AM, Tom Lane wrote:

> David Pratt <fairwinds@eastlink.ca> writes:
>> CREATE FUNCTION create_record_test(text[][]) RETURNS int4 AS '
>>     DECLARE
>>     test_array ALIAS FOR $1;      -- alias for input array
>>     BEGIN
>>         return array_upper(test_array,1)
>>     END;
>> ' LANGUAGE 'plpgsql';
>
>> SELECT create_record_test(ARRAY[ARRAY['A','test one'],ARRAY['B','test
>> two']]) AS output;
>
> Works fine for me, once I add the semicolon you forgot:
>
>         return array_upper(test_array,1);
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that
> your
>        message can get through to the mailing list cleanly
>