aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2004-10-29 19:40:33 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2004-10-29 19:40:33 +0000
commit7d38e59448c61a09ea9399fa1c2286a5037ea439 (patch)
treeef9531ce9f3c3be6ae748547c353994c5e36cc6c /doc/src
parent4eb1165ff37dd399ab60dc80322fd289b9fe7b85 (diff)
downloadpostgresql-7d38e59448c61a09ea9399fa1c2286a5037ea439.tar.gz
postgresql-7d38e59448c61a09ea9399fa1c2286a5037ea439.zip
Fix broken example for PREPARE.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/prepare.sgml8
1 files changed, 4 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/prepare.sgml b/doc/src/sgml/ref/prepare.sgml
index 4711a3002ea..450a829d52d 100644
--- a/doc/src/sgml/ref/prepare.sgml
+++ b/doc/src/sgml/ref/prepare.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/prepare.sgml,v 1.14 2004/09/30 04:23:27 neilc Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/prepare.sgml,v 1.15 2004/10/29 19:40:33 tgl Exp $
PostgreSQL documentation
-->
@@ -152,9 +152,9 @@ PREPARE <replaceable class="PARAMETER">plan_name</replaceable> [ (<replaceable c
Create a prepared query for an <command>INSERT</command> statement,
and then execute it:
<programlisting>
-PREPARE fooplan (int, text, bool, numeric(8,2)) AS
- INSERT INTO foo VALUES($1, '$2', '$3', '$4');
-EXECUTE fooplan(1, 'Hunter Valley', 't', '200.00');
+PREPARE fooplan (int, text, bool, numeric) AS
+ INSERT INTO foo VALUES($1, $2, $3, $4);
+EXECUTE fooplan(1, 'Hunter Valley', 't', 200.00);
</programlisting>
</para>