连接两个数组

CONCAT 函数连接两个数组。它返回包含并置和的新数组。 || 和 CONCAT 函数均可用于连接：

: "||" :
|
CONCAT'(': , : ')'

下一个示例说明了 CONCAT 函数的用法：

CREATE PROCEDURE ARRAY_COMPLEX_CONCAT3(OUT OUTTAB TABLE (SEQ INT, ID INT)) 
LANGUAGE SQLSCRIPT AS 
BEGIN
	DECLARE id1,id2,id3, id4, id5, card INTEGER ARRAY; 
id1[1]  = 0;
	id2[1]  = 1;
	id3  = CONCAT(:id1, :id2);
	id4  = :id1 || :id2;
	rst  = UNNEST(:id3) WITH ORDINALITY AS ("ID", "SEQ");
	id5  = :id4 || ARRAY_AGG(:rst."ID" ORDER BY "SEQ");
	rst1 = UNNEST(:id5 || CONCAT(:id1, :id2) || CONCAT(CONCAT(:id1, :id2),
CONCAT(:id1, :id2))) WITH ORDINALITY AS ("ID", "SEQ");
outtab = SELECT SEQ, ID FROM :rst1 ORDER BY SEQ;
END;