CREATE OPERATOR(7) SQL Commands CREATE OPERATOR(7) 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 man man https://github.com/man-pages-zh/manpages- zh SQL - Language Statements 2003-11-02 CREATE OPERATOR(7)