Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qIwFY-0000AF-9m for pgsql-general@arkaria.postgresql.org; Mon, 10 Jul 2023 19:08:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qIwFW-0004tU-VZ for pgsql-general@arkaria.postgresql.org; Mon, 10 Jul 2023 19:08:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qIwFW-0004m5-L5 for pgsql-general@lists.postgresql.org; Mon, 10 Jul 2023 19:08:42 +0000 Received: from resqmta-h1p-028590.sys.comcast.net ([2001:558:fd02:2446::8]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qIwFO-0037iQ-UN for pgsql-general@lists.postgresql.org; Mon, 10 Jul 2023 19:08:40 +0000 Received: from resomta-h1p-027913.sys.comcast.net ([96.102.179.200]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 256/256 bits) (Client did not present a certificate) by resqmta-h1p-028590.sys.comcast.net with ESMTP id Iq0bq1skwlrKdIwFLqswV3; Mon, 10 Jul 2023 19:08:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1689016111; bh=wliAzg/Ys6DzdbyzUnyaPCgKoqbusDihEvXr1N6Lb2U=; h=Received:Received:Date:From:To:Message-ID:Subject:MIME-Version: Content-Type:Xfinity-Spam-Result; b=aYvkdkx/SQrgUFBvjn3UhZs7gkiwu1RIIEyEdsiAqO6ets6lAJW5/jXFpRwgRDdV5 FySbr/p1gGJPAYV/3em1TQce5SzaZsllk+hUVaWcHGHJ0RBBMEw0su7ZssZRsWJWsc 47WvfUnywLt07zQBcCAdVLejSJeYv6H1vM4x1OvcBB8lGgeo3r3WWjKSbnsSwOZ8PU GCKnNunJcFpBHMjjpEnTu2wZMakhgYjAVJ4OEBYml8iKOIM6apVpQh/ULreXqa8vrq t1RyprjkLwh2OaJPFNdWC/Ihnl0iywoMWJTiN6lPL3BWhnaDN1NtQE22GiULEwyRVG LayvRm8dMjh2w== Received: from oxappp-hoa-22o.email.comcast.net ([96.116.234.246]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 256/256 bits) (Client did not present a certificate) by resomta-h1p-027913.sys.comcast.net with ESMTPS id IwEwqQekvY0a2IwEwqFNIo; Mon, 10 Jul 2023 19:08:06 +0000 X-Xfinity-VAAS: gggruggvucftvghtrhhoucdtuddrgedviedrvdekgdduvdehucetufdoteggodetrfdotffvucfrrhhofhhilhgvmecuvehomhgtrghsthdqtfgvshhipdfqfgfvpdfpqffurfetoffkrfenuceurghilhhouhhtmecufedtudenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujfgurhepfffhvfevkfgjfhfugggtgffrkgfoihesthejsgdtredtjeenucfhrhhomhepffetggfkffcutffqvffjuceorggurghpthhrohhnsegtohhmtggrshhtrdhnvghtqeenucggtffrrghtthgvrhhnpeefkeetieevheejieeggeeiudfhveetteehhffgveeghfevveeigfduveffvdelgeenucffohhmrghinhepphhoshhtghhrvghsqhhlrdhorhhgnecukfhppeeliedrudduiedrvdefgedrvdegiedpvdeitddumeduledumeekgedttdemugdvrgdtmeeiledvrgemugegtggvmeefvggtvdemvgdtsgefnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehhvghlohepohigrghpphhpqdhhohgrqddvvdhordgvmhgrihhlrdgtohhmtggrshhtrdhnvghtpdhinhgvthepleeirdduudeirddvfeegrddvgeeipdhmrghilhhfrhhomheprggurghpthhrohhnsegtohhmtggrshhtrdhnvghtpdhnsggprhgtphhtthhopeefpdhrtghpthhtohepgihofhesthhhvggsuhhilhgurdgtohhmpdhrtghpthhtohepsghrhihnseihuhhgrggshihtvgdrtghomhdprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-Xfinity-VMeta: sc=-100.00;st=legit Date: Mon, 10 Jul 2023 15:08:05 -0400 (EDT) From: DAVID ROTH To: Christophe Pettus , Bryn Llewellyn Cc: pgsql-general list Message-ID: <417293360.172884.1689016086131@connect.xfinity.com> In-Reply-To: <39EC45EE-8162-4B19-97C2-BE54E758B294@thebuild.com> References: <655E5E21-FCED-405F-81F6-AE2713F27337@yugabyte.com> <39EC45EE-8162-4B19-97C2-BE54E758B294@thebuild.com> Subject: Re: Using "exit" to bring "goto" functionality. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 Importance: Normal X-Mailer: Open-Xchange Mailer v7.10.6-Rev39 X-Originating-IP: 2601:191:8400:d2a0:692a:d4ce:3ec2:e0b3 X-Originating-Client: open-xchange-appsuite List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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. > On 07/10/2023 2:58 PM EDT Christophe Pettus wrote: > > > > On Jul 10, 2023, at 11:54, Bryn Llewellyn 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