This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
JSON functions
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
jOOQ 3.12 introduced support for the org.jooq.JSON and org.jooq.JSONB types, which are used to wrap string based JSON documents in a type safe way. With these types, there are also a few standard JSON functions that have been added to the API. This section describes scalar functions, but there are also conditions, aggregate functions, and table valued functions for JSON usage.
Most functions are overloaded with a JSON and JSONB variant to make the distinction explicit for dialects where this matters. For simplicity, and because most dialects do not make a distinction, this manual will only document the JSON version of each function.
Table of contents
- 3.11.20.1.
- JSON_ARRAY
- 3.11.20.2.
- JSON_ARRAY_LENGTH (new)
- 3.11.20.3.
- JSON_INSERT
- 3.11.20.4.
- JSON_KEY_EXISTS (new)
- 3.11.20.5.
- JSON_KEYS
- 3.11.20.6.
- JSON_OBJECT
- 3.11.20.7.
- JSON_REMOVE
- 3.11.20.8.
- JSON_REPLACE
- 3.11.20.9.
- JSON_SET
- 3.11.20.10.
- JSON_VALUE
- 3.11.20.11.
- JSON array element access with -> or ->>
- 3.11.20.12.
- JSON object attribute access with -> or ->>
| previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!