Re: Using "exit" to bring "goto" functionality.

On 7/10/23 12:08, DAVID ROTH wrote:
> I am a newbe at my current job.
> They have a separate log table for every table because they want all the columns.
> I have been looking for a way to go to a common log table without requiring major changes to the application.
>
> With your help, I have a proof of principle that I can demonstrate now.

FYI, you replied to the wrong thread.

>
>
>
>> On 07/10/2023 2:58 PM EDT Christophe Pettus <xof(at)thebuild(dot)com> wrote:
>>
>>
>>> On Jul 10, 2023, at 11:54, Bryn Llewellyn <bryn(at)yugabyte(dot)com> wrote:
>>>
>>> What is the rationale for supporting what seems to be on its face this strange functionality?
>>
>> It allows you to EXIT or CONTINUE a loop thaIt is not the innermost one, by naming the label of an outer loop.
>>
>> One can debate endlessly whether it's good or bad to include that functionality, but it definitely has use cases. I would assume that at this point, it's not going anywhere.
>>
>> The relevant documentation is here:
>>
>> https://www.postgresql.org/docs/15/plpgsql-control-structures.html#PLPGSQL-CONTROL-STRUCTURES-LOOPS
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com