postgres.git / summary / log / commit / refs
commit 6de1fef52c5d9cd1f9f7cae696346ff882dcd45a
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: Wed Dec 07 15:39:25 2005 +0000
First released in: 8.2.0, 8.1.1
Fix incorrect SPI example, per Yoshihisa Nakano.
doc/src/sgml/spi.sgml | 10 +++++-----
1 file changed, 5 insertions(+), 5 deletions(-)
diff --git a/doc/src/sgml/spi.sgml b/doc/src/sgml/spi.sgml
index 8db1aba7bb4..a5ffe8ec577 100644
--- a/doc/src/sgml/spi.sgml
+++ b/doc/src/sgml/spi.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/spi.sgml,v 1.43 2005/09/12 18:40:19 neilc Exp $
+$PostgreSQL: pgsql/doc/src/sgml/spi.sgml,v 1.44 2005/12/07 15:39:25 tgl Exp $
-->
<chapter id="spi">
@@ -3044,7 +3044,7 @@ CREATE FUNCTION execq(text, integer) RETURNS integer
(1 row)
=> INSERT INTO a VALUES (execq('INSERT INTO a VALUES (0)', 0));
-INSERT 167631 1
+INSERT 0 1
=> SELECT execq('SELECT * FROM a', 0);
INFO: EXECQ: 0 -- inserted by execq
INFO: EXECQ: 1 -- returned by execq and inserted by upper INSERT
@@ -3073,7 +3073,7 @@ INFO: EXECQ: 2 -- 0 + 2, only one row inserted - as specified
=> DELETE FROM a;
DELETE 3
=> INSERT INTO a VALUES (execq('SELECT * FROM a', 0) + 1);
-INSERT 167712 1
+INSERT 0 1
=> SELECT * FROM a;
x
---
@@ -3081,8 +3081,8 @@ INSERT 167712 1
(1 row)
=> INSERT INTO a VALUES (execq('SELECT * FROM a', 0) + 1);
-INFO: EXECQ: 0
-INSERT 167713 1
+INFO: EXECQ: 1
+INSERT 0 1
=> SELECT * FROM a;
x
---
[parent: a9b1ff4c1d69]