Array in a Type

Поиск
Список
Период
Сортировка
От Omachonu Ogali
Тема Array in a Type
Дата
Msg-id 20051104035250.GA20042@dipole.informationwave.net
обсуждение исходный текст
Ответы Re: Array in a Type
Список pgsql-general
I've created a type that contains a few types and an array. But when
I try to create an array from that in a table, I get a '"type[]" does
not exist' error. The manual says that the array type is configured
automatically when a type is created, but this doesn't appear to be
the case. Am I missing something?

widget=# \d network_interfaces;
Composite type "public.network_interfaces"
    Column    |          Type
--------------+------------------------
 manufacturer | integer
 chipset      | character varying(128)
 ports        | integer
 speeds       | integer[]

widget=# create table box(id int, network network_interfaces[]);
ERROR: type "network_interfaces[]" does not exist

В списке pgsql-general по дате отправления:

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: Replicating databases
Следующее
От: vishal saberwal
Дата:
Сообщение: Image File System Question