数智融合计算服务 DATAARTSFABRIC-数组操作符:||

时间:2025-06-17 08:50:04

||

  • 描述:数组与数组进行连接。

    示例:

    1
    2
    3
    4
    5
    SELECT ARRAY[1,2,3] || ARRAY[4,5,6] AS RESULT;
        result     
    ---------------
     {1,2,3,4,5,6}
    (1 row)
    
    1
    2
    3
    4
    5
    SELECT ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9]] AS RESULT;
              result           
    ---------------------------
     {{1,2,3},{4,5,6},{7,8,9}}
    (1 row)
    
support.huaweicloud.com/devg-fabric/dataartsfabric_sql_04_0216.html