v.21.11Improvements
Function has: Added Map data type support
Functionhas: added support forMapdata type. #29267 (Maksim Kita).
Why it matters
This feature extends thehas function to work with the Map data type, enabling users to check for the presence of keys within Map columns efficiently. It enhances querying capabilities when working with complex data types.How to use it
You can use thehas function directly on Map type columns to check if a given key exists. For example:SELECT has(map_column, 'key_to_check') FROM table_name;