Re: Mistakes between an example and its description
| От | Eugene Wang |
|---|---|
| Тема | Re: Mistakes between an example and its description |
| Дата | |
| Msg-id | CAEsxC1ZCXXiTCamoZmiA4qC6O6HYcdK73a+29Om9RoucBh_LwQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Mistakes between an example and its description (Martín Marqués <martin.marques@2ndquadrant.com>) |
| Ответы |
Re: Mistakes between an example and its description
Re: Mistakes between an example and its description |
| Список | pgsql-docs |
Unique Constraint and Unique Index should be the same in this single-column case, right?
Because, according to CONSTRAINT page in Postgres Documentation, Unique Constraint on single column is realized as Unique B-TREE index.
Because, according to CONSTRAINT page in Postgres Documentation, Unique Constraint on single column is realized as Unique B-TREE index.
I have just realized that it is still a btree index, but I think this example is not exactly a regular btree example. At least I will put the example as: CREATE INDEX title_idx ON films USING BTREE(title);
On Wed, May 9, 2018 at 7:59 PM, Martín Marqués <martin.marques@2ndquadrant.com> wrote:
El 09/05/18 a las 18:52, PG Doc comments form escribió:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/sql- createindex.html
> Description:
>
> In Postgres Doc: Index
> page(https://www.postgresql.org/docs/9.6/static/sql- createindex.html), there
> is an mismatch between an example description and an example SQL statement.
>
>
> The description is below :
> To create a B-tree index on the column title in the table films:
>
> Meanwhile, the example provided is an UNIQUE constrain.
> CREATE UNIQUE INDEX title_idx ON films (title);
It's not exactly a unique constraint, but it is a unique index, and it
should be mentioned in the title of the documentation.
--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-docs по дате отправления: