Re: Doubt about query

I'm sorry. What is "top-post"? :/

What I want exactly is to get all the values from rows from all 5 coluns
into only one row and one column.

A normal select of columns A, B, C, D would get 5 rows each one with 5
columns with 1 integer each rowXcolumn, for example. I want as result (*as
integer, not string*) a single column and single row with a list of
integers. Is that possible?

What you suggested to me as sql, give me a string of integers "1,2,3,4,5,6"
and not an array

On Fri, Jun 5, 2015 at 3:38 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Fri, Jun 5, 2015 at 2:00 PM, Bianca Stephani <bianca(dot)stephani(at)gmail(dot)com
> > wrote:
>
>> 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.
> ​
>

--
Bianca Stephani.

*"Killing time before time kill us""Panic called you out and took you in,
giving you an easy game and letting you win""Who's gonna love you when you
reach the end?""A diferença entre a vida e a arte é que a arte é mais
suportável""Smile like you mean it""I told you I was brave, but I've
lied""If you don't do anything, nothing can happen"*