Name
DROP FUNCTION -- Removes a user-defined function.
Synopsis
DROP FUNCTION name ( [ type [, ...] ] )
Parameters
- name
The name of the existing function you wish to drop.
- type
Zero or more data types consisting of the function's arguments. The types combine with the name to uniquely identify the function.
Results
- DROP
The message returned when a function is successfully dropped.
- ERROR: RemoveFunction: Function 'name(types)' does not exist
The error returned if the function name for the specified types does not exist in the current database.
Description
Use this command to remove C function references that are defined in a database. Specifying the parameter types that the function takes allows proper identification; this is necessary when dealing with the C language, as functions exist with the same name that only differ in the types of arguments they take.
| Warning |
DROP FUNCTION does not check if any database elements rely on the function, or if removing it would cause any negative effects. You must check these things on your own. |
Example
The following example removes the title(integer) function from the booktown database:
booktown=# DROP FUNCTION title(integer);
DROP