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

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 Stehule

Date: 2023-01-25 23:24

To: songjinzhou

CC: pgsql-hackers

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

Hi

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

Date: 2023-01-25 22:21

To: songjinzhou

CC: pgsql-hackers

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

Hi

ok, I was wrong, PL/SQL supports this syntax. But what is the real use case? This is an example from the book.

Regards

Pavel

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

I don't see any real usage. PL/SQL doesn't support proposed syntax.

Regards

Pavel

 

reply.

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.

Regards

Pavel