Doubt about query

From: Bianca Stephani <bianca(dot)stephani(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Doubt about query
Date: 2015-06-05 17:25:16
Message-ID: CAL5He_fzGgEhDQqr1CLnO53Jef_+SJ0J_0rE6Cie8nvhwAioeA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

HI everyone.

I have a table with X columns. And I want to make a select of 5 of the X
columns in a way that i get all the 5 columns values only in one column
(like i call everyone "AS bla" and as result, bla is an array of that
columns), but if i use 5 selects with UNION ALL i just get [{bla => 3},
{bla => 3}, {bla => 1}, {bla => 5}, {bla => 2} ...] even with a GROUP BY.
And besides that, using "as bla" is turning my results (3, 1, 5, 2) into
strings.

What is the best way to collect the value of multiple integer columns as
one? :|

Thanks.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David G. Johnston 2015-06-05 17:40:01 Re: Doubt about query
Previous Message amul sul 2015-06-05 10:12:17 Re: Re: Why is LOG level below WARNING and ERROR for log_min_error_statement?