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 [, ...] ] )
Inputs
- name
-
The name of an existing function.
- type
-
The type of the function's parameters.
Outputs
- DROP
-
Message returned if the command completes
successfully.
- NOTICE 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.
Notes
Refer to CREATE FUNCTION
for information on creating functions.
No checks are made to ensure that types, operators, access
methods, or triggers that rely on the function have been removed
first.
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:
DROP FUNCTION name (arg, ...) { RESTRICT | CASCADE }
where CASCADE specifies dropping all
objects that depend on the function and RESTRICT refuses to drop the function if dependent
objects exist.