云数据库 GAUSSDB-数组操作符:||

时间:2025-06-03 09:35:44

||

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

    示例:

    1
    2
    3
    4
    5
    gaussdb=# 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
    gaussdb=# 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/centralized-devg-v8-gaussdb/gaussdb-42-2040.html