]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Doc: Update PL/pgSQL sample function in plpgsql.sgml.
authorAmit Kapila <akapila@postgresql.org>
Wed, 11 Sep 2019 04:55:49 +0000 (10:25 +0530)
committerAmit Kapila <akapila@postgresql.org>
Thu, 12 Sep 2019 08:07:43 +0000 (13:37 +0530)
commit1fcb73fe72dc3f2de50ca7e0d2b866a6fc8e8dc2
tree0c2f0b76811c3891759f32439a363d703a2bf68f
parent8da17f3f50612300f11c79b2f28e0b5fae9ac0b2
Doc: Update PL/pgSQL sample function in plpgsql.sgml.

The example used to explain 'Looping Through Query Results' uses
pseudo-materialized views.  Replace it with a more up-to-date example
which does the same thing with actual materialized views, which have
been available since PostgreSQL 9.3.

In the passing, change '%' as format specifier instead of '%s' as is used
in other examples in plpgsql.sgml.

Reported-by: Ian Barwick
Author: Ian Barwick
Reviewed-by: Amit Kapila
Backpatch-through: 9.4
Discussion: https://postgr.es/m/9a70d393-7904-4918-c97c-649f6d114b6a@2ndquadrant.com
doc/src/sgml/plpgsql.sgml