Re: Re: Support plpgsql multi-range in conditional control

2023-01-25 Thread Isaac Morland
On Wed, 25 Jan 2023 at 12:02, Pavel Stehule wrote: > > > st 25. 1. 2023 v 17:22 odesílatel songjinzhou <2903807...@qq.com> napsal: > >> >> As follows, we can only repeat the for statement before we use such SQL: >> >> begin >> for i in 10..20 loop >> raise notice '%', i; -- Things to do >> end lo

Re: Re: Support plpgsql multi-range in conditional control

2023-01-25 Thread Pavel Stehule
st 25. 1. 2023 v 17:22 odesílatel songjinzhou <2903807...@qq.com> napsal: > > >Hi > > >st 25. 1. 2023 v 16:39 odesílatel songjinzhou <2903807...@qq.com> > napsal: Hello, my personal understanding is that you can use multiple > iterative controls (as a merge) in a fo loop, otherwise we can only > s

Re: Re: Support plpgsql multi-range in conditional control

2023-01-25 Thread songjinzhou
>Hi >st 25. 1. 2023 v 16:39 odesílatel songjinzhou <2903807...@qq.com> napsal: >Hello, my personal understanding is that you can use multiple iterative >controls (as a merge) in a fo loop, otherwise we can only separate these >iterative controls, but in fact, they may do the same thing. >1. p

Re: Re: Support plpgsql multi-range in conditional control

2023-01-25 Thread Pavel Stehule
Hi st 25. 1. 2023 v 15:18 odesílatel songjinzhou <2903807...@qq.com> napsal: > Hello, this usage scenario is from Oracle's PL/SQL language (I have been > doing the function development of PL/SQL language for some time). I think > this patch is very practical and will expand our for loop scenario

Re: Re: Support plpgsql multi-range in conditional control

2023-01-25 Thread songjinzhou
Hello, this usage scenario is from Oracle's PL/SQL language (I have been doing the function development of PL/SQL language for some time). I think this patch is very practical and will expand our for loop scenario. In short, I look forward to your reply. Happy Chinese New Year! songjinzhou(2

Re: Re: Support plpgsql multi-range in conditional control

2023-01-19 Thread Pavel Stehule
čt 19. 1. 2023 v 16:54 odesílatel Pavel Stehule napsal: > > > čt 19. 1. 2023 v 15:20 odesílatel 2903807...@qq.com <2903807...@qq.com> > napsal: > >> Hello, thank you very much for your reply. But I think you may have >> misunderstood what we have done. >> >> What we do this time is that we can us

Re: Re: Support plpgsql multi-range in conditional control

2023-01-19 Thread Pavel Stehule
čt 19. 1. 2023 v 15:20 odesílatel 2903807...@qq.com <2903807...@qq.com> napsal: > Hello, thank you very much for your reply. But I think you may have > misunderstood what we have done. > > What we do this time is that we can use multiple range ranges > (condition_iterator) after in. Previously, we

Re: Re: Support plpgsql multi-range in conditional control

2023-01-19 Thread 2903807...@qq.com
Hello, thank you very much for your reply. But I think you may have misunderstood what we have done. What we do this time is that we can use multiple range ranges (condition_iterator) after in. Previously, we can only use such an interval [lower, upper] after in, but in some scenarios, we may