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
cond outer for over an array or just while cycle Reards Pavel > > Thanks again! > -- > songjinzhou (2903807...@qq.com) > > > *From:* Pavel Stehule > *Date:* 2023-01-19 21:04 > *To:* 2903807...@qq.com > *CC:* pgsql-hackers ; 12765761

Re: Support plpgsql multi-range in conditional control

2023-01-19 Thread Tom Lane
Pavel Stehule writes: > čt 19. 1. 2023 v 10:23 odesílatel 2903807...@qq.com <2903807...@qq.com> > napsal: >> Dear hackers, my good friend Hou Jiaxing and I have implemented a version >> of the code that supports multiple integer range conditions in the in >> condition control of the for loop state

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

2023-01-19 Thread 2903807...@qq.com
: Support plpgsql multi-range in conditional control Hi čt 19. 1. 2023 v 10:23 odesílatel 2903807...@qq.com <2903807...@qq.com> napsal: Dear hackers, my good friend Hou Jiaxing and I have implemented a version of the code that supports multiple integer range conditions in the in condition cont

Re: Support plpgsql multi-range in conditional control

2023-01-19 Thread Pavel Stehule
Hi čt 19. 1. 2023 v 10:23 odesílatel 2903807...@qq.com <2903807...@qq.com> napsal: > Dear hackers, my good friend Hou Jiaxing and I have implemented a version > of the code that supports multiple integer range conditions in the in > condition control of the for loop statement in the plpgsql proc