|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/prepare.sgml,v 1.14 2004/09/30 04:23:27 neilc Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/prepare.sgml,v 1.15 2004/10/29 19:40:33 tgl Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -152,9 +152,9 @@ PREPARE <replaceable class="PARAMETER">plan_name</replaceable> [ (<replaceable c |
152 | 152 | Create a prepared query for an <command>INSERT</command> statement, |
153 | 153 | and then execute it: |
154 | 154 | <programlisting> |
155 | | -PREPARE fooplan (int, text, bool, numeric(8,2)) AS |
156 | | - INSERT INTO foo VALUES($1,'$2', '$3', '$4'); |
157 | | -EXECUTE fooplan(1, 'Hunter Valley', 't','200.00'); |
| 155 | +PREPARE fooplan (int, text, bool, numeric) AS |
| 156 | + INSERT INTO foo VALUES($1,$2, $3, $4); |
| 157 | +EXECUTE fooplan(1, 'Hunter Valley', 't', 200.00); |
158 | 158 | </programlisting> |
159 | 159 | </para> |
160 | 160 |
|
|