Practical PostgreSQL

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.

Note

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