Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t (
    val int[]
);

INSERT INTO t VALUES
('{1,10, 3}'),
('{2, 4, 2}');

SELECT * FROM t

CREATE TABLE



INSERT 0 2




val


{1,10,3}

{2,4,2}



SELECT 2


SELECT
    *
FROM t,
    unnest(val) WITH ORDINALITY as s(element, position)


val
element
position


{1,10,3}
1
1

{1,10,3}
10
2

{1,10,3}
3
3

{2,4,2}
2
1

{2,4,2}
4
2

{2,4,2}
2
3



SELECT 6


SELECT
    position,
    MIN(element),
    MAX(element)
FROM t,
    unnest(val) WITH ORDINALITY as s(element, position)
GROUP BY position


position
min
max


1
1
2

2
4
10

3
2
3



SELECT 3


SELECT 
    ARRAY_AGG(min ORDER BY position),
    ARRAY_AGG(max ORDER BY position)
FROM (
    SELECT
        position,
        MIN(element),
        MAX(element)
    FROM t,
        unnest(val) WITH ORDINALITY as s(element, position)
    GROUP BY position
) s


array_agg
array_agg


{1,4,2}
{2,10,3}



SELECT 1