Array in a Type

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

Responses

Browse pgsql-general by date

  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