Commit2faa8e2

committed

Have PL/pgSQL FETCH set DIAGNOSTICS ROW_COUNT.

Andrew Gierth

1 parent227f817 commit2faa8e2Copy full SHA for 2faa8e2

File tree

-3

lines changed

-3

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.138 2009/02/05 15:25:49 momjian Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.139 2009/04/02 19:20:45 momjian Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="plpgsql">`
`4`	`4`	`<title><application>PL/pgSQL</application> - <acronym>SQL</acronym> Procedural Language</title>`
`@@ -1285,7 +1285,7 @@ GET DIAGNOSTICS <replaceable>variable</replaceable> = <replaceable>item</replace`
`1285`	`1285`	`value to be assigned to the specified variable (which should be`
`1286`	`1286`	`of the right data type to receive it). The currently available`
`1287`	`1287`	`status items are <varname>ROW_COUNT</>, the number of rows`
`1288`		`- processed by the last <acronym>SQL</acronym> command sentdownto`
	`1288`	`+ processed by the last <acronym>SQL</acronym> command sent to`
`1289`	`1289`	`the <acronym>SQL</acronym> engine, and <varname>RESULT_OID</>,`
`1290`	`1290`	`the OID of the last row inserted by the most recent`
`1291`	`1291`	`<acronym>SQL</acronym> command. Note that <varname>RESULT_OID</>`

Lines changed: 3 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $PostgreSQL: pgsql/src/pl/plpgsql/src/pl_exec.c,v 1.237 2009/04/0201:16:11 tgl Exp $`
	`11`	`+ * $PostgreSQL: pgsql/src/pl/plpgsql/src/pl_exec.c,v 1.238 2009/04/0219:20:45 momjian Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -3368,6 +3368,8 @@ exec_stmt_fetch(PLpgSQL_execstate estate, PLpgSQL_stmt_fetch stmt)`
`3368`	`3368`	`exec_set_found(estate,n!=0);`
`3369`	`3369`	`}`
`3370`	`3370`
	`3371`	`+estate->eval_processed=n;`
	`3372`	`+`
`3371`	`3373`	`returnPLPGSQL_RC_OK;`
`3372`	`3374`	`}`
`3373`	`3375`

Comments

(0)