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
>
