| From: | Omachonu Ogali <missnglnk(at)informationwave(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Array in a Type |
| Date: | 2005-11-04 03:52:50 |
| Message-ID: | 20051104035250.GA20042@dipole.informationwave.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vishal saberwal | 2005-11-04 03:59:41 | Image File System Question |
| Previous Message | Christopher Browne | 2005-11-04 03:29:56 | Re: Replicating databases |