On Wed, Sep 5, 2012 at 9:10 PM, jam3 <jamort...@gmail.com> wrote: > I have searched and searched and just cannot find the maximum lengths for > input variables in a function > > i.e. > > CREATE FUNCTION test(input1 char(5), input2 varchar(50)) > RETURNS void AS > $$RAISE NOTICE('%,%'), $1, $2;$$ > LANGUAGE plpgsql; > > > Where do I find the 5 and the 50 it has to be somewhere I have searched > through > pg_proc > pg_type > pg_attribute (whose attlen only relates to tables) > pg_type > > and all possible manner of joining these tables. > > Hmm. I only looked at the code and hence don't have a definite answer. But it seems that information is not stored anywhere. That might explain why the function you mentioned accepts parameters with any character length.
Thanks, Pavan