Re: plpgsql function parameter questions

>> 1. what version of pg do i need to go to in order to eliminate the '16
>> parameter maximum' restraint?

Build your own version with a suitable value of FUNC_MAX_ARGS (a/k/a
INDEX_MAX_KEYS) in src/include/config.h.

>> 2. can i pass an array of integers to a function? can i return an array of
>> integers? if so, what would the function definition look like?

test71=# create function foo (integer[]) returns integer[] as '
test71'# begin
test71'# return $1;
test71'# end;' language 'plpgsql';
CREATE
test71=# select foo('{1,2,3}');
foo
---------
{1,2,3}
(1 row)

Actually doing any serious manipulation of an array in plpgsql might be
tricky, however. In particular, I don't see any simple way to construct
an array value from scratch. You might have better luck with pltcl.
There are examples of array-value manipulation in pltcl's self-test, IIRC.

regards, tom lane