This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
DROP
FUNCTION
Name
DROP FUNCTION -- remove a user-defined
function
Synopsis
DROP FUNCTION name ( [ type [, ...] ] ) [ CASCADE | RESTRICT ]
Inputs
- name
-
The name (optionally schema-qualified) of an existing
function.
- type
-
The type of a parameter of the function.
- CASCADE
-
Automatically drop objects that depend on the function
(such as operators or triggers).
- RESTRICT
-
Refuse to drop the function if there are any dependent
objects. This is the default.
Outputs
- DROP FUNCTION
-
Message returned if the command completes
successfully.
- WARNING: RemoveFunction:
Function "name"
("types") does not
exist
-
This message is given if the function specified does
not exist in the current database.
Description
DROP FUNCTION will remove the definition of an existing
function. To execute this command the user must be the owner of
the function. The input argument types to the function must be
specified, since several different functions may exist with the
same name and different argument lists.
Examples
This command removes the square root function:
DROP FUNCTION sqrt(integer);
Compatibility
A DROP FUNCTION statement is defined
in SQL99. One of its syntax forms is similar to PostgreSQL's.