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