Doubt about query - Mailing list pgsql-novice

From Bianca Stephani
Subject Doubt about query
Date
Msg-id CAL5He_fzGgEhDQqr1CLnO53Jef_+SJ0J_0rE6Cie8nvhwAioeA@mail.gmail.com
Whole thread Raw
Responses Re: Doubt about query
List 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.

pgsql-novice by date:

Previous
From: amul sul
Date:
Subject: Re: Re: Why is LOG level below WARNING and ERROR for log_min_error_statement?
Next
From: "David G. Johnston"
Date:
Subject: Re: Doubt about query