diff options
Diffstat (limited to 'doc/src/sgml/json.sgml')
-rw-r--r-- | doc/src/sgml/json.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/json.sgml b/doc/src/sgml/json.sgml index 6282ab88539..1e78558e27a 100644 --- a/doc/src/sgml/json.sgml +++ b/doc/src/sgml/json.sgml @@ -375,13 +375,13 @@ SELECT '"foo"'::jsonb ? 'foo'; implement, see <xref linkend="functions-jsonb-op-table">.) An example of creating an index with this operator class is: <programlisting> -CREATE INDEX idxgin ON api USING gin (jdoc); +CREATE INDEX idxgin ON api USING GIN (jdoc); </programlisting> The non-default GIN operator class <literal>jsonb_path_ops</> supports indexing the <literal>@></> operator only. An example of creating an index with this operator class is: <programlisting> -CREATE INDEX idxginp ON api USING gin (jdoc jsonb_path_ops); +CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); </programlisting> </para> @@ -426,7 +426,7 @@ SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc -> 'tags' ? 'qui' the <literal>"tags"</> key is common, defining an index like this may be worthwhile: <programlisting> -CREATE INDEX idxgintags ON api USING gin ((jdoc -> 'tags')); +CREATE INDEX idxgintags ON api USING GIN ((jdoc -> 'tags')); </programlisting> Now, the <literal>WHERE</> clause <literal>jdoc -> 'tags' ? 'qui'</> will be recognized as an application of the indexable |