How to create a 1D array using multiple loop variables

SQL++
,
2

Hi @mtannerman ,

SELECT VALUE ARRAY_FLATTEN(ARRAY_AGG(ARRAY "a=" || TO_STR(a) || " b=" || TO_STR(b) FOR b IN [1,2,3] END) ,1) FROM [1,2,3] AS a;

SELECT VALUE ARRAY "a=" || TO_STR(IDIV(a,3)) || " b=" || TO_STR(IMOD(a,3)) FOR a IN ARRAY_RANGE(0,9) END;

SELECT VALUE ARRAY_FLATTEN(ARRAY (ARRAY "a=" || TO_STR(a) || " b=" || TO_STR(b) FOR b IN ARRAY_RANGE(0,3) END) FOR a IN ARRAY_RANGE(0,3) END,1);

SELECT VALUE ARRAY_AGG( "a=" || TO_STR(a) || " b=" || TO_STR(b)) FROM [1,2,3] AS a UNNEST [1,2,3] AS b;

SELECT VALUE "a=" || TO_STR(a) || " b=" || TO_STR(b) FROM [1,2,3] AS a UNNEST [1,2,3] AS b;

ARRAY_RANGE(), DATE_RANGE()

1 Like