arrays of user types.
Started by Nonameover 19 years ago2 messagesgeneral
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?
