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 1sNBHB-007FOa-Pl for pgsql-committers@arkaria.postgresql.org; Fri, 28 Jun 2024 13:04:29 +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 1sNBH9-004Ufe-Sk for pgsql-committers@arkaria.postgresql.org; Fri, 28 Jun 2024 13:04:28 +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 1sNBGO-004U8d-Ec for pgsql-committers@lists.postgresql.org; Fri, 28 Jun 2024 13:03:40 +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 1sNBGL-003zkZ-Tr for pgsql-committers@lists.postgresql.org; Fri, 28 Jun 2024 13:03:40 +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=hVkq63j9Q81Qr/ASz9S/pmRmDZsYeMB7USdPSSICb9c=; b=EDzTXRGCqfNuFeFipICYftYCTt k3I4EL7LwMEOZW9l82AVq31CmXvezWMUyEJZDjnkklnuqJj27cE8UdGKKWHLMQyfSf3oWvD3SuGLQ lfIU0xrwk0w4A8Zb2/oHytR/t5PuIg7Wk8c07djk8BRdt+z4Yjcq3jG4gDMIY1bzYGGLh7yqrfvvL RGF3sd8s/WqrnK1HiU88ew1TbouFrWT3yCvMqRIatTNmYFrzfOfjhMGzcQYsDueCEkfX1DDN8qGxw 70r9ptox/4yjaKLQ6VOnZ+xlK4eEdxIsC+CWyrwWs5SV9za/cZn76JCllcnxttdtvAd6j8ZqFSujj xPUmY7uQ==; 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 1sNBGK-00BD5I-CZ for pgsql-committers@lists.postgresql.org; Fri, 28 Jun 2024 13:03:36 +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 1sNBGJ-003Mpm-0X for pgsql-committers@lists.postgresql.org; Fri, 28 Jun 2024 13:03:35 +0000 Content-Type: multipart/mixed; boundary="===============8833525051748671508==" MIME-Version: 1.0 From: Amit Langote To: pgsql-committers@lists.postgresql.org Subject: pgsql: SQL/JSON: Always coerce JsonExpr result at runtime X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 28 Jun 2024 13:03:35 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8833525051748671508== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U1FML0pTT046IEFsd2F5cyBjb2VyY2UgSnNvbkV4cHIgcmVzdWx0IGF0IHJ1bnRpbWUKCkluc3Rl YWQgb2YgbG9va2luZyB1cCBjYXN0cyBhdCBwYXJzZSB0aW1lIGZvciBjb252ZXJ0aW5nIHRoZSBy ZXN1bHQKb2YgSnNvblBhdGgqIHF1ZXJ5IGZ1bmN0aW9ucyB0byB0aGUgc3BlY2lmaWVkIG9yIHRo ZSBkZWZhdWx0ClJFVFVSTklORyB0eXBlLCBhbHdheXMgcGVyZm9ybSB0aGUgY29udmVyc2lvbiBh dCBydW50aW1lIHVzaW5nIGVpdGhlcgp0aGUgdGFyZ2V0IHR5cGUncyBpbnB1dCBmdW5jdGlvbiBv ciB0aGUgZnVuY3Rpb24KanNvbl9wb3B1bGF0ZV90eXBlKCkuCgpUaGVyZSBhcmUgdHdvIG1vdGl2 YXRpb25zIGZvciB0aGlzIGNoYW5nZToKCjEuIGpzb25fcG9wdWxhdGVfdHlwZSgpIGNvZXJjZXMg dG8gdHlwZXMgd2l0aCB0eXBtb2Qgc3VjaCB0aGF0IGFueQogICBzdHJpbmcgdmFsdWVzIHRoYXQg ZXhjZWVkIGxlbmd0aCBsaW1pdCBjYXVzZSBhbiBlcnJvciBpbnN0ZWFkIG9mCiAgIHNpbGVudCB0 cnVuY2F0aW9uLCB3aGljaCBpcyBuZWNlc3NhcnkgdG8gYmUgc3RhbmRhcmQtY29uZm9ybWluZy4K CjIuIEl0IHdhcyBwb3NzaWJsZSB0byBlbmQgdXAgd2l0aCBhIGNhc3QgZXhwcmVzc2lvbiB0aGF0 IGRvZXNuJ3QKICAgc3VwcG9ydCBzb2Z0IGhhbmRsaW5nIG9mIGVycm9ycyBjYXVzaW5nIGJ1Z3Mg aW4gdGhlIG9mIGhhbmRsaW5nCiAgIE9OIEVSUk9SIGNsYXVzZS4KCkpzb25FeHByLmNvZXJjaW9u X2V4cHIgd2hpY2ggd291bGQgc3RvcmUgdGhlIGNhc3QgZXhwcmVzc2lvbiBpcyBubwpsb25nZXIg bmVjZXNzYXJ5LCBzbyByZW1vdmUuCgpCdW1wIGNhdHZlcnNpb24gYmVjYXVzZSBzdG9yZWQgcnVs ZXMgY2hhbmdlIGJlY2F1c2Ugb2YgdGhlIGFib3ZlCnJlbW92YWwuCgpSZXBvcnRlZC1ieTogQWx2 YXJvIEhlcnJlcmEgPGFsdmhlcnJlQGFsdmgubm8taXAub3JnPgpSZXZpZXdlZC1ieTogSmlhbiBI ZSA8amlhbi51bml2ZXJzYWxpdHlAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBEaXNjdXNzaW9uOiBo dHRwczovL3Bvc3Rnci5lcy9tLzIwMjQwNTI3MTMyNi41YTVycHJraTY0YXclNDBhbHZoZXJyZS5w Z3NxbAoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5w b3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzcxNmJkMTJkMjJjNTNkMTk0M2Q0MTMwOWYyZGQw NjFlYzYwMWRkNWUKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2V4 ZWN1dG9yL2V4ZWNFeHByLmMgICAgICAgICAgICAgICAgICB8ICA1MiArKy0tLS0tCnNyYy9iYWNr ZW5kL2V4ZWN1dG9yL2V4ZWNFeHBySW50ZXJwLmMgICAgICAgICAgICB8ICA1MSArKystLS0Kc3Jj L2JhY2tlbmQvaml0L2xsdm0vbGx2bWppdF9leHByLmMgICAgICAgICAgICAgIHwgICAyICstCnNy Yy9iYWNrZW5kL25vZGVzL25vZGVGdW5jcy5jICAgICAgICAgICAgICAgICAgICB8ICAxMyArLQpz cmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfZXhwci5jICAgICAgICAgICAgICAgICAgfCAxODggKysr KystLS0tLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2pzb25mdW5jcy5jICAg ICAgICAgICAgICAgIHwgIDQ4ICsrKystLQpzcmMvaW5jbHVkZS9jYXRhbG9nL2NhdHZlcnNpb24u aCAgICAgICAgICAgICAgICAgfCAgIDIgKy0Kc3JjL2luY2x1ZGUvZXhlY3V0b3IvZXhlY0V4cHIu aCAgICAgICAgICAgICAgICAgIHwgICAxICsKc3JjL2luY2x1ZGUvbm9kZXMvZXhlY25vZGVzLmgg ICAgICAgICAgICAgICAgICAgIHwgICA1ICstCnNyYy9pbmNsdWRlL25vZGVzL3ByaW1ub2Rlcy5o ICAgICAgICAgICAgICAgICAgICB8ICAgOCArLQpzcmMvaW5jbHVkZS91dGlscy9qc29uZnVuY3Mu aCAgICAgICAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3Nx bGpzb25fanNvbnRhYmxlLm91dCAgfCAgNTIgKysrLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVj dGVkL3NxbGpzb25fcXVlcnlmdW5jcy5vdXQgfCAgNzIgKysrKysrLS0tCnNyYy90ZXN0L3JlZ3Jl c3Mvc3FsL3NxbGpzb25fanNvbnRhYmxlLnNxbCAgICAgICB8ICAgMiArLQpzcmMvdGVzdC9yZWdy ZXNzL3NxbC9zcWxqc29uX3F1ZXJ5ZnVuY3Muc3FsICAgICAgfCAgMjUgKystCjE1IGZpbGVzIGNo YW5nZWQsIDIxMyBpbnNlcnRpb25zKCspLCAzMDkgZGVsZXRpb25zKC0pCgo= --===============8833525051748671508==--