Re: Doubt about query

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.g.johnston@gmail.com <mailto:david.g.johnston@gmail.com>> wrote:
>
>     On Fri, Jun 5, 2015 at 2:00 PM, Bianca Stephani
>     <bianca.stephani@gmail.com <mailto:bianca.stephani@gmail.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"/