David Pratt <fairwinds@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
