sql - PostgreSQL 将数组转换为二维

Question

我是 PostgreSQL 的新手，我在 PostgreSQL 中使用 array 类型

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

我收到这个错误:

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

我想办法改变

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

排到这个

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

我得到的结果如下:{"{1,3}","{2,3}"}。但我需要结果 int[][] 类型。如何将 一维数组 转换为 二维数组

Answer 1

我暂时使用它，我认为它不是完美的方式。

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[][]