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
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