T822, “SQL/JSON: IS JSON WITH UNIQUE KEYS predicate”
Check for a correct JSON format, either accepting or rejecting objects that have duplicate keys.
SELECT *
FROM …
WHERE j IS JSON WITH UNIQUE KEYS
The example returns rows for which the contents of the column j is valid JSON in which no object has duplicate keys. The following example is therefore not returned because it has an object that contains the key c twice.
T822, “SQL/JSON: IS JSON WITH UNIQUE KEYS predicate”, is an optional feature of ISO/IEC 9075-2:2023. It first appeared in the 2016 revision.
You can’t catch up on 20 years of SQL evolution in one day. Subscribe the newsletter via E-Mail, Bluesky or RSS to gradually catch up and to keep modern-sql.com on your radar.
About the Author
Markus Winand provides insights into SQL and shows how different systems support it at modern-sql.com. Previously he made use-the-index-luke.com, which is still actively maintained. Markus can be hired as trainer, speaker and consultant via winand.at.
