Re: doc: update PL/pgSQL sample loop function

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: doc: update PL/pgSQL sample loop function
Дата
Msg-id CAFj8pRBb6bc7Leyzveo_n8Qdp57Uug9Nwn74+hooB1jT-BprDg@mail.gmail.com
обсуждение исходный текст
Ответ на doc: update PL/pgSQL sample loop function  (Ian Barwick <ian.barwick@2ndquadrant.com>)
Ответы Re: doc: update PL/pgSQL sample loop function  (Amit Kapila <amit.kapila16@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ian Barwick
Дата:
Сообщение: doc: update PL/pgSQL sample loop function
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: refactoring - share str2*int64 functions