DROP FUNCTION

Name

DROP FUNCTION  --  Removes a user-defined C function.

Synopsis

DROP FUNCTION name ( [ type [, ...] ] )
  

Parameters

name

Use this parameter to provide the name of an existing function you wish to drop.

type

Use this parameter to specify the type of data the target function accepts as arguments.

Results

DROP

This message displayed if the function is successfully dropped.

NOTICE RemoveFunction: Function "name" ("types") does not exist

This message is displayed if the specified function cannot be found in the current database.

Description

Use this command to remove C function references that are defined in a database. Specifying the parameter types 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.

NoteWarning
 

This command 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.

Examples

The following example removes the square root function.

  DROP FUNCTION sqrt(int4);