So is there always an underscore prepended to the type name of an array ? for example float[] would then be _float right ?
Best Regards Dan S 2011/5/21 Pavel Stehule <pavel.steh...@gmail.com> > Hello > > type "array of text" has name "_text" > > Regards > > Pavel Stehule > > 2011/5/21 Dan S <strd...@gmail.com>: > > 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 > > >
