ALTER OPERATOR
Description
Alters the definition of an operator.
Precautions
ALTER OPERATOR changes the definition of an operator. Currently, the only function available is to change the owner of the operator.
To use ALTER OPERATOR, you must be the owner of the operator. To modify the owner, you must also be a direct or indirect member of the new owning role, and that member must have CREATE permission on the operator's schema. (These restrict that the owner cannot be changed by doing anything other than deleting or rebuilding the operator. However, a user with the SYSADMIN permission can change the ownership of any operator in any way.)
Syntax
ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } ) OWNER TO new_owner ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } ) SET SCHEMA new_schema
Parameters
- name
Name of an existing operator.
- left_type
Data type of the left operand for the operator; if there is no left operand, write NONE.
- right_type
Data type of the right operand for the operator; if there is no right operand, write NONE.
- new_owner
New owner of the operator.
- new_schema
New schema name of the operator.
Examples
Alter a user-defined operator for text a @@ b:
ALTER OPERATOR @@ (text, text) OWNER TO joe;
Compatibility
The SQL standard does not contain the ALTER OPERATOR statement.
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot