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>