Commit6de1fef

committed

Fix incorrect SPI example, per Yoshihisa Nakano.

1 parenta9b1ff4 commit6de1fefCopy full SHA for 6de1fef

File tree

-5

lines changed

-5

lines changed

Lines changed: 5 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/spi.sgml,v 1.43 2005/09/12 18:40:19 neilc Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/spi.sgml,v 1.44 2005/12/07 15:39:25 tgl Exp $`
`3`	`3`	`-->`
`4`	`4`
`5`	`5`	`<chapter id="spi">`
`@@ -3044,7 +3044,7 @@ CREATE FUNCTION execq(text, integer) RETURNS integer`
`3044`	`3044`	`(1 row)`
`3045`	`3045`
`3046`	`3046`	`=> INSERT INTO a VALUES (execq('INSERT INTO a VALUES (0)', 0));`
`3047`		`-INSERT167631 1`
	`3047`	`+INSERT0 1`
`3048`	`3048`	`=> SELECT execq('SELECT * FROM a', 0);`
`3049`	`3049`	`INFO: EXECQ: 0 -- inserted by execq`
`3050`	`3050`	`INFO: EXECQ: 1 -- returned by execq and inserted by upper INSERT`
`@@ -3073,16 +3073,16 @@ INFO: EXECQ: 2 -- 0 + 2, only one row inserted - as specified`
`3073`	`3073`	`=> DELETE FROM a;`
`3074`	`3074`	`DELETE 3`
`3075`	`3075`	`=> INSERT INTO a VALUES (execq('SELECT * FROM a', 0) + 1);`
`3076`		`-INSERT167712 1`
	`3076`	`+INSERT0 1`
`3077`	`3077`	`=> SELECT * FROM a;`
`3078`	`3078`	`x`
`3079`	`3079`	`---`
`3080`	`3080`	`1 -- no rows in a (0) + 1`
`3081`	`3081`	`(1 row)`
`3082`	`3082`
`3083`	`3083`	`=> INSERT INTO a VALUES (execq('SELECT * FROM a', 0) + 1);`
`3084`		`-INFO: EXECQ:0`
`3085`		`-INSERT167713 1`
	`3084`	`+INFO: EXECQ:1`
	`3085`	`+INSERT0 1`
`3086`	`3086`	`=> SELECT * FROM a;`
`3087`	`3087`	`x`
`3088`	`3088`	`---`

Comments

(0)