CREATE INDEX...USING - Mailing list pgsql-docs

From Jeff Janes
Subject CREATE INDEX...USING
Date
Msg-id CAMkU=1zhCpC7hottyMWM5Pimr9vRLprSwzLg+7PgajWhKZqRzw@mail.gmail.com
Whole thread Raw
Responses Re: CREATE INDEX...USING
List pgsql-docs
This was recently added to CREATE INDEX reference page:

+        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.

But I think this is wrong, the default type is BTREE, it does not depend on the data type.  Or at least, I've never witnessed the claimed behavior.  The claim also conflicts with what is said at https://www.postgresql.org/docs/10/indexes-types.html

Cheers,

Jeff

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: nicer examples for aggregate calls
Next
From: Bruce Momjian
Date:
Subject: Re: CREATE INDEX...USING