diff options
| author | Bruce Momjian <bruce@momjian.us> | 1997-10-30 18:41:03 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 1997-10-30 18:41:03 +0000 |
| commit | 65c00f7e802a3357ff1b7619e27fc7d9e1486b71 (patch) | |
| tree | b2f6972e895eb80ed61b5711f9e103a4e8517dc9 /src | |
| parent | ef1fc0c90df1fa09f357eb835df6d2c2d0696555 (diff) | |
| download | postgresql-65c00f7e802a3357ff1b7619e27fc7d9e1486b71.tar.gz postgresql-65c00f7e802a3357ff1b7619e27fc7d9e1486b71.zip | |
We have multi-column indexes, so update manual.
Diffstat (limited to 'src')
| -rw-r--r-- | src/man/create_index.l | 11 |
1 files changed, 2 insertions, 9 deletions
diff --git a/src/man/create_index.l b/src/man/create_index.l index fe10cc5e100..f89c2c73f70 100644 --- a/src/man/create_index.l +++ b/src/man/create_index.l @@ -1,6 +1,6 @@ .\" This is -*-nroff-*- .\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/create_index.l,v 1.6 1997/05/14 01:38:34 vadim Exp $ +.\" $Header: /cvsroot/pgsql/src/man/Attic/create_index.l,v 1.7 1997/10/30 18:41:03 momjian Exp $ .TH "CREATE INDEX" SQL 11/05/95 PostgreSQL PostgreSQL .SH NAME create index \(em construct a secondary index @@ -44,14 +44,7 @@ result of a user-defined function .IR funcname applied to one or more attributes of a single class. These .IR "functional indices" -are primarily useful in two situations. First, functional indices can -be used to simulate multi-key indices. That is, the user can define a -new base type (a simple combination of, say, \*(lqoid\*(rq and -\*(lqint2\*(rq) and the associated functions and operators on this new -type such that the access method can use it. Once this has been done, -the standard techniques for interfacing new types to access methods -(described in the Postgres user manual) can be applied. Second, -functional indices can be used to obtain fast access to data based on +can be used to obtain fast access to data based on operators that would normally require some transformation to be applied to the base data. For example, say you have an attribute in class \*(lqmyclass\*(rq called \*(lqpt\*(rq that consists of a 2D |