v.25.12Improvement
Support JSON type
SupportJSONtype intupleElement. Closes #81630. #91327 (Pavel Kruglov).
Why it matters
This feature enables users to extract elements of typeJSON from tuples using the tupleElement function, thereby enhancing the function's versatility and support for complex data types.How to use it
Use thetupleElement function with tuples containing JSON type elements as usual. For example:SELECT tupleElement(your_tuple, index) FROM your_table;where the tuple can now include
JSON typed elements.