From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "2903807914(at)qq(dot)com" <2903807914(at)qq(dot)com> |
Cc: | pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, 1276576182 <1276576182(at)qq(dot)com> |
Subject: | Re: Support plpgsql multi-range in conditional control |
Date: | 2023-01-19 13:04:41 |
Message-ID: | CAFj8pRBQVLWG5bg9=8BV+NsE3osgMemGT1pU5ffHBa6BP_H8fA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi
čt 19. 1. 2023 v 10:23 odesílatel 2903807914(at)qq(dot)com <2903807914(at)qq(dot)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 procedural
> language. A typical example is as follows:
>
> postgres=# do $$
> declare
> i int := 10;
> begin
> for i in 1..10 by 3, reverse i+10..i+1 by 3 loop
> raise info '%', i;
> end loop;
> end $$;
> INFO: 1
> INFO: 4
> INFO: 7
> INFO: 10
> INFO: 20
> INFO: 17
> INFO: 14
> INFO: 11
> do
> postgres=#
>
> Hope to get your feedback, thank you!
>
I don't like it. The original design of ADA language is to be a safe and
simple language. Proposed design is in 100% inversion.
What use case it should to support?
Regards
Pavel
>
> ------------------------------
> 2903807914(at)qq(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2023-01-19 13:17:22 | Re: Time delayed LR (WAS Re: logical replication restrictions) |
Previous Message | Amit Kapila | 2023-01-19 12:59:05 | Re: Time delayed LR (WAS Re: logical replication restrictions) |