Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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