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 1p2y6R-0005CV-Eu for pgsql-hackers@arkaria.postgresql.org; Wed, 07 Dec 2022 17:21:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p2y6Q-0002jA-Du for pgsql-hackers@arkaria.postgresql.org; Wed, 07 Dec 2022 17:21:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p2y6Q-0002j1-4J for pgsql-hackers@lists.postgresql.org; Wed, 07 Dec 2022 17:21:02 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p2y6O-0007Zw-3g for pgsql-hackers@lists.postgresql.org; Wed, 07 Dec 2022 17:21:01 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 2B7HKtOi4039001; Wed, 7 Dec 2022 12:20:55 -0500 From: Tom Lane To: "David G. Johnston" cc: Andrew Dunstan , Corey Huinker , Andres Freund , Alvaro Herrera , Joe Conway , Robert Haas , Nikita Glukhov , PostgreSQL Hackers Subject: Re: Error-safe user functions In-reply-to: References: <20221205174231.6wpmbuxafnfzlbuh@alvherre.pgsql> <85e40849-4458-bbb9-62ee-d9e7faf0c7dc@dunslane.net> <3323802.1670263204@sss.pgh.pa.us> <3496391.1670276406@sss.pgh.pa.us> <20221205234734.sab3fuxy6q2sokjd@alap3.anarazel.de> <3518534.1670285891@sss.pgh.pa.us> <20221206005607.lxcrazckoalptwds@alap3.anarazel.de> <3523582.1670288815@sss.pgh.pa.us> <40ff1ed1-4245-e343-bffa-c7755b031492@dunslane.net> <3889877.1670358069@sss.pgh.pa.us> <4009543.1670422833@sss.pgh.pa.us> <6acddf68-7cb7-e9e7-a5a7-0abc87b3c55b@dunslane.net> <4026789.1670426602@sss.pgh.pa.us> <4031572.1670429176@sss.pgh.pa.us> <4037148.1670432349@sss.pgh.pa.us> Comments: In-reply-to "David G. Johnston" message dated "Wed, 07 Dec 2022 10:02:47 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <4038999.1670433655.1@sss.pgh.pa.us> Date: Wed, 07 Dec 2022 12:20:55 -0500 Message-ID: <4039000.1670433655@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk "David G. Johnston" writes: > So long as you aren't opposed to the idea if someone else does the work, > adding sect2 is better than nothing even if it is just a stop-gap measure. OK, we can agree on that. As for the other point --- not sure why I didn't remember this right off, but the point of two test functions is that one exercises the code path with details_wanted = true while the other exercises details_wanted = false. A combined function would only test the first case. regards, tom lane