2011/5/21 Dan S <strd911@xxxxxxxxx>: > So is there always an underscore prepended to the type name of an array ? > for example float[] would then be _float right ? usually yes - this is older method for marking some type as array. Now array types are described by typelem in pg_type table. Pavel > > Best Regards > Dan S > > 2011/5/21 Pavel Stehule <pavel.stehule@xxxxxxxxx> >> >> 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
