Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

arrays of user types.



Hello,
I'm a bit new to PostgreSQL, and I have a question about user-defined
types.
Is it possible to have an array of user-defined types?

Suppose the type looks like this:
CREATE TYPE part AS
   (id int2,
    count int2);

Now I want to have a column in a table that is a list of parts:

alter table items
add column part_list part[];

But when I try to execute this statement, I get the error that "part[]"
is not a defined type.
Is it not possible to have an array of user-defined types?




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group