Re: [GENERAL] text array accumulate to multidimensional text array

2008-10-22 Thread Merlin Moncure
On Wed, Oct 22, 2008 at 12:55 PM, Osvaldo Kussama <[EMAIL PROTECTED]> wrote: > 2008/10/14, Rainer Zaiss <[EMAIL PROTECTED]>: >> >> 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"

Resp.: [GENERAL] text array accumulate to multidimensional text array

2008-10-22 Thread Osvaldo Kussama
2008/10/14, Rainer Zaiss <[EMAIL PROTECTED]>: > > 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

Re: [GENERAL] text array accumulate to multidimensional text array

2008-10-21 Thread Merlin Moncure
On Tue, Oct 14, 2008 at 9:22 AM, Rainer Zaiss <[EMAIL PROTECTED]> wrote: > 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","

[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