arrays of user types.

Поиск
Список
Период
Сортировка
От lord.zoltar@gmail.com
Тема arrays of user types.
Дата
Msg-id 1161915797.582949.233510@k70g2000cwa.googlegroups.com
обсуждение исходный текст
Ответы Re: arrays of user types.
Список pgsql-general
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?


В списке pgsql-general по дате отправления: