DROP FUNCTION

Practical PostgreSQL
Prev		Next

DROP FUNCTION

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

Prev	Home	Next
DROP DATABASE	Up	DROP GROUP