Thread: 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?

lord.zoltar@gmail.com writes:
> Is it possible to have an array of user-defined types?

Scalar types, yes; composite types, no.  Unfortunately the case you're
talking about is a composite type.

            regards, tom lane