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 |
---|---|
IF EXISTS |
Drop the function if it exists. Does not error if the function does not exist. |
function_name() |
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