[GENERAL] text array accumulate to multidimensional text array

2008-10-21 Thread Rainer Zaiss
Dear list, I would like to aggregate a text array into a multidimensional text array. Let us say I have one table with two collumns IDARRAY A{"A1","B1","C1"} A{"A2","B2","C2"} B {"A3","B3","C3"} If I use a GROUP BY ID, I would like to receive following result: ID ARRAY A {{"A

[GENERAL] output array elements in rows

2008-05-03 Thread Rainer . Zaiss
Dear list, I'm looking for a function to output the elements of my array column in rows ? Let's say I have following table: id = integer nam= array char varying idnam 1 {"nam1","nam2","nam3"} 2{"n1","n2"} I think there should be available a function to expand the elements of an