Commit073adc5

committed

Added:

Note: currently, only btree access method supports multi- attribute indices. Up to 7 keys may be specified.

1 parent4516553 commit073adc5Copy full SHA for 073adc5

File tree

-2

lines changed

-2

lines changed

Lines changed: 7 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,14 +1,14 @@`
`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`	`\fBcreate\fR [\fBunique\fR]\fBindex\fR index-name`
`10`	`10`	`\fBon\fR classname [\fBusing\fR am-name]`
`11`		`-\fB(\fR attname, ... [type_class\fB])\fR`
	`11`	`+\fB(\fR attname [type_class], ...\fB)\fR`
`12`	`12`
`13`	`13`	`\fBcreate\fR [\fBunique\fR]\fBindex\fR index-name`
`14`	`14`	`\fBon\fR classname [\fBusing\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`	`+\fBNote:\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`

Comments

(0)