---
name: "drop_operator"
section: "7l"
platform: "linux"
package: "postgresql-client"
version: "7.2.1-2woody8"
release: "Debian 3.0 (Woody)"
platforms: ["linux"]
url: "https://new.carta.tech/drop_operator/7l"
---

# drop\_operator(7l)

remove a user-defined operator

## NAME

DROP OPERATOR - remove a user-defined operator

## SYNOPSIS

```
DROP OPERATOR id ( lefttype | NONE , righttype | NONE )

```

### INPUTS

- *id*

  The identifier of an existing operator.

- *lefttype*

  The type of the operator's left argument; write NONE if the operator has no left argument.

- *righttype*

  The type of the operator's right argument; write NONE if the operator has no right argument.

### OUTPUTS

- **DROP**

  The message returned if the command is successful.

- **ERROR: RemoveOperator: binary operator '***oper***' taking '***lefttype***' and '***righttype***' does not exist**

  This message occurs if the specified binary operator does not exist.

- **ERROR: RemoveOperator: left unary operator '***oper***' taking '***lefttype***' does not exist**

  This message occurs if the left unary operator specified does not exist.

- **ERROR: RemoveOperator: right unary operator '***oper***' taking '***righttype***' does not exist**

  This message occurs if the right unary operator specified does not exist.

## DESCRIPTION

**DROP OPERATOR** drops an existing operator from the database. To execute this command you must be the owner of the operator.

The left or right type of a left or right unary operator, respectively, must be specified as NONE.

### NOTES

The **DROP OPERATOR** statement is a  PostgreSQL language extension.

Refer to CREATE OPERATOR \[**create\_operator**(l)\] for information on how to create operators.

It is the user's responsibility to remove any access methods and operator classes that rely on the deleted operator.

## USAGE

Remove power operator a^n for int4:

```
DROP OPERATOR ^ (int4, int4);

```

Remove left unary negation operator (! b) for **boolean**:

```
DROP OPERATOR ! (none, bool);

```

Remove right unary factorial operator (i !) for int4:

```
DROP OPERATOR ! (int4, none);

```

## COMPATIBILITY

### SQL92

There is no **DROP OPERATOR** in SQL92.