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
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
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
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
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
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
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
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
