Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       CREATE OPERATOR CLASS -

SYNOPSIS

       CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type USING index_method AS
         {  OPERATOR strategy_number operator_name [ ( op_type, op_type ) ] [ RECHECK ]
          | FUNCTION support_number funcname ( argument_type [, ...] )
          | STORAGE storage_type
         } [, ... ]

DESCRIPTION

       CREATE OPERATOR CLASS   ""

          CURRENT_SCHEMA()

       CREATE OPERATOR CLASS

         ``Interfacing Extensions to Indexes''

PARAMETERS

       name

       DEFAULT

       data_type

       index_method

       strategy_number

       operator_name

       op_type
                NONE

       RECHECK
               "lossy"

       support_number

       funcname

       argument_types

       storage_type
                 GIST  STORAGE

       OPERATORFUNCTION STORAGE

EXAMPLES

         _int4int4  GiST   contrib/intarray/

       CREATE OPERATOR CLASS gist__int_ops
           DEFAULT FOR TYPE _int4 USING gist AS
               OPERATOR        3       &&,
               OPERATOR        6       =       RECHECK,
               OPERATOR        7       @,
               OPERATOR        8       ~,
               OPERATOR        20      @@ (_int4, query_int),
               FUNCTION        1       g_int_consistent (internal, _int4, int4),
               FUNCTION        2       g_int_union (bytea, internal),
               FUNCTION        3       g_int_compress (internal),
               FUNCTION        4       g_int_decompress (internal),
               FUNCTION        5       g_int_penalty (internal, internal, internal),
               FUNCTION        6       g_int_picksplit (internal, internal),
               FUNCTION        7       g_int_same (_int4, _int4, internal);

COMPATIBILITY

       CREATE OPERATOR CLASS  PostgreSQL   SQL  CREATE OPERATOR CLASS

SEE ALSO

       ALTER  OPERATOR  CLASS  [alter_operator_class(7)],  DROP OPERATOR CLASS
       [drop_operator_class(l)]

       Postgresql  <laser@pgsqldb.org>