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(at)eastlink(dot)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(at)postgresql(dot)org so that
> your
> message can get through to the mailing list cleanly
>