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

From: jam3 <jamorton3(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Where is the char and varchar length in pg_catalog for function input variables
Date: 2012-09-05 15:40:41
Message-ID: 1346859641085-5722845.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Where-is-the-char-and-varchar-length-in-pg-catalog-for-function-input-variables-tp5722845.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-09-05 16:05:04 Re: Where is the char and varchar length in pg_catalog for function input variables
Previous Message Tom Lane 2012-09-05 15:33:45 Re: postgres process got stuck in "notify interrupt waiting" status