New versions: Dev (3.14) | Latest (3.13) | 3.12

JSON predicate

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The JSON predicate can be used to check if a given expression is valid JSON

SELECT 1
FROM dual
WHERE '{}' IS JSON
AND '{' IS NOT JSON
create.selectOne()
      .where(val("{}").isJson())
      .and(val("{").isNotJson())
      .fetch();
The jOOQ Logo