diff options
| author | Bruce Momjian <bruce@momjian.us> | 2022-08-12 11:26:03 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2022-08-12 11:26:03 -0400 |
| commit | ca82ad08fe1640509b1cc47b7bff3ef4ddc627fe (patch) | |
| tree | 56d7f117d82c31bdb6a8e42439388d87117b9596 | |
| parent | 4e32fb1631dc6a7e0bb21b2e4ac77299231c2745 (diff) | |
| download | postgresql-ca82ad08fe1640509b1cc47b7bff3ef4ddc627fe.tar.gz postgresql-ca82ad08fe1640509b1cc47b7bff3ef4ddc627fe.zip | |
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
| -rw-r--r-- | doc/src/sgml/ref/create_index.sgml | 12 |
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 013847d2696..4b080c11546 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> |