Re: Doubt about query
От | David G. Johnston |
---|---|
Тема | Re: Doubt about query |
Дата | |
Msg-id | CAKFQuwZG4YxxxpJCvqPrd2nJRp=fxTPz5T55mK_y1s=psgsAzA@mail.gmail.com обсуждение исходный текст |
Ответ на | Doubt about query (Bianca Stephani <bianca.stephani@gmail.com>) |
Ответы |
Re: Doubt about query
|
Список | 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? :|
Do you have a particular output column type you'd like the data to be in?
SELECT ARRAY[col1, col2, col3, col4, col5]::integer[] FROM tbl
David J.
В списке pgsql-novice по дате отправления: