Re: Using "exit" to bring "goto" functionality. - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Using "exit" to bring "goto" functionality.
Date
Msg-id 39EC45EE-8162-4B19-97C2-BE54E758B294@thebuild.com
Whole thread Raw
In response to Using "exit" to bring "goto" functionality.  (Bryn Llewellyn <bryn@yugabyte.com>)
Responses Re: Using "exit" to bring "goto" functionality.  (DAVID ROTH <adaptron@comcast.net>)
Re: Using "exit" to bring "goto" functionality.  (Bryn Llewellyn <bryn@yugabyte.com>)
List pgsql-general

> On Jul 10, 2023, at 11:54, Bryn Llewellyn <bryn@yugabyte.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 that 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
wouldassume 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


pgsql-general by date:

Previous
From: Bryn Llewellyn
Date:
Subject: Using "exit" to bring "goto" functionality.
Next
From: DAVID ROTH
Date:
Subject: Re: Using "exit" to bring "goto" functionality.