Postgres Pro
Downloads
Home   >   mailing lists

Re: Mistakes between an example and its description - Mailing list pgsql-docs

From Eugene Wang
Subject Re: Mistakes between an example and its description
Date
Msg-id CAEsxC1ZCXXiTCamoZmiA4qC6O6HYcdK73a+29Om9RoucBh_LwQ@mail.gmail.com
Whole thread Raw
In response to Re: Mistakes between an example and its description  (Martín Marqués <martin.marques@2ndquadrant.com>)
Responses Re: Mistakes between an example and its description  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: Mistakes between an example and its description  (Martín Marqués <martin@2ndquadrant.com>)
List pgsql-docs
Tree view
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. 

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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: updatable cursors and ORDER BY
Next
From: Alvaro Herrera
Date:
Subject: Re: Mistakes between an example and its description