BSON_
On this page
Returns a string that specifies the BSON type of the input BSON value.
Syntax
BSON_GET_TYPE(<input>)
Argument
<input>: A valid BSON value or an expression that evaluates to a valid BSON value.
Return Type
A string.
Remarks
-
If
NULLis specified as the input value, returns"null"as the result. -
If the input is an invalid BSON value, returns
"missing"as the result.
Examples
Note: The following examples explicitly cast string to BSON for clarity.
SELECT BSON_GET_TYPE( '{"a":1, "b":2, "c":"abc"}':>BSON) AS Type;
+--------+
| Type |
+--------+
| object |
+--------+SELECT BSON_GET_TYPE('[1, true, null, [7,8,9], "abc"]':>BSON) AS Type;
+-------+
| Type |
+-------+
| array |
+-------+SELECT BSON_GET_TYPE('true':>BSON) AS Type;
+------+
| Type |
+------+
| bool |
+------+SELECT BSON_GET_TYPE('"abc"':>BSON) AS Type;
+--------+
| Type |
+--------+
| string |
+--------+SELECT BSON_GET_TYPE('null':>BSON) AS Type;
+------+
| Type |
+------+
| null |
+------+SELECT BSON_GET_TYPE("abc") AS Type;
+---------+
| Type |
+---------+
| missing |
+---------+Last modified: April 3, 2024