summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian2022-08-12 15:26:03 +0000
committerBruce Momjian2022-08-12 15:26:03 +0000
commitfd868582e2df970326d810d5085db4844f290c1d (patch)
treebb6f8e08567da154cbc445dfc7abd930c801098a /doc/src
parent05b2a4bda20f41303c2330c306b183e5024648ee (diff)
doc: document the CREATE INDEX "USING" clause
Somehow this was in the syntax but had no description. Reported-by: robertcorrington@gmail.com Discussion: https://postgr.es/m/164228771825.31954.2719791849363756957@wrigleys.postgresql.org Backpatch-through: 10
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/create_index.sgml12
1 files changed, 12 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml
index 7b3465ca7a5..45ca56fad3a 100644
--- a/doc/src/sgml/ref/create_index.sgml
+++ b/doc/src/sgml/ref/create_index.sgml
@@ -150,6 +150,18 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
</varlistentry>
<varlistentry>
+ <term><literal>USING</literal></term>
+ <listitem>
+ <para>
+ The optional <literal>USING</literal> clause specifies an index
+ type as described in <xref linkend="indexes-types"/>. If not
+ specified, a default index type will be used based on the
+ data types of the columns.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
<term><literal>INCLUDE</literal></term>
<listitem>
<para>