DROP_FUNCTION(l)                                 DROP_FUNCTION(l)

NAME
       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.

       WARN 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(l) for  information  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:

       DROP [ SPECIFIC ] FUNCTION name { RESTRICT | CASCADE }

SQL - Language Statements 15 August 1999                        1