summaryrefslogtreecommitdiff
path: root/doc
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2008-09-06 20:18:08 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2008-09-06 20:18:08 +0000
commit409c144d8343f7f2284ff90979edfec3c487e9ee (patch)
tree015031d47fb926eb2f4a9a7998cf005a564a33d1 /doc
parent2c863ca818ba0a9704dbfe24eb578870b54bfee8 (diff)
downloadpostgresql-409c144d8343f7f2284ff90979edfec3c487e9ee.tar.gz
Adjust psql's new \ef command to present an empty CREATE FUNCTION template
for editing if no function name is specified. This seems a much cleaner way to offer that functionality than the original patch had. In passing, de-clutter the error displays that are given for a bogus function-name argument, and standardize on "$function$" as the default delimiter for the function body. (The original coding would use the shortest possible dollar-quote delimiter, which seems to create unnecessarily high risk of later conflicts with the user-modified function body.)
Diffstat (limited to 'doc')
-rw-r--r--doc/src/sgml/ref/psql-ref.sgml11
1 files changed, 8 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml
index 2eedbb54b4..464cf8ec7f 100644
--- a/doc/src/sgml/ref/psql-ref.sgml
+++ b/doc/src/sgml/ref/psql-ref.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.210 2008/09/06 00:01:21 tgl Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.211 2008/09/06 20:18:08 tgl Exp $
PostgreSQL documentation
-->
@@ -1161,7 +1161,7 @@ testdb=&gt;
<varlistentry>
- <term><literal>\edit</literal> (or <literal>\e</literal>) <literal>[ <replaceable class="parameter">filename</replaceable> ]</literal></term>
+ <term><literal>\edit</literal> (or <literal>\e</literal>) <literal><optional> <replaceable class="parameter">filename</replaceable> </optional></literal></term>
<listitem>
<para>
@@ -1196,7 +1196,7 @@ testdb=&gt;
<varlistentry>
- <term><literal>\ef <replaceable class="parameter">function_description</replaceable> </literal></term>
+ <term><literal>\ef <optional> <replaceable class="parameter">function_description</replaceable> </optional></literal></term>
<listitem>
<para>
@@ -1214,6 +1214,11 @@ testdb=&gt;
The argument types must be given if there is more
than one function of the same name.
</para>
+
+ <para>
+ If no function is specified, a blank <command>CREATE FUNCTION</>
+ template is presented for editing.
+ </para>
</listitem>
</varlistentry>