Re: Mistakes between an example and its description

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(dot)marques(at)2ndquadrant(dot)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
>