diff options
| author | Michael Paquier <michael@paquier.xyz> | 2021-04-16 16:56:25 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2021-04-16 16:56:25 +0900 |
| commit | 0e8acd39ecdf9a68ebdaf9652a56b943f34c9c58 (patch) | |
| tree | c3e9292794ee2e87b8189be15dacb49616a32ddc | |
| parent | c39aa1e878cb9da16ed6bbc32bb1c83ef93595d4 (diff) | |
| download | postgresql-0e8acd39ecdf9a68ebdaf9652a56b943f34c9c58.tar.gz postgresql-0e8acd39ecdf9a68ebdaf9652a56b943f34c9c58.zip | |
doc: Fix typo in example query of SQL/JSON
Author: Erik Rijkers
Discussion: https://postgr.es/m/1219476687.20432.1617452918468@webmailclassic.xs4all.nl
Backpatch-through: 12
| -rw-r--r-- | doc/src/sgml/json.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/json.sgml b/doc/src/sgml/json.sgml index c0a6554d4d7..0586c431207 100644 --- a/doc/src/sgml/json.sgml +++ b/doc/src/sgml/json.sgml @@ -489,7 +489,7 @@ CREATE INDEX idxgintags ON api USING GIN ((jdoc -> 'tags')); SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @@ '$.tags[*] == "qui"'; </programlisting> <programlisting> -SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @@ '$.tags[*] ? (@ == "qui")'; +SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @? '$.tags[*] ? (@ == "qui")'; </programlisting> GIN index extracts statements of following form out of <literal>jsonpath</literal>: <replaceable>accessors_chain</replaceable> = <replaceable>const</replaceable>. |