Edit

Share via

ARRAY_CONCAT (NoSQL query)

  • Applies to: Azure Cosmos DB for NoSQL, Cosmos DB in Fabric

The ARRAY_CONCAT function 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 array expression in the list.
array_expr_2 The second array expression in the list.
array_expr_N Optional additional array expressions to concatenate.

Return types

Returns an array expression.

Examples

This section contains examples of how to use this query language construct.

Concatenate two arrays

In this example, the ARRAY_CONCAT function concatenates two arrays.

SELECT
  ARRAY_CONCAT([
      "backpacks",
      "daypacks"
    ], [
      "hippacks"
    ]) AS gearList

[
  {
    "gearList": [
      "backpacks",
      "daypacks",
      "hippacks"
    ]
  }
]

Remarks

  • This function doesn't utilize the index.