Commit6f94280

committed

Document PERFORM limitation when using WITH queries.

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

1 parentae92eff commit6f94280Copy full SHA for 6f94280

File tree

-0

lines changed

-0

lines changed

Lines changed: 3 additions & 0 deletions

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

Comments

(0)