t
 Title: DROP ROUTINE
 Author: The PostgreSQL Global Development Group
 Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
 Date: 2021
 Manual: PostgreSQL 12.9 Documentation
 Source: PostgreSQL 12.9
 Language: English

 "DROP ROUTINE" "7" "2021" "PostgreSQL 12.9" "PostgreSQL 12.9 Documentation"
 -----------------------------------------------------------------
 * Define some portability stuff
 -----------------------------------------------------------------
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 http://bugs.debian.org/507673
 http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 -----------------------------------------------------------------
 * set default formatting
 -----------------------------------------------------------------
 disable hyphenation
 disable justification (adjust text to left margin only)
 -----------------------------------------------------------------
 * MAIN CONTENT STARTS HERE *
 -----------------------------------------------------------------
 "NAME"
DROP_ROUTINE - remove a routine

 "SYNOPSIS"
DROP ROUTINE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...]
 [ CASCADE | RESTRICT ]



 "DESCRIPTION"

DROP ROUTINE
removes the definition of an existing routine, which can be an aggregate function, a normal function, or a procedure. See under
DROP AGGREGATE (DROP_AGGREGATE(7)),
DROP FUNCTION (DROP_FUNCTION(7)), and
DROP PROCEDURE (DROP_PROCEDURE(7))
for the description of the parameters, more examples, and further details.

 "EXAMPLES"

To drop the routine
foo
for type
integer:


.\}

DROP ROUTINE foo(integer);




.\}
This command will work independent of whether
foo
is an aggregate, function, or procedure.

 "COMPATIBILITY"

This command conforms to the SQL standard, with these
PostgreSQL
extensions:


\h'-04'\(bu\h'+03'\c
.\}

 \(bu 2.3
.\}
The standard only allows one routine to be dropped per command.




\h'-04'\(bu\h'+03'\c
.\}

 \(bu 2.3
.\}
The
IF EXISTS
option




\h'-04'\(bu\h'+03'\c
.\}

 \(bu 2.3
.\}
The ability to specify argument modes and names




\h'-04'\(bu\h'+03'\c
.\}

 \(bu 2.3
.\}
Aggregate functions are an extension.



 "SEE ALSO"
DROP AGGREGATE (DROP_AGGREGATE(7)), DROP FUNCTION (DROP_FUNCTION(7)), DROP PROCEDURE (DROP_PROCEDURE(7)), ALTER ROUTINE (ALTER_ROUTINE(7))


Note that there is no
CREATE ROUTINE
command.