Practical PostgreSQL by Joshua D. Drake;John C. Worsley

Author:Joshua D. Drake;John C. Worsley
Language: eng
Format: mobi, epub
Tags: COMPUTERS / Database Management / Data Mining
Publisher: O'Reilly Media
Published: 2011-05-23T23:00:00+00:00

Dropping an operator

An operator can be dropped with the DROP OPERATOR command. An operator may only be dropped by the user who created it, or by a PostgreSQL superuser.

* * *

Note

The DROP OPERATOR command applies to built-in operators as well as user-defined operators, so take care with this command if executing it as a superuser!

* * *

As operators are defined by their arguments as well as their name, DROP OPERATOR requires that you specify the left and right argument types of the operator. If there is no type for a given side, specify the NONE keyword.

Here is the syntax for DROP OPERATOR:

DROP OPERATOR name ( { lefttype | NONE }, { righttype | NONE } )

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.