Home > mailing lists

Re: Doubt about query - Mailing list pgsql-novice

From	David G. Johnston
Subject	Re: Doubt about query
Date	June 5, 2015 21:39:48
Msg-id	CAKFQuwakYSDBzKQPyodvNYJNRUuAO-2bO56soOy66=JeG4J+Gg@mail.gmail.com Whole thread Raw
In response to	Re: Doubt about query (Bianca Stephani <bianca.stephani@gmail.com>)
Responses	Re: Doubt about query (Bianca Stephani <bianca.stephani@gmail.com>)
List	pgsql-novice

Tree view

On Fri, Jun 5, 2015 at 2:00 PM, Bianca Stephani <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.

pgsql-novice by date:

From: Bianca Stephani
Date: 05 June 2015, 21:00:26
Subject: Re: Doubt about query

From: Bianca Stephani
Date: 08 June 2015, 01:51:47
Subject: Re: Doubt about query

Re: Doubt about query - Mailing list pgsql-novice

Previous

Next