Thread: Array of Objects

Array of Objects

From

"Cima"

Date:

18 March 2005, 21:33:34

hi,

im working with Postgresql 8.0.1 and i was wondering if is it possible to make an array of objects, say for example an array of tables.

my_table(col1 int , col2 varchar(5));

another_table (col3 int, col4 ?)

i would like col4 to be an array of my_table.

thanx.

Re: Array of Objects

From

Tom Lane

Date:

18 March 2005, 22:35:12

"Cima" <ruel.cima@facinf.uho.edu.cu> writes:
> my_table(col1 int , col2 varchar(5));
> another_table (col3 int, col4 ?)
> i would like col4 to be an array of my_table.

Sorry, we don't currently support arrays of composite types.

            regards, tom lane