pgsql: Doc: improve discussion of variable substitution in PL/pgSQL. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Doc: improve discussion of variable substitution in PL/pgSQL.
Date
Msg-id E1lMZfb-0006kW-Ja@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Doc: improve discussion of variable substitution in PL/pgSQL.

This was a bit disjointed, partly because of a not-well-considered
decision to document SQL commands that don't return result rows as
though they had nothing in common with commands that do.  Rearrange
so that we have one discussion of variable substitution that clearly
applies to all types of SQL commands, and then handle the question
of processing command output separately.  Clarify that EXPLAIN,
CREATE TABLE AS SELECT, and similar commands that incorporate an
optimizable statement will act like optimizable statements for the
purposes of variable substitution.  Do a bunch of minor wordsmithing
in the same area.

David Johnston and Tom Lane, reviewed by Pavel Stehule and David
Steele

Discussion: https://postgr.es/m/CAKFQuwYvMKucM5fnZvHSo-ah4S=_n9gmKeu6EAo=_fTrohunqQ@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/c783e656d41816b0328cb4bff27f11b70200770e

Modified Files
--------------
doc/src/sgml/plpgsql.sgml | 172 ++++++++++++++++++++++++++++++----------------
1 file changed, 114 insertions(+), 58 deletions(-)


pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pgsql: Add libpq pipeline mode support to pgbench
Next
From: Tom Lane
Date:
Subject: pgsql: Prevent buffer overrun in read_tablespace_map().