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.96) (envelope-from ) id 1wMG4a-002Kvh-38 for pgsql-hackers@arkaria.postgresql.org; Mon, 11 May 2026 02:08:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wMG4Z-00Feba-25 for pgsql-hackers@arkaria.postgresql.org; Mon, 11 May 2026 02:08:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wMG4Z-00FebS-1D for pgsql-hackers@lists.postgresql.org; Mon, 11 May 2026 02:08:43 +0000 Received: from fout-a8-smtp.messagingengine.com ([103.168.172.151]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wMG4X-00000001D0j-0gaJ for pgsql-hackers@postgresql.org; Mon, 11 May 2026 02:08:42 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfout.phl.internal (Postfix) with ESMTP id 22335EC00F4; Sun, 10 May 2026 22:08:41 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-04.internal (MEProxy); Sun, 10 May 2026 22:08:41 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm3; t=1778465321; x=1778551721; bh=EypPMpzI2H 1aVDubhCvgS+ieQ7HMK8S/evGup08BYJk=; b=rbnGnjbhauZ7jc7C0zCj0ReI6L SveoMldq5OhdvnFB34o35nPEInQd872Zk/eX+pvK2ztA3B3SkBSl0BKjiVCAnEd6 aj1I+CGYVyRvlRWAqBzyoAsnFU9DwmxdKayviAaQItm8bHfJEBwwfU3S5CPFJStA cSVFHR26sgoXdz+yA52d+H6A9DzdZ/xt1O3bkmkhbF5UpgeCPy6GM73+0zaTtNhK eYQUPMwlnL9raxQ0vcoO6Fit6RKSCcume5fEGHoPM5u2ZJznwQcdFnOYKoPSytdx t97jmjYjyHYwlXah350BBgJR/HQ+95z+D2CdONJ7bPolNXtqkR3pBJJ+TbIw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1778465321; x=1778551721; bh=EypPMpzI2H1aVDubhCvgS+ieQ7HMK8S/evG up08BYJk=; b=qUeYyALbBeO7jWqWhSKrB7XOCh5hsfiQrBB0UhjueaFQOugcKa5 0u8orPwjZsF4V5kNG1Oifh1sRG7uCU+H86MRwyoXiOrjFDMUpG+TzoskkgxknHc+ eUEqiF6/fluGeDJ5RuwfV7StiCXZ/PkjmPYvoA0X8IM8vMBv3AqULrb1Ci0/uWZQ sy2/WTOTgp7FQ0ABe8D00ynwqP/y1AjL2yuy3fqGKDQq56PgFbdop0StmG+57EAe devnZ9+IDdTG7gZwsJMP+ERIgWetFQ/5Rkwtek9KNEcbS16QfJkL96OK/Nkg/78q m2ucvcioe9CyZeD7HkDCrcSWEawpZxL54Cw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefhedrtddtgdduudejjeegucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegfrh hlucfvnfffucdlfeehmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepgeffjeevgfevuddvjedtvddtieej heduueelvddufedtgfefjedvkeevkeeivddvnecuffhomhgrihhnpehpohhsthhgrhgvsh hqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhr ohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiipdhnsggprhgtphhtthhopedvpd hmohguvgepshhmthhpohhuthdprhgtphhtthhopehmrghrtghoshesfhdutddrtghomhdr sghrpdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrshesphhoshhtghhrvghsqhhlrd horhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 10 May 2026 22:08:39 -0400 (EDT) Date: Mon, 11 May 2026 11:08:36 +0900 From: Michael Paquier To: Marcos Pegoraro Cc: pgsql-hackers Subject: Re: Missing jsonb_ ... functions on DOCs Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="8DtxrSfEVIyVbHvf" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --8DtxrSfEVIyVbHvf Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sun, May 10, 2026 at 01:49:51PM -0300, Marcos Pegoraro wrote: > None of these functions are documented, Is this intentional ? > If not, how can these functions be there ? > An additional table right after operators ? > Just a comment on the correspondent operator ? Well, it seems to me that the intention is that it is pointless to document the functions because that the users need only to be aware of the operators, and the operators are enough to manipulate the jsonb blobs. Documenting the functions would be just duplicating what we already have for the operators, as listed here: https://www.postgresql.org/docs/devel/functions-json.html -- Michael --8DtxrSfEVIyVbHvf Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmoBOiQACgkQnvQgOdby QH3yag//ateYVa0f43saAS9reBkzEjqdTCxxcndN6k0FhVxczMkrLDlFMydjNJyn tIBobycEWFYTQX3rDZMZuVaKg6IueUTzG+2B/fgUDjE+aQxgkpqTYGPY05yJoElK N8ThQ29s6LXW2xmjEbuZbN6Ts75pH7LyHqUUNoCNnoTGup73/lA7bPa8lU+i007U UiSBIgOYlgo0fCJ/9wiDnflw+sgqQ/Ho1fUrn7PUrGwRfFJHLzlyBdG4CVpUsUAg SyA7Ovi45Hk6b55iw7oO180AdxzyXD2/V5sZIrQmzdp0xVeHVfI51hYMNeGQLOCF EhRP3BcHDm5O7dZ9UddGnRxg4OjASz+CRe2un9iPA5WZDzBA30BZN6s+Gp59OSyW /Mel19gnzGZArqQty+BAzVdyQnHby6xE1IRk70iFUWImx/bz33L0nCNW5BBvtKpd b+yGCa8MZIpZzCpwIDu3HCO9D6c25/+Aw8Yxam/5RkTOiP5np2OHkEyrgBUCkGuZ KywJ2y+84aUTPZHjtV2jzqYQISD/l3iIE8ddmTU2x21uGBAHzhd1xJwyylyxEC3d LNK1l2sBklwYHKURQymRewTvePEvmaE9+3dui2nLSEUmh0wnnZQW6iM+w9NAIolC nsySJ06EdxViS9Z4mtsbpN01QuxES5rTKL+aefLsOpLbq2lTr30= =P/2j -----END PGP SIGNATURE----- --8DtxrSfEVIyVbHvf--