| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | pgsql-docs <pgsql-docs(at)postgresql(dot)org>, Bruce Momjian <bruce(at)momjian(dot)us> |
| Subject: | CREATE INDEX...USING |
| Date: | 2022-08-17 16:41:03 |
| Message-ID: | CAMkU=1zhCpC7hottyMWM5Pimr9vRLprSwzLg+7PgajWhKZqRzw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2022-08-17 18:58:24 | Re: CREATE INDEX...USING |
| Previous Message | Bruce Momjian | 2022-08-17 16:20:10 | Re: nicer examples for aggregate calls |