From 6eb9c5a5657d1fe77b55cc261450f3538d35a94d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:19:15 +0200 Subject: Adding upstream version 13.4. Signed-off-by: Daniel Baumann --- doc/src/sgml/ref/alter_operator.sgml | 161 +++++++++++++++++++++++++++++++++++ 1 file changed, 161 insertions(+) create mode 100644 doc/src/sgml/ref/alter_operator.sgml (limited to 'doc/src/sgml/ref/alter_operator.sgml') diff --git a/doc/src/sgml/ref/alter_operator.sgml b/doc/src/sgml/ref/alter_operator.sgml new file mode 100644 index 0000000..b3bfa9c --- /dev/null +++ b/doc/src/sgml/ref/alter_operator.sgml @@ -0,0 +1,161 @@ + + + + + ALTER OPERATOR + + + + ALTER OPERATOR + 7 + SQL - Language Statements + + + + ALTER OPERATOR + change the definition of an operator + + + + +ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } ) + OWNER TO { new_owner | CURRENT_USER | SESSION_USER } + +ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } ) + SET SCHEMA new_schema + +ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } ) + SET ( { RESTRICT = { res_proc | NONE } + | JOIN = { join_proc | NONE } + } [, ... ] ) + + + + + Description + + + ALTER OPERATOR changes the definition of + an operator. + + + + You must own the operator to use ALTER OPERATOR. + To alter the owner, you must also be a direct or indirect member of the new + owning role, and that role must have CREATE privilege on + the operator's schema. (These restrictions enforce that altering the owner + doesn't do anything you couldn't do by dropping and recreating the operator. + However, a superuser can alter ownership of any operator anyway.) + + + + + Parameters + + + + name + + + The name (optionally schema-qualified) of an existing operator. + + + + + + left_type + + + The data type of the operator's left operand; write + NONE if the operator has no left operand. + + + + + + right_type + + + The data type of the operator's right operand; write + NONE if the operator has no right operand. + + + + + + new_owner + + + The new owner of the operator. + + + + + + new_schema + + + The new schema for the operator. + + + + + + res_proc + + + The restriction selectivity estimator function for this operator; write NONE to remove existing selectivity estimator. + + + + + + join_proc + + + The join selectivity estimator function for this operator; write NONE to remove existing selectivity estimator. + + + + + + + + + Examples + + + Change the owner of a custom operator a @@ b for type text: + +ALTER OPERATOR @@ (text, text) OWNER TO joe; + + + + Change the restriction and join selectivity estimator functions of a custom operator a && b for type int[]: + +ALTER OPERATOR && (_int4, _int4) SET (RESTRICT = _int_contsel, JOIN = _int_contjoinsel); + + + + + + Compatibility + + + There is no ALTER OPERATOR statement in + the SQL standard. + + + + + See Also + + + + + + + -- cgit v1.2.3