Re: [GENERAL] arrays of user types.

2006-10-29 Thread Tom Lane
[EMAIL PROTECTED] 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 ---(end of broadcast)

[GENERAL] arrays of user types.

2006-10-29 Thread lord . zoltar
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 tab