Skip to content

Commit 073adc5

Browse files
committed
Added:
Note: currently, only btree access method supports multi- attribute indices. Up to 7 keys may be specified.
1 parent 4516553 commit 073adc5

File tree

1 file changed

+7
-2
lines changed

1 file changed

+7
-2
lines changed

src/man/create_index.l

Lines changed: 7 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,14 +1,14 @@
11
.\" This is -*-nroff-*-
22
.\" XXX standard disclaimer belongs here....
3-
.\" $Header: /cvsroot/pgsql/src/man/Attic/create_index.l,v 1.5 1997/05/13 04:41:51 momjian Exp $
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/create_index.l,v 1.6 1997/05/14 01:38:34 vadim Exp $
44
.TH "CREATE INDEX" SQL 11/05/95 PostgreSQL PostgreSQL
55
.SH NAME
66
create index \(em construct a secondary index
77
.SH SYNOPSIS
88
.nf
99
\fBcreate\fR [\fBunique\fR] \fBindex\fR index-name
1010
\fBon\fR classname [\fBusing\fR am-name]
11-
\fB(\fR attname, ... [type_class\fB] )\fR
11+
\fB(\fR attname [type_class], ...\fB )\fR
1212

1313
\fBcreate\fR [\fBunique\fR] \fBindex\fR index-name
1414
\fBon\fR classname [\fBusing\fR am-name]
@@ -34,6 +34,11 @@ integers.
3434
The default operator class is the appropriate operator class for
3535
that field type.
3636
.PP
37+
\fBNote:\fR currently, only
38+
.IR btree
39+
access method supports multi-attribute indices.
40+
Up to 7 keys may be specified.
41+
.PP
3742
In the second syntax shown above, an index can be defined on the
3843
result of a user-defined function
3944
.IR funcname

0 commit comments

Comments
 (0)