BSON_
On this page
Adds the specified BSON value to the end of the input BSON array, and returns the array with the appended value as the result.
Syntax
BSON_ARRAY_PUSH(<array>, <value>)Arguments
-
<array>: A valid BSON array or an expression that evaluates to a BSON array. -
<value>: A BSON value to be appended to the input array.
Return Type
A BSON array.
Remarks
-
If
NULLis specified as the input array, it is considered as an empty BSON array. -
If
NULLis specified as the value to append, it is considered as the BSONNULLtype.
Examples
Note: The following examples explicitly cast string to BSON for clarity.
SELECT BSON_ARRAY_PUSH('[1, true, null, [7,8,9], "abc"]':>BSON, '{"a":{"b":9}}':>BSON):>JSON AS Result;
+-------------------------------------------+
| Result |
+-------------------------------------------+
| [1,true,null,[7,8,9],"abc",{"a":{"b":9}}] |
+-------------------------------------------+SELECT BSON_ARRAY_PUSH('[]':>BSON, '"abc"':>BSON):>JSON AS Result;
+---------+
| Result |
+---------+
| ["abc"] |
+---------+SELECT BSON_ARRAY_PUSH('[1,2,3,4]':>BSON, 'null':>BSON):>JSON AS Result;
+----------------+
| Result |
+----------------+
| [1,2,3,4,null] |
+----------------+Last modified: April 2, 2024