Provided by: manpages-zh_1.5.2-1_all bug

NAME

       CREATE INDEX -

SYNOPSIS

       CREATE [ UNIQUE ] INDEX name ON table [ USING method ]
           ( { column | ( expression ) } [ opclass ] [, ...] )
           [ WHERE predicate ]

DESCRIPTION

       CREATE INDEX  index_name

           upper(col)  WHERE upper(col) = 'JIM'

       PostgreSQL    B-treeR-treehash   GiST   B-tree  Lehman-Yao  B-trees  R-
       tree  Guttman  R-trees hash Litwin

         WHERE       WHERE  UNIQUE

         WHERE  WHERE

        immutable  immutable

PARAMETERS

       UNIQUE

       name

       table

       method
                btree hashrtree gist btree

       column
               /

       expression

       opclass

       predicate

NOTES

         ``Indexes''

         B-tree  gist   32  PostgreSQL   B-tree

        /  /   B-tree   int4_ops         ``Operator  Classes''   ``Interfacing
       Extensions to Indexes''

         DROP INDEX [drop_index(7)]

EXAMPLES

        films title B-tree

       CREATE UNIQUE INDEX title_idx ON films (title);

COMPATIBILITY

       CREATE INDEX  PostgreSQL   SQL  CREATE INDEX

       Postgresql  <laser@pgsqldb.org>