DROP FUNCTION
Synopsis
Use the DROP FUNCTION statement to remove a function from a database.
Syntax
drop_function ::= DROP { FUNCTION | PROCEDURE } [ IF EXISTS ]
{ name [ ( [ argtype_decl [ , ... ] ] ) ] }
[ , ... ] [ CASCADE | RESTRICT ]
argtype_decl ::= [ argmode ] [ argname ] argtype
drop_function
argtype_decl
Semantics
-
An error will be thrown if the function does not exist unless
IF EXISTSis used. Then a notice is issued instead. -
RESTRICTis the default and it will not drop the function if any objects depend on it. -
CASCADEwill drop any objects that transitively depend on the function.
Examples
DROP FUNCTION IF EXISTS inc(i integer), mul(integer, integer) CASCADE;