Re: [GENERAL] Array as parameter for plpgsql function

2005-07-13 Thread David Pratt
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 <[EMAIL PROTECTED]> writes: CREATE FUNCTION create_record_test(text[][]) RETURNS int4 AS ' DECLARE test_array ALIAS F

Re: [GENERAL] Array as parameter for plpgsql function

2005-07-13 Thread Tom Lane
David Pratt <[EMAIL PROTECTED]> 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