postgres.git / summary / log / commit / refs

commit    ca82ad08fe1640509b1cc47b7bff3ef4ddc627fe
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Fri Aug 12 15:26:03 2022 +0000
First released in: 16.0, 10.23, 11.18, 12.13, 13.9, 14.6, 15.0

    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


 doc/src/sgml/ref/create_index.sgml | 12 ++++++++++++
 1 file changed, 12 insertions(+)

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
@@ -149,6 +149,18 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
       </listitem>
      </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>


[parent: 4e32fb1631dc]