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

NAME

       CREATE OPERATOR -

SYNOPSIS

       CREATE OPERATOR name (
           PROCEDURE = funcname
           [, LEFTARG = lefttype ] [, RIGHTARG = righttype ]
           [, COMMUTATOR = com_op ] [, NEGATOR = neg_op ]
           [, RESTRICT = res_proc ] [, JOIN = join_proc ]
           [, HASHES ] [, MERGES ]
           [, SORT1 = left_sort_op ] [, SORT2 = right_sort_op ]
           [, LTCMP = less_than_op ] [, GTCMP = greater_than_op ]
       )

DESCRIPTION

       CREATE OPERATOR  name

         name  NAMEDATALEN-1  63

       + - * / < > = ~ ! @ # % ^ & | ` ?

       o --  /*

       o
           +  -

         ~ ! @ # % ^ & | ` ?


           @-   *-   PostgreSQL   SQL-
         !=  <>

        LEFTARGRIGHTARG  LEFTARG RIGHTARG

        funcname  CREATE FUNCTION

         ``User-Defined Operators''

PARAMETERS

       name
                 CREATE OPERATOR myschema.+ (...)

       funcname

       lefttype

       righttype

       com_op
               commutator

       neg_op

       res_proc

       join_proc

       HASHES

       MERGES

       left_sort_op
               join

       right_sort_op
               join

       less_than_op

       greater_than_op

         com_op  OPERATOR()

       COMMUTATOR = OPERATOR(myschema.===) ,

NOTES

         ``User-Defined Operators''

         DROP OPERATOR

EXAMPLES

         box

       CREATE OPERATOR === (
           LEFTARG = box,
           RIGHTARG = box,
           PROCEDURE = area_equal_procedure,
           COMMUTATOR = ===,
           NEGATOR = !==,
           RESTRICT = area_restriction_procedure,
           JOIN = area_join_procedure,
           HASHES,
           SORT1 = <<<,
           SORT2 = <<<
           --  MERGES
           -- LTCMP  GTCMP  <  >
       );

COMPATIBILITY

       CREATE OPERATOR  PostgreSQL  SQL CREATE OPERATOR

       Postgresql  <laser@pgsqldb.org>