Skip to content

Commit 949cfe5

Browse files
committed
Update create_index manual page to have unique section.
1 parent 003bfd9 commit 949cfe5

File tree

1 file changed

+6
-1
lines changed

1 file changed

+6
-1
lines changed

src/man/create_index.l

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
.\" This is -*-nroff-*-
22
.\" XXX standard disclaimer belongs here....
3-
.\" $Header: /cvsroot/pgsql/src/man/Attic/create_index.l,v 1.3 1996/12/11 00:27:14 momjian Exp $
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/create_index.l,v 1.4 1997/01/13 17:22:25 momjian Exp $
44
.TH "CREATE INDEX" SQL 11/05/95 PostgreSQL PostgreSQL
55
.SH NAME
66
create index \(em construct a secondary index
@@ -62,6 +62,11 @@ and then comparing it to the value on the other side of the operator.
6262
Obviously, the decision to build a functional index represents a
6363
tradeoff between space (for the index) and execution time.
6464
.PP
65+
The \fBunique\fR keyword causes the system to check for duplicate
66+
values when the index is created (if data already exist) and each
67+
time data is added.
68+
Attempts to insert or update non-duplicate data will generate an error.
69+
.PP
6570
Postgres provides btree, rtree and hash access methods for
6671
secondary indices. The btree access method is an implementation of
6772
the Lehman-Yao high-concurrency btrees. The rtree access method

0 commit comments

Comments
 (0)