aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2002-07-30 19:36:13 +0000
committerBruce Momjian <bruce@momjian.us>2002-07-30 19:36:13 +0000
commitf514bb3e2586d3896f4584b9b345f9565bef1f8a (patch)
treeb1527b692ab9f7985d29ab8f135f6a461b4d6683 /doc/src
parent6c01708c46ae3f55f8d844b455a60ed8bcea77cf (diff)
downloadpostgresql-f514bb3e2586d3896f4584b9b345f9565bef1f8a.tar.gz
postgresql-f514bb3e2586d3896f4584b9b345f9565bef1f8a.zip
Would it be wise to have the plsql.sgml file renamed to plpgsql.sgml?
All of the internal tags are of the latter. The other thing I noticed is that most of the quick examples in the file use a para and synopsis. Is there a reason we're not using <example/> ? Rod Taylor
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/filelist.sgml4
-rw-r--r--doc/src/sgml/plpgsql.sgml (renamed from doc/src/sgml/plsql.sgml)15
2 files changed, 14 insertions, 5 deletions
diff --git a/doc/src/sgml/filelist.sgml b/doc/src/sgml/filelist.sgml
index d8c5998fb84..d6fdd71561b 100644
--- a/doc/src/sgml/filelist.sgml
+++ b/doc/src/sgml/filelist.sgml
@@ -1,4 +1,4 @@
-<!-- $Header: /cvsroot/pgsql/doc/src/sgml/filelist.sgml,v 1.19 2002/06/15 02:59:55 thomas Exp $ -->
+<!-- $Header: /cvsroot/pgsql/doc/src/sgml/filelist.sgml,v 1.20 2002/07/30 19:36:10 momjian Exp $ -->
<!entity history SYSTEM "history.sgml">
<!entity info SYSTEM "info.sgml">
@@ -83,7 +83,7 @@
<!entity xtypes SYSTEM "xtypes.sgml">
<!entity plperl SYSTEM "plperl.sgml">
<!entity plpython SYSTEM "plpython.sgml">
-<!entity plsql SYSTEM "plsql.sgml">
+<!entity plsql SYSTEM "plpgsql.sgml">
<!entity pltcl SYSTEM "pltcl.sgml">
<!-- developer's guide -->
diff --git a/doc/src/sgml/plsql.sgml b/doc/src/sgml/plpgsql.sgml
index 082b77fc5b2..9a58e6b8e3b 100644
--- a/doc/src/sgml/plsql.sgml
+++ b/doc/src/sgml/plpgsql.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/Attic/plsql.sgml,v 2.60 2002/06/24 23:12:06 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/plpgsql.sgml,v 1.1 2002/07/30 19:36:10 momjian Exp $
-->
<chapter id="plpgsql">
@@ -978,13 +978,15 @@ EXECUTE <replaceable class="command">query-string</replaceable>;
<para>
An example:
-<synopsis>
+<informalexample>
+<programlisting>
EXECUTE ''UPDATE tbl SET ''
|| quote_ident(fieldname)
|| '' = ''
|| quote_literal(newvalue)
|| '' WHERE ...'';
-</synopsis>
+</programlisting>
+</informalexample>
</para>
<para>
@@ -1059,6 +1061,13 @@ GET DIAGNOSTICS <replaceable>variable</replaceable> = <replaceable>item</replace
<acronym>SQL</acronym> query. Note that <varname>RESULT_OID</>
is only useful after an INSERT query.
</para>
+ <para>
+<informalexample>
+<programlisting>
+ GET DIAGNOSTICS var_integer = ROW_COUNT;
+</programlisting>
+</informalexample>
+ </para>
</sect2>
</sect1>