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.

{"a": 42
,"b": [{"c":1, "c":2}]
}

Related

Optional Features

• T821, "Basic SQL/JSON query operators"

  • The is [not] json [array|object|scalar] predicate

Tutorials

• JSON in SQL:2016

Normative References

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

Can I use...

News

The Standard

Concepts

Features

Use Cases