Re: proposal - plpgsql - FOR over unbound cursor

2020-07-01 Thread Pavel Stehule
st 1. 7. 2020 v 20:06 odesílatel Tom Lane napsal: > Pavel Stehule writes: > > Last week I played with dbms_sql extension and some patterns of usage > > cursor in PL/SQL and PL/pgSQL. I found fact, so iteration over cursor > (FOR > > statement) doesn't support unbound cursors. I think so this lim

Re: proposal - plpgsql - FOR over unbound cursor

2020-07-01 Thread Tom Lane
Pavel Stehule writes: > Last week I played with dbms_sql extension and some patterns of usage > cursor in PL/SQL and PL/pgSQL. I found fact, so iteration over cursor (FOR > statement) doesn't support unbound cursors. I think so this limit is not > necessary. I guess I don't understand why we shou

Re: proposal - plpgsql - FOR over unbound cursor

2020-06-08 Thread Pavel Stehule
po 8. 6. 2020 v 13:40 odesílatel Asif Rehman napsal: > The following review has been posted through the commitfest application: > make installcheck-world: tested, passed > Implements feature: tested, passed > Spec compliant: not tested > Documentation:tested, passed >

Re: proposal - plpgsql - FOR over unbound cursor

2020-06-08 Thread Asif Rehman
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: not tested Documentation:tested, passed The patch applies cleanly and AFAICS there are no issues with the

proposal - plpgsql - FOR over unbound cursor

2020-05-18 Thread Pavel Stehule
Hi Last week I played with dbms_sql extension and some patterns of usage cursor in PL/SQL and PL/pgSQL. I found fact, so iteration over cursor (FOR statement) doesn't support unbound cursors. I think so this limit is not necessary. This statement can open portal for bound cursor or can iterate ove