Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1smPJt-005TUS-7a for pgsql-committers@arkaria.postgresql.org; Fri, 06 Sep 2024 03:07:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1smPJr-0059dR-QF for pgsql-committers@arkaria.postgresql.org; Fri, 06 Sep 2024 03:07:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1smPJf-0057xa-I0 for pgsql-committers@lists.postgresql.org; Fri, 06 Sep 2024 03:07:19 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1smPJc-000Nke-PF for pgsql-committers@lists.postgresql.org; Fri, 06 Sep 2024 03:07:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=C3SnoNDEEpl7jTrJa5Lm3fLFGt8wfM+2OUTrfUaFA6g=; b=ZTDChpr0aqBjZjCcOUjQe3zRx0 ItoWgTva43B4pIs2T8VVAo2GbCxGG8Gx5oX4j1V6UES9/jQA21ncNErhaAk/c7ksRTGq31DKpEPWv brDHC0PhWNF07Uc4CtdPCH6mXm5Hb0NutO2xD9S+UPfGRBrE19rAKu65uimsV2KSEoHwAiqh78IJY wHwvH2/N97aQqKncV51jLyr41q3JHb1cNnoiJo/K7yjW/mLnRUaNIwp4I7L0kPxrW9TVA0oNhwiZU tuQgwEkJghSbU0E6OE46xY3hZBGTOrasSgHPOemAwj7fbhELSeFbU1zsJAlYXEFk//PdXxOLau1vc KRXnKCtA==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1smPJa-001B1g-9j for pgsql-committers@lists.postgresql.org; Fri, 06 Sep 2024 03:07:14 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1smPJZ-000LNj-8Q for pgsql-committers@lists.postgresql.org; Fri, 06 Sep 2024 03:07:14 +0000 Content-Type: multipart/mixed; boundary="===============6465842855748624130==" MIME-Version: 1.0 From: Amit Langote To: pgsql-committers@lists.postgresql.org Subject: pgsql: SQL/JSON: Avoid initializing unnecessary ON ERROR / ON EMPTY ste X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 06 Sep 2024 03:07:14 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6465842855748624130== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U1FML0pTT046IEF2b2lkIGluaXRpYWxpemluZyB1bm5lY2Vzc2FyeSBPTiBFUlJPUiAvIE9OIEVN UFRZIHN0ZXBzCgpXaGVuIHRoZSBPTiBFUlJPUiAvIE9OIEVNUFRZIGJlaGF2aW9yIGlzIHRvIHJl dHVybiBOVUxMLCByZXR1cm5pbmcKTlVMTCBkaXJlY3RseSBmcm9tIEV4ZWNFdmFsSnNvbkV4cHJQ YXRoKCkgc3VmZmljZXMuIFRoZXJlZm9yZSwgdGhlcmUncwpubyBuZWVkIHRvIGNyZWF0ZSBzZXBh cmF0ZSBzdGVwcyB0byBjaGVjayB0aGUgZXJyb3IvZW1wdHkgZmxhZyBvcgp0aG9zZSB0byBldmFs dWF0ZSB0aGUgdGhlIGNvbnN0YW50IE5VTEwgZXhwcmVzc2lvbi4gIFRoaXMgc3BlZWRzIHVwCmNv bW1vbiBjYXNlcyBiZWNhdXNlIHRoZSBkZWZhdWx0IE9OIEVSUk9SIC8gT04gRU1QVFkgYmVoYXZp b3IgZm9yCkpTT05fUVVFUlkoKSBhbmQgSlNPTl9WQUxVRSgpIGlzIHRvIHJldHVybiBOVUxMLiAg SG93ZXZlciwgdGhlc2Ugc3RlcHMKYXJlIG5lY2Vzc2FyeSBpZiB0aGUgUkVUVVJOSU5HIHR5cGUg aXMgYSBkb21haW4sIGFzIGNvbnN0cmFpbnRzIG9uIHRoZQpkb21haW4gbWF5IG5lZWQgdG8gYmUg Y2hlY2tlZC4KClJlcG9ydGVkLWJ5OiBKaWFuIEhlIDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5j b20+CkF1dGhvcjogSmlhbiBIZSA8amlhbi51bml2ZXJzYWxpdHlAZ21haWwuY29tPgpBdXRob3I6 IEFtaXQgTGFuZ290ZSA8YW1pdGxhbmdvdGUwOUBnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHBz Oi8vcG9zdGdyLmVzL20vQ0FDSnVmeEVvNHNVaktDWXRkYTBfcXQ5dGF6cXFLUG1GMWNxaFc5S0JP VWVKRnFRZDJnQG1haWwuZ21haWwuY29tCkJhY2twYXRjaC10aHJvdWdoOiAxNwoKQnJhbmNoCi0t LS0tLQpSRUxfMTdfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNx bC5vcmcvcGcvY29tbWl0ZGlmZi9lNGUyNzk3NmE2ODdkZDY0MWMxYzgyNTFmYWQzYTkwYTA4NzU2 ZGY4CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9leGVjdXRvci9l eGVjRXhwci5jIHwgMzAgKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0tCjEgZmlsZSBjaGFu Z2VkLCAyMiBpbnNlcnRpb25zKCspLCA4IGRlbGV0aW9ucygtKQoK --===============6465842855748624130==--