aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/drop_function.sgml
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src/sgml/ref/drop_function.sgml')
-rw-r--r--doc/src/sgml/ref/drop_function.sgml53
1 files changed, 34 insertions, 19 deletions
diff --git a/doc/src/sgml/ref/drop_function.sgml b/doc/src/sgml/ref/drop_function.sgml
index bf6e778c377..888929e928e 100644
--- a/doc/src/sgml/ref/drop_function.sgml
+++ b/doc/src/sgml/ref/drop_function.sgml
@@ -1,6 +1,11 @@
+<!--
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_function.sgml,v 1.7 1999/07/22 15:09:10 thomas Exp $
+Postgres documentation
+-->
+
<refentry id="SQL-DROPFUNCTION">
<refmeta>
- <refentrytitle>
+ <refentrytitle id="SQL-DROPFUNCTION-TITLE">
DROP FUNCTION
</refentrytitle>
<refmiscinfo>SQL - Language Statements</refmiscinfo>
@@ -15,7 +20,7 @@
</refnamediv>
<refsynopsisdiv>
<refsynopsisdivinfo>
- <date>1998-04-15</date>
+ <date>1999-07-20</date>
</refsynopsisdivinfo>
<synopsis>
DROP FUNCTION <replaceable class="parameter">name</replaceable> ( [ <replaceable class="parameter">type</replaceable> [, ...] ] )
@@ -108,9 +113,16 @@ WARN RemoveFunction: Function "<replaceable class="parameter">name</replaceable>
<title>
Notes
</title>
+
+ <para>
+ Refer to
+ <xref linkend="sql-createfunction-title" endterm="sql-createfunction-title">
+ for information on creating aggregate functions.
+ </para>
+
<para>
- Refer to <command>CREATE FUNCTION</command>
- to create aggregate functions.
+ No checks are made to ensure that types, operators or access
+ methods that rely on the function have been removed first.
</para>
</refsect2>
</refsect1>
@@ -119,6 +131,7 @@ WARN RemoveFunction: Function "<replaceable class="parameter">name</replaceable>
<title>
Usage
</title>
+
<para>
This command removes the square root function:
@@ -128,26 +141,27 @@ DROP FUNCTION sqrt(int4);
</para>
</refsect1>
- <refsect1 id="R1-SQL-DROPFUNCTION-3">
- <title>
- Bugs
- </title>
- <para>
- No checks are made to ensure that types, operators or access
- methods that rely on the function have been removed first.
- </para>
- </refsect1>
-
<refsect1 id="R1-SQL-DROPFUNCTION-4">
<title>
Compatibility
</title>
- <para>
- DROP FUNCTION is a <productname>Postgres</productname> language extension.
- </para>
<refsect2 id="R2-SQL-DROPFUNCTION-4">
<refsect2info>
+ <date>1999-07-20</date>
+ </refsect2info>
+ <title>
+ SQL92
+ </title>
+
+ <para>
+ <command>DROP FUNCTION</command>
+ is a <productname>Postgres</productname> language extension.
+ </para>
+ </refsect2>
+
+ <refsect2 id="R2-SQL-DROPFUNCTION-5">
+ <refsect2info>
<date>1998-04-15</date>
</refsect2info>
<title>
@@ -156,9 +170,10 @@ DROP FUNCTION sqrt(int4);
<para>
SQL/PSM is a proposed standard to enable function extensibility.
The SQL/PSM DROP FUNCTION statement has the following syntax:
- <programlisting>
+
+ <synopsis>
DROP [ SPECIFIC ] FUNCTION <replaceable class="parameter">name</replaceable> { RESTRICT | CASCADE }
- </programlisting>
+ </synopsis>
</para>
</refsect2>
</refsect1>