Re: pg_type.typname of array types.

On 12/08/2010 05:35 AM, Dmitriy Igrishin wrote:
> Hey hackers@,
>
> Is it guaranteed that name of array types in pg_type system
> catalog will always be prefixed by underscore or this convention
> can be changed in future ?
>
>


It is not guaranteed today, let alone in the future, that the array type 
for x will be _x for any x.

Consider:
   andrew=# create type _foo as (x int); create type foo as (y   text);select typname from pg_type where oid = (select
typarrayfrom   pg_type where typname = 'foo');   CREATE TYPE   CREATE TYPE     typname   ---------     ___foo   (1
row)


cheers

andrew