Doc: clarify behavior of row-limit arguments in the PLs' SPI wrappers.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 66ab2660e0783fd4f6be5936e17a2c8e12335d0d
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2023-05-02T21:55:01Z
Releases: 14.8
Doc: clarify behavior of row-limit arguments in the PLs' SPI wrappers.

plperl, plpython, and pltcl all provide query-execution functions
that are thin wrappers around SPI_execute() or its variants.
The SPI functions document their row-count limit arguments clearly,
as "maximum number of rows to return, or 0 for no limit".  However
the PLs' documentation failed to explain this special behavior of
zero, so that a reader might well assume it means "fetch zero
rows".  Improve that.

Daniel Gustafsson and Tom Lane, per report from Kieran McCusker

Discussion: https://postgr.es/m/CAGgUQ6H6qYScctOhktQ9HLFDDoafBKHyUgJbZ6q_dOApnzNTXg@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/plperl.sgml modified +16 −5
doc/src/sgml/plpython.sgml modified +11 −2
doc/src/sgml/pltcl.sgml modified +5 −3

Documentation touched

Discussion