Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oFIGz-00064H-LY for pgsql-docs@arkaria.postgresql.org; Sat, 23 Jul 2022 16:46:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oFIGy-0005IM-HD for pgsql-docs@arkaria.postgresql.org; Sat, 23 Jul 2022 16:46:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oFIGy-0005IC-9O for pgsql-docs@lists.postgresql.org; Sat, 23 Jul 2022 16:46:36 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oFIGv-00061g-MK for pgsql-docs@lists.postgresql.org; Sat, 23 Jul 2022 16:46:35 +0000 Received: from bruce by momjian.us with local (Exim 4.94.2) (envelope-from ) id 1oFIGt-00CYlL-Bz; Sat, 23 Jul 2022 12:46:31 -0400 Date: Sat, 23 Jul 2022 12:46:31 -0400 From: Bruce Momjian To: robertcorrington@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: CREATE INDEX USING documentation Message-ID: References: <164228771825.31954.2719791849363756957@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="Uz3m68czQOZYIYkS" Content-Disposition: inline In-Reply-To: <164228771825.31954.2719791849363756957@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Uz3m68czQOZYIYkS Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, Jan 15, 2022 at 11:01:58PM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/sql-createindex.html > Description: > > In the CREATE INDEX > synopsis(https://www.postgresql.org/docs/current/sql-createindex.html), the > USING method parameter is listed, however in the PARAMETERS section USING is > never fully described, nor is there a link to the very help 11.2 Index Types > page (https://www.postgresql.org/docs/14/indexes-types.html). Well, that is certainly odd. The attached patch adds a description of the option, and a link to the chapter you suggested. > On a related note, the CREATE INDEX page provides the following blurb: > > "Prior releases of PostgreSQL also had an R-tree index method. This method > has been removed because it had no significant advantages over the GiST > method. If USING rtree is specified, CREATE INDEX will interpret it as USING > gist, to simplify conversion of old databases to GiST." > > But there is no such blurb on the 11.2 Index Types page. We think of backward compatibility stuff as operational, meaning it appears in the command manual page but not necessarily in the main docs. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson --Uz3m68czQOZYIYkS Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="using.diff" diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index a5bac9f737..944fdb4b09 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 ] + + USING + + + The optional USING clause specifies an index + type as described in . If not + specified, a default index type will be used based on the + data types of the columns. + + + + INCLUDE --Uz3m68czQOZYIYkS--