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 по дате отправления: