Search Postgresql Archives

Re: strange type name in information_schema

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.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
>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux