Hello type "array of text" has name "_text" Regards Pavel Stehule 2011/5/21 Dan S <strd911@xxxxxxxxx>: > Hi ! > > I'm running "PostgreSQL 9.0.2, compiled by Visual C++ build 1500, 32-bit". > > I'm trying to get type information on functions out of information_schema. > When there is an array as input or output of a function I try to query > information_schema of the array type. > > In this case udt_name gives the type name _text why does it not give text ? > > Is this the right way to query the parameter types ? > > CREATE OR REPLACE FUNCTION test(ta text[]) RETURNS void AS $$ > BEGIN > RETURN; > END; > $$ LANGUAGE plpgsql; > > select p.udt_name,p.data_type,* > from information_schema.routines r ,information_schema.parameters p > where r.routine_name = 'test' > and p.specific_name = r.specific_name > and p.specific_catalog=r.specific_catalog > and p.specific_schema=r.specific_schema > > > Best Regards > Dan S > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
