Map functions are a set of specialized tools provided by OceanBase Database for working with map data. These functions enable users to perform complex queries and analyses on map data efficiently.
Below is an overview of the map functions available in OceanBase Database and their purposes:
Types of map functions
| Type | Description |
|---|---|
| Map constructor functions | Create new map data types. |
| Map decision functions | Evaluate map data and return Boolean results. |
| Map manipulation functions | Perform basic operations on map data, such as extracting keys or values, and returning the modified map data. |
Overview of map functions
The following table lists all the map functions currently supported by the OceanBase database:
| Function type | Function name | Description |
|---|---|---|
| Map constructor functions | map |
Create a map data type. |
| Operators | {} |
Construct a map data type. |
| Operators | = / != |
Check whether two map data entries are equal. |
| Map manipulation functions | map_keys |
Retrieve the list of keys from a map. |
| Map manipulation functions | map_values |
Retrieve the list of values from a map. |