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 1vElHm-00HW87-I3 for pgsql-docs@arkaria.postgresql.org; Fri, 31 Oct 2025 09:19:06 +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 1vElHl-00DM1q-Fq for pgsql-docs@arkaria.postgresql.org; Fri, 31 Oct 2025 09:19:04 +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 1vERaY-008APb-Ck for pgsql-docs@lists.postgresql.org; Thu, 30 Oct 2025 12:17:09 +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.96) (envelope-from ) id 1vERaU-00544o-2U for pgsql-docs@lists.postgresql.org; Thu, 30 Oct 2025 12:17:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=3tqHrhHvvv3VtZDSKpY+98TQWelWJf6U8kgYaRedpJQ=; b=npzH/ToJ6FBBJ/nowv6UD/Fsht OyJCfn1A385Yhg58NtniBWm5apaccVaweEdV/kM02mm4S9pSdSXkj/n+3QW0MrHSX53xMK1HzdbsL wtUIdarYtQNeh1Brof23kOEIJIE9J+DJrvCOsgRSwRx+Y7FfS/YiRfFcgdZpsWPW9ydeqQ0IsseYc Wf0LVLZhpfJIAlsf3a1ps48jlKHJk2A7mud+npAu3SYnUaGW5AoUL44wn7NkSYK3dvTu01SI+Idat l9/AGempCLkEHE9dowCuI5P3V8Reh6mtNYJzmgDLCQ9Xyl1Xk4PaQ6m67HkNZLoHxFJGPOsu/aNwI /nsYRrmw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vERaU-007SIp-II for pgsql-docs@lists.postgresql.org; Thu, 30 Oct 2025 12:17:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vERaR-002CZQ-1O for pgsql-docs@lists.postgresql.org; Thu, 30 Oct 2025 12:17:03 +0000 Content-Type: multipart/mixed; boundary="===============4394963179844824933==" MIME-Version: 1.0 Subject: Implicit type conversion for json/jsonb To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: russell.foster.coding@gmail.com Reply-To: russell.foster.coding@gmail.com, pgsql-docs@lists.postgresql.org Date: Thu, 30 Oct 2025 12:16:48 +0000 Message-ID: <176182660867.770.7493759479585273126@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4394963179844824933== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xOC90eXBl Y29udi1vdmVydmlldy5odG1sCkRlc2NyaXB0aW9uOgoKSGVsbG8sIEknbSB0cnlpbmcgdG8gdW5k ZXJzdGFuZCBob3cganNvbi9qc29uYiBpcyBpbXBsaWNpdGx5IGNvbnZlcnRlZCBpbgpJTlNFUlQg YW5kIFVQREFURSBxdWVyaWVzLgoKSW4gc2VjdGlvbiAiMTAuMS4gT3ZlcnZpZXciIHRoZXJlIGlz IHRoZSBmb2xsb3dpbmc6CgpJZiBhIHR5cGUgaXMgbm90IHNwZWNpZmllZCBmb3IgYSBzdHJpbmcg bGl0ZXJhbCwgdGhlbiB0aGUgcGxhY2Vob2xkZXIgdHlwZQp1bmtub3duIGlzIGFzc2lnbmVkIGlu aXRpYWxseSwgdG8gYmUgcmVzb2x2ZWQgaW4gbGF0ZXIgc3RhZ2VzIGFzIGRlc2NyaWJlZApiZWxv dy4KClZhbHVlIFN0b3JhZ2UKClNRTCBJTlNFUlQgYW5kIFVQREFURSBzdGF0ZW1lbnRzIHBsYWNl IHRoZSByZXN1bHRzIG9mIGV4cHJlc3Npb25zIGludG8gYQp0YWJsZS4gVGhlIGV4cHJlc3Npb25z IGluIHRoZSBzdGF0ZW1lbnQgbXVzdCBiZSBtYXRjaGVkIHVwIHdpdGgsIGFuZCBwZXJoYXBzCmNv bnZlcnRlZCB0bywgdGhlIHR5cGVzIG9mIHRoZSB0YXJnZXQgY29sdW1ucy4KLS0tCgpJbiBzZWN0 aW9uICIxMC40LiBWYWx1ZSBTdG9yYWdlIiB0aGVyZSBpczoKClZhbHVlIFN0b3JhZ2UgVHlwZSBD b252ZXJzaW9uCgoxLiBDaGVjayBmb3IgYW4gZXhhY3QgbWF0Y2ggd2l0aCB0aGUgdGFyZ2V0LgoK Mi4gT3RoZXJ3aXNlLCB0cnkgdG8gY29udmVydCB0aGUgZXhwcmVzc2lvbiB0byB0aGUgdGFyZ2V0 IHR5cGUuIFRoaXMgaXMKcG9zc2libGUgaWYgYW4gYXNzaWdubWVudCBjYXN0IGJldHdlZW4gdGhl IHR3byB0eXBlcyBpcyByZWdpc3RlcmVkIGluIHRoZQpwZ19jYXN0IGNhdGFsb2cgKHNlZSBDUkVB VEUgQ0FTVCkuIEFsdGVybmF0aXZlbHksIGlmIHRoZSBleHByZXNzaW9uIGlzIGFuCnVua25vd24t dHlwZSBsaXRlcmFsLCB0aGUgY29udGVudHMgb2YgdGhlIGxpdGVyYWwgc3RyaW5nIHdpbGwgYmUg ZmVkIHRvIHRoZQppbnB1dCBjb252ZXJzaW9uIHJvdXRpbmUgZm9yIHRoZSB0YXJnZXQgdHlwZS4K CjMuIENoZWNrIHRvIHNlZSBpZiB0aGVyZSBpcyBhIHNpemluZyBjYXN0IGZvciB0aGUgdGFyZ2V0 IHR5cGUuIEEgc2l6aW5nIGNhc3QKaXMgYSBjYXN0IGZyb20gdGhhdCB0eXBlIHRvIGl0c2VsZi4g SWYgb25lIGlzIGZvdW5kIGluIHRoZSBwZ19jYXN0IGNhdGFsb2csCmFwcGx5IGl0IHRvIHRoZSBl eHByZXNzaW9uIGJlZm9yZSBzdG9yaW5nIGludG8gdGhlIGRlc3RpbmF0aW9uIGNvbHVtbi4gVGhl CmltcGxlbWVudGF0aW9uIGZ1bmN0aW9uIGZvciBzdWNoIGEgY2FzdCBhbHdheXMgdGFrZXMgYW4g ZXh0cmEgcGFyYW1ldGVyIG9mCnR5cGUgaW50ZWdlciwgd2hpY2ggcmVjZWl2ZXMgdGhlIGRlc3Rp bmF0aW9uIGNvbHVtbidzIGF0dHR5cG1vZCB2YWx1ZQoodHlwaWNhbGx5IGl0cyBkZWNsYXJlZCBs ZW5ndGgsIGFsdGhvdWdoIHRoZSBpbnRlcnByZXRhdGlvbiBvZiBhdHR0eXBtb2QKdmFyaWVzIGZv ciBkaWZmZXJlbnQgZGF0YSB0eXBlcyksIGFuZCBpdCBtYXkgdGFrZSBhIHRoaXJkIGJvb2xlYW4g cGFyYW1ldGVyCnRoYXQgc2F5cyB3aGV0aGVyIHRoZSBjYXN0IGlzIGV4cGxpY2l0IG9yIGltcGxp Y2l0LiBUaGUgY2FzdCBmdW5jdGlvbiBpcwpyZXNwb25zaWJsZSBmb3IgYXBwbHlpbmcgYW55IGxl bmd0aC1kZXBlbmRlbnQgc2VtYW50aWNzIHN1Y2ggYXMgc2l6ZQpjaGVja2luZyBvciB0cnVuY2F0 aW9uLgotLS0tCgpJIHVzZWQgdGhlIGZvbGxvd2luZyBzcWwgdG8gdGVzdCBvdXQganNvbmIgdGhy b3VnaCBwZyBhZG1pbgoKRFJPUCBUQUJMRSBJRiBFWElTVFMganNvbmJfdGVzdDsKCkNSRUFURSBU QUJMRSBqc29uYl90ZXN0CigKICAgICAgICBkYXRhIGpzb25iCik7CgpJTlNFUlQgSU5UTyBqc29u Yl90ZXN0IFZBTFVFUyAoJ3sgImEiOiAiMSIsICJiIjogIjIiIH0nKTsKCklOU0VSVCBJTlRPIGpz b25iX3Rlc3QgVkFMVUVTICgneyAiYSI6ICIxIiwgImIiOiAiMiIgfSc6OnVua25vd24pOwoKLS0g VGhpcyBmYWlscyB0byBpbnNlcnQgd2l0aCAiY29sdW1uICJkYXRhIiBpcyBvZiB0eXBlIGpzb25i IGJ1dCBleHByZXNzaW9uCmlzIG9mIHR5cGUgdGV4dCIKLS0gSU5TRVJUIElOVE8ganNvbmJfdGVz dCBWQUxVRVMgKCd7ICJhIjogIjEiLCAiJyB8fCAnYiI6ICIyIiB9Jyk7CgotLSBUaGlzIGZhaWxl ZCB0byBpbnNlcnQgd2l0aCAiZmFpbGVkIHRvIGZpbmQgY29udmVyc2lvbiBmdW5jdGlvbiBmcm9t CnVua25vd24gdG8ganNvbmIiCi0tIElOU0VSVCBJTlRPIGpzb25iX3Rlc3QgVkFMVUVTICgoJ3sg ImEiOiAiMSIsJyB8fCAnImIiOiAiMiIgfScpOjp1bmtub3duKTsKClNvIGJhc2VkIG9uIHRoZSBk b2NzLCBteSB1bmRlcnN0YW5kaW5nIGlzIHRoYXQgdGhlIGZpcnN0IElOU0VSVCBpcyBhc3NpZ25l ZAphcyAidW5rbm93biIsIGFuZCB0aGVyZSBpcyBhbiBpbXBsaWNpdCBjb252ZXJzaW9uIGZyb20g InVua25vd24iIHRvICJqc29uYiIuCkkgY2FuIHNlZSB0aGF0IGNhc3RpbmcgdG8gInVua25vd24i IHdvcmtzIGFzIHdlbGwgaW4gdGhlIHNlY29uZCBJTlNFUlQuIFRoZQp0aGlyZCBJTlNFUlQgZmFp bHMgYmVjYXVzZSB0aGVyZSBpcyBubyBpbXBsaWNpdCBjYXN0IGZyb20gdGV4dCB0byBqc29uYi4g QnV0CmlmIGV4cGxpY2l0bHkgY2FzdCB0ZXh0IHRvICJ1bmtub3duIiBhcyBpbiB0aGUgbGFzdCBJ TlNFUlQsIEkgZ2V0IGFuIGVycm9yLgpJcyBteSB1bmRlcnN0YW5kaW5nIGNvcnJlY3Q/IElmIHNv LCBob3cgZG8gdGhlIGNvbnZlcnNpb24gcnVsZXMgZXhwbGFpbiB0aGUKbGFzdCBJTlNFUlQ/Cg== --===============4394963179844824933==--