Re: Where is the char and varchar length in pg_catalog for function input variables

On Wed, Sep 5, 2012 at 9:10 PM, jam3 <jamorton3(at)gmail(dot)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