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@xxxxxxxxxxxx> wrote:
On Jul 10, 2023, at 11:54, Bryn Llewellyn <bryn@xxxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
