can anyone tell me how in Postgres to iterate over an array in select'e?

For example, there is an array

{{1,2,3,4,10,12},{1,4,3,3,25,14},{1,6,3,3,11,14}}

I need to get the sum of 5 and 6 elements, and output the lines in descending order, that is, it should turn out like this

 1,2,3,4,22 1,6,3,3,25 1,4,3,3,39

Refinement, these are separate columns, not a whole row.

Is it possible to do this somehow with a window function, but not through a function and a loop, namely, select? Everything is fine through my function. Here precisely to understand, whether it is possible to sort through an array.

Specification, initially the number of elements is unknown, that is, it is hard to select an array [1: 1], array [1: 2], etc., which will not work.

    1 answer 1

     SELECT columns ->> 0 AS col1, columns ->> 1 AS col2, columns ->> 2 AS col3, columns ->> 3 AS col4, (columns ->> 4)::int + (columns ->> 5)::int AS col5 FROM json_array_elements(array_to_json('{{1,2,3,4,10,12},{1,4,3,3,25,14},{1,6,3,3,11,14}}'::int[])) columns ORDER BY col5;
    • how simple, thank you very much. And then I have already gone into the jungle of the type of such array_to_string (array_agg (quote_ident (f)), ',') - Vladislav