Updated on 2024-05-07 GMT+08:00

ALTER OPERATOR

Description

ALTER OPERATOR modifies the definition of an operator.

Precautions

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 restrictions force the owner to do nothing that cannot be done by deleting and recreating the operator. However, a user with the SYSADMIN permission can modify the ownership of any operator in any way.)

Syntax

  • Change the owner of the operator.
    ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } ) OWNER TO new_owner;
  • Change the schema of the operator.
    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.

Example

Change a user-defined operator for text a @@ b:

gaussdb=# ALTER OPERATOR @@ (text, text) OWNER TO joe;

Compatibility

The SQL standard does not contain the ALTER OPERATOR statement.