Re: doc: update PL/pgSQL sample loop function - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: doc: update PL/pgSQL sample loop function
Date
Msg-id CAFj8pRBb6bc7Leyzveo_n8Qdp57Uug9Nwn74+hooB1jT-BprDg@mail.gmail.com
Whole thread Raw
In response to doc: update PL/pgSQL sample loop function  (Ian Barwick <ian.barwick@2ndquadrant.com>)
Responses Re: doc: update PL/pgSQL sample loop function  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
Hi

čt 29. 8. 2019 v 5:03 odesílatel Ian Barwick <ian.barwick@2ndquadrant.com> napsal:
Hi

Here:

   https://www.postgresql.org/docs/current/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING

we have a sample PL/PgSQL function (dating from at least 7.2) demonstrating
query result loops, which refreshes some pseudo materialized views stored in
a user-defined table.

As we've had proper materialized views since 9.3, I thought it might
be nice to update this with a self-contained sample which can be used
as-is; see attached patch.

(As a side note the current sample function contains a couple of "%s"
placeholders which should be just "%"; a quick search of plpgsql.sgml
shows this is the only place they occur).

Will submit to the next commitfest.

+1

Pavel



Regards

Ian Barwick

--
  Ian Barwick                   https://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Ian Barwick
Date:
Subject: doc: update PL/pgSQL sample loop function
Next
From: Fabien COELHO
Date:
Subject: Re: refactoring - share str2*int64 functions