On Thu, May 10, 2018 at 12:16 PM, Martín Marqués
wrote:
> 2018-05-10 16:04 GMT-03:00 Eugene Wang :
> > Unique Constraint and Unique Index should be the same in this
> single-column
> > case, right?
>
> The unique index is what enforces the uniqueness of the field with a
> UNIQUE constraint, but a
2018-05-10 16:04 GMT-03:00 Eugene Wang :
> Unique Constraint and Unique Index should be the same in this single-column
> case, right?
The unique index is what enforces the uniqueness of the field with a
UNIQUE constraint, but a unique index is not necessarily a constraint.
For example, you can us
Eugene Wang wrote:
> 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
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
ex
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-c
