DROP FUNCTION¶
DROP FUNCTION
can be used to remove a user defined function.
Permissions¶
The role must have the DDL
permission at the database level.
Syntax¶
drop_function_statement ::=
DROP FUNCTION [ IF EXISTS ] function_name();
;
function_name ::= identifier
Parameters¶
Parameter |
Description |
---|---|
|
Drop the function if it exists. Does not error if the function does not exist. |
|
The name of the function to drop. |
Examples¶
Dropping a function¶
DROP FUNCTION my_distance();
Dropping a function (always succeeds)¶
farm=> DROP FUNCTION my_distance();
executed
farm=> DROP FUNCTION my_distance();
Function 'my_distance' not found
-- This will succeed, even though the function does not exist
farm=> DROP FUNCTION IF EXISTS my_distance();
executed