The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/datatype-json.html Description:
https://www.postgresql.org/docs/12/datatype-json.html#JSON-INDEXING SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @@ '$.tags[*] ? (@ == "qui")'; Should be: SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @? '$.tags[*] ? (@ == "qui")'; With @@, no result.