Re: Doubt about query
| От | David G. Johnston |
|---|---|
| Тема | Re: Doubt about query |
| Дата | |
| Msg-id | CAKFQuwakYSDBzKQPyodvNYJNRUuAO-2bO56soOy66=JeG4J+Gg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Doubt about query (Bianca Stephani <bianca.stephani@gmail.com>) |
| Ответы |
Re: Doubt about query
|
| Список | pgsql-novice |
Thanks for answering. I've already tryied that. When I do what you've said, i get this:[{"array" => "{1,2,3,4,5}"}, {"array" => "6,7,8,9,10}"}...]When what i want is this: [1,2,3,4,5,6,7,8,9,19]
Please don't top-post...
Nowhere are you mentioning JSON but I presume what you are trying to do involves that...
I'm not sure how you expect to the 10 numbers when you only want to concatenate 5 columns...
You should share what you have done and the sample data you are using.
SELECT array_agg(unnest) AS row_agg FROM (
SELECT unnest(col_agg) FROM (
SELECT ARRAY[...] AS col_agg FROM ...
)));
That gets you a single array with all the rows and columns in the same dimension.
David J.
В списке pgsql-novice по дате отправления: