Re: Re: Support plpgsql multi-range in conditional control - Mailing list pgsql-hackers
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.
songjinzhou(2903807914@qq.com)
From: Pavel StehuleDate: 2023-01-25 23:24To: songjinzhouCC: pgsql-hackersSubject: Re: Re: Support plpgsql multi-range in conditional controlHist 25. 1. 2023 v 15:39 odesílatel songjinzhou <2903807914@qq.com> napsal:Hello, this is the target I refer to. At present, our patch supports this usage, so I later thought of developing this patch.songjinzhou(2903807914@qq.com)From: Pavel StehuleDate: 2023-01-25 22:21To: songjinzhouCC: pgsql-hackersSubject: Re: Re: Support plpgsql multi-range in conditional controlHiok, I was wrong, PL/SQL supports this syntax. But what is the real use case? This is an example from the book.RegardsPavelst 25. 1. 2023 v 15:18 odesílatel songjinzhou <2903807914@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. In short, I look forward to yourI don't see any real usage. PL/SQL doesn't support proposed syntax.RegardsPavelreply.Happy Chinese New Year!songjinzhou(2903807914@qq.com)Maybe you didn't understand my reply. Without some significant real use case, I am strongly against the proposed feature and merging your patch to upstream. I don't see any reason to enhance language with this feature.RegardsPavel
Attachment
pgsql-hackers by date: