File tree Expand file tree Collapse file tree 1 file changed +7
-2
lines changed Expand file tree Collapse file tree 1 file changed +7
-2
lines changed Original file line number Diff line number Diff line change 1
1
.\" This is -*-nroff-*-
2
2
.\" 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 $
4
4
.TH "CREATE INDEX" SQL 11/05/95 PostgreSQL PostgreSQL
5
5
.SH NAME
6
6
create index \(em construct a secondary index
7
7
.SH SYNOPSIS
8
8
.nf
9
9
\fB create \fR [\fB unique \fR ] \fB index \fR index-name
10
10
\fB on \fR classname [\fB using \fR am-name]
11
- \fB ( \fR attname, ... [type_class \fB ] ) \fR
11
+ \fB ( \fR attname [type_class] , ...\fB ) \fR
12
12
13
13
\fB create \fR [\fB unique \fR ] \fB index \fR index-name
14
14
\fB on \fR classname [\fB using \fR am-name]
@@ -34,6 +34,11 @@ integers.
34
34
The default operator class is the appropriate operator class for
35
35
that field type.
36
36
.PP
37
+ \fB Note: \fR currently, only
38
+ .IR btree
39
+ access method supports multi-attribute indices.
40
+ Up to 7 keys may be specified.
41
+ .PP
37
42
In the second syntax shown above, an index can be defined on the
38
43
result of a user-defined function
39
44
.IR funcname
You can’t perform that action at this time.
0 commit comments