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: | Raw Message | Whole Thread | 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 |