Commitdcc728e

committed

Document PERFORM limitation when using WITH queries.

Backpatch to 9.0 and 9.1.Report from depstein@alliedtesting.com.

1 parent0154332 commitdcc728eCopy full SHA for dcc728e

File tree

-0

lines changed

-0

lines changed

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -845,6 +845,9 @@ PERFORM <replaceable>query</replaceable>;`
`845`	`845`	`result. Write the <replaceable>query</replaceable> the same`
`846`	`846`	`way you would write an SQL <command>SELECT</> command, but replace the`
`847`	`847`	`initial keyword <command>SELECT</> with <command>PERFORM</command>.`
	`848`	`+ For <keyword>WITH</> queries, use <keyword>PERFORM</> and then`
	`849`	`+ place the query in parentheses. (In this case, the query can only`
	`850`	`+ return one row.)`
`848`	`851`	`<application>PL/pgSQL</application> variables will be`
`849`	`852`	`substituted into the query just as for commands that return no result,`
`850`	`853`	`and the plan is cached in the same way. Also, the special variable`

Comments

(0)