Re: doc: update PL/pgSQL sample loop function

2019-09-11 Thread Ian Barwick
On 2019/09/11 14:44, Amit Kapila wrote: On Sun, Sep 1, 2019 at 9:09 AM Amit Kapila wrote: The current example shows the usage of looping in plpgsql, so as such there is no correctness issue, but OTOH there is no harm in updating the example as proposed by Ian Barwick. Does anyone else see any

Re: doc: update PL/pgSQL sample loop function

2019-09-11 Thread Pavel Stehule
st 11. 9. 2019 v 11:51 odesílatel Amit Kapila napsal: > On Wed, Sep 11, 2019 at 11:40 AM Pavel Stehule > wrote: > > > > st 11. 9. 2019 v 7:45 odesílatel Amit Kapila > napsal: > >> > >> On Sun, Sep 1, 2019 at 9:09 AM Amit Kapila > wrote: > >> > > >> > The current example shows the usage of loop

Re: doc: update PL/pgSQL sample loop function

2019-09-11 Thread Amit Kapila
On Wed, Sep 11, 2019 at 11:40 AM Pavel Stehule wrote: > > st 11. 9. 2019 v 7:45 odesílatel Amit Kapila napsal: >> >> On Sun, Sep 1, 2019 at 9:09 AM Amit Kapila wrote: >> > >> > The current example shows the usage of looping in plpgsql, so as such >> > there is no correctness issue, but OTOH ther

Re: doc: update PL/pgSQL sample loop function

2019-09-10 Thread Pavel Stehule
st 11. 9. 2019 v 7:45 odesílatel Amit Kapila napsal: > On Sun, Sep 1, 2019 at 9:09 AM Amit Kapila > wrote: > > > > The current example shows the usage of looping in plpgsql, so as such > > there is no correctness issue, but OTOH there is no harm in updating > > the example as proposed by Ian Bar

Re: doc: update PL/pgSQL sample loop function

2019-09-10 Thread Amit Kapila
On Sun, Sep 1, 2019 at 9:09 AM Amit Kapila wrote: > > The current example shows the usage of looping in plpgsql, so as such > there is no correctness issue, but OTOH there is no harm in updating > the example as proposed by Ian Barwick. Does anyone else see any > problem with this idea? If we ag

Re: doc: update PL/pgSQL sample loop function

2019-08-31 Thread Amit Kapila
On Thu, Aug 29, 2019 at 10:07 AM Pavel Stehule wrote: > > Hi > > čt 29. 8. 2019 v 5:03 odesílatel Ian Barwick > napsal: >> >> Hi >> >> Here: >> >> >> https://www.postgresql.org/docs/current/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING >> >> we have a sample PL/PgSQL function (da

Re: doc: update PL/pgSQL sample loop function

2019-08-28 Thread Pavel Stehule
Hi čt 29. 8. 2019 v 5:03 odesílatel Ian Barwick 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 som