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 1sN3ls-006VYf-8b for pgsql-committers@arkaria.postgresql.org; Fri, 28 Jun 2024 05:03:40 +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 1sN3lq-000at4-79 for pgsql-committers@arkaria.postgresql.org; Fri, 28 Jun 2024 05:03:38 +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 1sN3lp-000asi-Ud for pgsql-committers@lists.postgresql.org; Fri, 28 Jun 2024 05:03:38 +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 1sN3ln-003w6T-Km for pgsql-committers@lists.postgresql.org; Fri, 28 Jun 2024 05:03:37 +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=iMlfuf/a/kLle5qG9b79zQf550Vj7KJmG0s+E4Mlt/c=; b=GhmHazKxOx71asgujkrMEdsjU3 jhLxjA9+w1+dG2xnvQVWL0rVrSJwUP7TAxRiZEwvEZwAFvO3BwUdicWBzTCM0eCJAf/xuY8vaJWaQ p8dAGLR/+ykVVn3Xq4ozAl3J2/60RG5pRYn6XXA8kWv7ToYE4b3COm9Ex7TOTXaZh+oDwyqCTObiD 6hgvY/sunV8DXaSCGdHivGBpjf/y35F7MufOY96WnOtIgXS2RUScLG+nFsAQzDsTHRG2B65YIjmo2 UIKP2JplgN1IoSPGFuqFr9FduRmdDNl4WUeXbbovsKgKR4jwOrSe5EbOUfTTTFHY+hp6GUBs+UCOU wx8jt6uw==; 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 1sN3lm-00B2Ko-07 for pgsql-committers@lists.postgresql.org; Fri, 28 Jun 2024 05:03:34 +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 1sN3lk-003K41-Df for pgsql-committers@lists.postgresql.org; Fri, 28 Jun 2024 05:03:33 +0000 Content-Type: multipart/mixed; boundary="===============3689939979816537571==" MIME-Version: 1.0 From: Amit Langote To: pgsql-committers@lists.postgresql.org Subject: pgsql: SQL/JSON: Validate values in ON ERROR/EMPTY clauses X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 28 Jun 2024 05:03:33 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3689939979816537571== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U1FML0pTT046IFZhbGlkYXRlIHZhbHVlcyBpbiBPTiBFUlJPUi9FTVBUWSBjbGF1c2VzCgpDdXJy ZW50bHksIHRoZSBncmFtbWFyIGFsbG93cyBhbnkgc3VwcG9ydGVkIHZhbHVlcyBpbiB0aGUgT04g RVJST1IKYW5kIE9OIEVNUFRZIGNsYXVzZXMgZm9yIFNRTC9KU09OIGZ1bmN0aW9ucywgcmVnYXJk bGVzcyBvZiB3aGV0aGVyCnRoZSB2YWx1ZXMgYXJlIGFwcHJvcHJpYXRlIGZvciB0aGUgZnVuY3Rp b24uIFRoaXMgY29tbWl0IGVuc3VyZXMKdGhhdCBkdXJpbmcgcGFyc2UgYW5hbHlzaXMsIHRoZSBw cm92aWRlZCB2YWx1ZSBpcyBjaGVja2VkIGZvcgp2YWxpZGl0eSBmb3IgdGhlIGdpdmVuIGZ1bmN0 aW9uIGFuZCB0aHJvd3MgYSBzeW50YXggZXJyb3IgaWYgaXQgaXMKbm90LgoKV2hpbGUgYXQgaXQs IHRoaXMgZml4ZXMgc29tZSBvbWlzc2lvbnMgaW4gdGhlIGRvY3VtZW50YXRpb24gb2YgdGhlCk9O IEVSUk9SL0VNUFRZIGNsYXVzZXMgZm9yIEpTT05fVEFCTEUoKS4KClJlcG9ydGVkLWJ5OiBKaWFu IEhlIDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBKaWFuIEhlIDxq aWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVz L20vQ0FDSnVmeEZnV0dxcEVTU1l6eUo2dFN1cnIzdkZZQlNORW1DZmtHeUJfZE1kcHRGblpRJTQw bWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0 cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi81NWU1NmM4NGRhOTlmZTdiZWNk YTIxOTQ1NjNmNDhiYjMwODNjMmQxCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpkb2Mv c3JjL3NnbWwvZnVuYy5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDYgKy0Kc3Jj L2JhY2tlbmQvcGFyc2VyL3BhcnNlX2V4cHIuYyAgICAgICAgICAgICAgICAgIHwgMTI2ICsrKysr KysrKysrKysrKysrKysrKy0tCnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV9qc29udGFibGUuYyAg ICAgICAgICAgICB8ICAgMiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3NxbGpzb25fanNv bnRhYmxlLm91dCAgfCAgMjYgKysrKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zcWxqc29u X3F1ZXJ5ZnVuY3Mub3V0IHwgIDE2ICsrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9zcWxqc29uX2pz b250YWJsZS5zcWwgICAgICAgfCAgIDcgKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvc3FsanNvbl9x dWVyeWZ1bmNzLnNxbCAgICAgIHwgICA1ICsKNyBmaWxlcyBjaGFuZ2VkLCAxNzQgaW5zZXJ0aW9u cygrKSwgMTQgZGVsZXRpb25zKC0pCgo= --===============3689939979816537571==--