aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorDennis Bjorklund <db@zigo.dhs.org>2004-06-25 07:05:34 +0000
committerDennis Bjorklund <db@zigo.dhs.org>2004-06-25 07:05:34 +0000
commitd0f1b4c4fb62ec1eb99debbe1fa4f8685e769313 (patch)
tree29780436148db1914aebe768cf4db7a5f59cb1e2 /doc/src
parentc95246bd6305ffb74d1d7d8b3f7db42cc9a6de77 (diff)
downloadpostgresql-d0f1b4c4fb62ec1eb99debbe1fa4f8685e769313.tar.gz
postgresql-d0f1b4c4fb62ec1eb99debbe1fa4f8685e769313.zip
Add argument name to syntax.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/create_function.sgml18
1 files changed, 15 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml
index 4929524cff4..f88bc0af956 100644
--- a/doc/src/sgml/ref/create_function.sgml
+++ b/doc/src/sgml/ref/create_function.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.56 2004/05/16 23:22:07 neilc Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.57 2004/06/25 07:05:34 dennis Exp $
-->
<refentry id="SQL-CREATEFUNCTION">
@@ -19,12 +19,12 @@ $PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.56 2004/05/16 23:22
<refsynopsisdiv>
<synopsis>
-CREATE [ OR REPLACE ] FUNCTION <replaceable class="parameter">name</replaceable> ( [ <replaceable class="parameter">argtype</replaceable> [, ...] ] )
+CREATE [ OR REPLACE ] FUNCTION <replaceable class="parameter">name</replaceable> ( [ [ <replaceable class="parameter">argname</replaceable> ] <replaceable class="parameter">argtype</replaceable> [, ...] ] )
RETURNS <replaceable class="parameter">rettype</replaceable>
{ LANGUAGE <replaceable class="parameter">langname</replaceable>
| IMMUTABLE | STABLE | VOLATILE
| CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
- | [EXTERNAL] SECURITY INVOKER | [EXTERNAL] SECURITY DEFINER
+ | [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
| AS '<replaceable class="parameter">definition</replaceable>'
| AS '<replaceable class="parameter">obj_file</replaceable>', '<replaceable class="parameter">link_symbol</replaceable>'
} ...
@@ -89,6 +89,18 @@ CREATE [ OR REPLACE ] FUNCTION <replaceable class="parameter">name</replaceable>
</varlistentry>
<varlistentry>
+ <term><replaceable class="parameter">argname</replaceable></term>
+
+ <listitem>
+ <para>
+ The name of an argument. Some languages (currently only PL/pgSQL) let
+ you use the name in the function body. For other languages the
+ argument name is just extra documentation.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
<term><replaceable class="parameter">argtype</replaceable></term>
<listitem>