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 | e6f7892914ab70b40a2ffa71887e3bdcfa668988 (patch) | |
| tree | 2dfaf656244eec93d4812f7fe69db2a3ec7fc9fb | |
| parent | ff48a0c80ec8dc47ba59161b43058ddcdfbe5b09 (diff) | |
| download | postgresql-e6f7892914ab70b40a2ffa71887e3bdcfa668988.tar.gz postgresql-e6f7892914ab70b40a2ffa71887e3bdcfa668988.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 f50c88fe0a5..318f7f7d96a 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -149,6 +149,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> |