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.marq...@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 >
