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

DROP OPERATOR

DROP OPERATOR drops the definition of an operator.

Syntax

DROP OPERATOR [ IF EXISTS ]  name ( { left_type | NONE } , { right_type | NONE } );

Description

  • 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.

Examples

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

DROP OPERATOR @@ (text, text);