Re: pg_type.typname of array types.

Hey Andrew,

Finally convinced. Thanks!

2010/12/8 Andrew Dunstan <andrew(at)dunslane(dot)net>

>
>
> 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 typarray from
> pg_type where typname = 'foo');
> CREATE TYPE
> CREATE TYPE
> typname
> ---------
> ___foo
> (1 row)
>
>
> cheers
>
> andrew
>
>

--
// Dmitriy.