Array of created types

From: Kelly Burkhart <kelly(at)tradebotsystems(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Array of created types
Date: 2005-09-01 15:07:21
Message-ID: 1125587241.18140.27.camel@krb06.tradebot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Should something similar to the following be possible in PG 8.0.3?

create type foo_t as ( c1 int, c2 int );
create table tab (
name varchar not null,
foos foo_t[]
);

The response I get is:

ERROR: type "foo_t[]" does not exist

The create type documentation says that postgres silently creates an
array type for each base type with an underscore prepended to the base
name. That makes it sound like the following should work:

create table tab (
name varchar not null,
foos _foo_t
);
ERROR: type "_foo_t" does not exist

How can I create a table containing an array of items of a created type?

-K

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-09-01 15:14:41 Re: Order By for aggregate functions (Simulating Group_concat)
Previous Message Bob 2005-09-01 14:49:05 Re: Select All Columns