top of page

714

CREATE OPERATOR

CREATE [ OR REPLACE ] OPERATOR
[ schema. ] operator binding_clause ;

binding_clause::=
BINDING
(parameter_type [, parameter_type ]...)
RETURN return_type
[ implementation_clause ]
using_function_clause
[, (parameter_type [, parameter_type ]...)
RETURN return_type
[ implementation_clause ]
using_function_clause
]...
implementation_clause::=
{ ANCILLARY TO primary_operator
( parameter_type [, parameter_type ]...)
[, primary_operator
( parameter_type [, parameter_type ]...)
]...
| context_clause
}
context_clause::=
[ WITH INDEX CONTEXT,
SCAN CONTEXT implementation_type
[ COMPUTE ANCILLARY DATA ]
]
[ WITH COLUMN CONTEXT ]
using_function_clause::=
USING [ schema. ] [ package. | type. ] function_name

bottom of page