diff options
author | Bruce Momjian | 2015-05-15 15:42:29 +0000 |
---|---|---|
committer | Bruce Momjian | 2015-05-15 15:42:34 +0000 |
commit | f6d65f0c7068bab6a9ca55a82f18fd52e8fd1e5e (patch) | |
tree | 20186a4870aa19b9607430eded4417e7375ad778 /doc/src/sgml/json.sgml | |
parent | 9feaba28e27820f91d13c3de6581bb3b8c3234c6 (diff) |
docs: consistently uppercase index method and add spacing
Consistently uppercase index method names, e.g. GIN, and add space after
the index method name and the parentheses enclosing the column names.
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 |