Edit

ARRAY_CONCAT (NoSQL query)

  • Article

APPLIES TO: NoSQL

Returns an array that is the result of concatenating two or more array values.

Syntax

ARRAY_CONCAT(<array_expr_1>, <array_expr_2> [, <array_expr_N>])

Arguments

Description
array_expr_1 The first expression in the list.
array_expr_2 The second expression in the list.
array_expr_N (Optional) Optional expression[s], which can contain a variable number of expressions up to the Nth item in the list.

Note

The ARRAY_CONCAT function requires at least two array expression arguments.

Return types

Returns an array expression.

Examples

The following example shows how to concatenate two arrays.

SELECT
    ARRAY_CONCAT(["apples", "strawberries"], ["bananas"]) AS arrayConcat

[
  {
    "arrayConcat": [
      "apples",
      "strawberries",
      "bananas"
    ]
  }
]

Remarks

  • This function doesn't utilize the index.

Related content