On 08/06/15 10:51, Bianca Stephani wrote:
> 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 <mailto: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 <mailto: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"/