DROP FUNCTION - Removes a user-defined C function


SYNOPSIS

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

   INPUTS
       name   The name of an existing function.

       type   The type of function parameters.

   OUTPUTS
       DROP   Message  returned if the command completes success­
              fully.

       NOTICE RemoveFunction: Function "name" ("types") does not
              exist
              This  message  is  given  if the function specified
              does not exist in the current database.


DESCRIPTION

       DROP FUNCTION will remove  references  to  an  existing  C
       function.  To  execute  this  command the user must be the
       owner of the function. The input  argument  types  to  the
       function  must be specified, as only the function with the
       given name and argument types will be removed.

   NOTES
       Refer to CREATE FUNCTION [create_function(l)] for informa­
       tion on creating aggregate functions.

       No  checks  are  made  to  ensure that types, operators or
       access methods that rely on the function have been removed
       first.


USAGE

       This command removes the square root function:

       DROP FUNCTION sqrt(int4);


COMPATIBILITY

   SQL92
       DROP FUNCTION is a Postgres language extension.

   SQL/PSM
       SQL/PSM is a proposed standard to enable function extensi­
       bility.  The SQL/PSM DROP FUNCTION statement has the  fol­
       lowing syntax:



Man(1) output converted with man2html