|
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 | --- |
|