PostgreSQL cast array to two-dimensional

Question

I am new at PostgreSQL, I use array type in PostgreSQL

WITH intarr AS (
    SELECT
        ARRAY [ s.days,s.hours ] ::int[] AS arr
    FROM summary s
    WHERE s.hours != 2
)
SELECT ARRAY(SELECT * from intarr );

I get this error:

[Err] ERROR: could not find array type for data type integer[]

I find a way change

ARRAY [ s.days,s.hours ] ::int[] AS arr

row to this

ARRAY [ s.days,s.hours ] ::varchar AS arr

I get result like : {"{1,3}","{2,3}"} . But I need result int[][] type .How I convert one-dimensional array to two-dimensional array

I did it, but I don't know is it good solution ? SELECT replace( (SELECT ARRAY(SELECT arr from intarr)::VARCHAR), '"', '')::int[][] — user527
– user527, Commented Oct 1, 2015 at 6:32

user527 · Accepted Answer · 2015-10-01 07:44:34Z

1

I use it for now,I don't think it is perfect way.

WITH intarr AS (
    SELECT
        ARRAY [ s.days,s.hours ] ::VARCHAR AS arr
    FROM
        summary s
    WHERE
        s.hours != 2
)
SELECT replace((SELECT ARRAY(SELECT arr from intarr)::VARCHAR), '"', '')::int[][]

answered Oct 1, 2015 at 7:44

user527

2052 gold badges7 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL cast array to two-dimensional

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related