This is a discussion on arrays of user types. within the Pgsql General forums, part of the PostgreSQL category; --> Hello, I'm a bit new to PostgreSQL, and I have a question about user-defined types. Is it possible to ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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? |