MIME-Version: 1.0
References: 
 <CAB-JLwbPuNY+4Ez48TZpXg-ZuxRSJ_igsNOa-nX7jBEs97qHCQ@mail.gmail.com>
 <agE6JF1AvxKL0anI@paquier.xyz>
In-Reply-To: <agE6JF1AvxKL0anI@paquier.xyz>
From: Marcos Pegoraro <marcos@f10.com.br>
Date: Mon, 11 May 2026 12:07:33 -0300
Message-ID: 
 <CAB-JLwb+m=gspBheMGWq9TCPqgD70K30AQ3bNxPzg3KBsym2Bg@mail.gmail.com>
Subject: Re: Missing jsonb_ ... functions on DOCs
To: Michael Paquier <michael@paquier.xyz>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Content-Type: multipart/mixed; boundary="00000000000064ffff06518c1d6b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAB-JLwb%2Bm%3DgspBheMGWq9TCPqgD70K30AQ3bNxPzg3KBsym2Bg%40mail.gmail.com>
Precedence: bulk

--00000000000064ffff06518c1d6b
Content-Type: multipart/alternative; boundary="00000000000064fffe06518c1d69"

--00000000000064fffe06518c1d69
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Em dom., 10 de mai. de 2026 =C3=A0s 23:08, Michael Paquier <michael@paquier=
.xyz>
escreveu:

> 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


A function is self explanatory, an operator is not.

If we do something like what was done in [1], we don't change much on the
page but at the same time we give the user both options.

regards
Marcos

[1] -
https://www.postgresql.org/docs/18/functions-string.html#FUNCTIONS-STRING-O=
THER

--00000000000064fffe06518c1d69
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>Em dom., 10 de mai. de 2026 =C3=A0s =
23:08, Michael Paquier &lt;<a href=3D"mailto:michael@paquier.xyz">michael@p=
aquier.xyz</a>&gt; escreveu:</div></div><div class=3D"gmail_quote gmail_quo=
te_container"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px=
 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Well, it se=
ems to me that the intention is that it is pointless to<br>
document the functions because that the users need only to be aware of<br>
the operators, and the operators are enough to manipulate the jsonb<br>
blobs.=C2=A0 Documenting the functions would be just duplicating what we<br=
>
already have for the operators, as listed here:<br>
<a href=3D"https://www.postgresql.org/docs/devel/functions-json.html" rel=
=3D"noreferrer" target=3D"_blank">https://www.postgresql.org/docs/devel/fun=
ctions-json.html</a></blockquote><div><br></div><div class=3D"gmail_default=
" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">A functio=
n is self explanatory, an operator is not.</div><div class=3D"gmail_default=
" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)"><br></div=
><div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;color=
:rgb(102,102,102)">If we do something like what was done in [1], we don&#39=
;t change much on the page but at the same time we give the user both optio=
ns.</div><div class=3D"gmail_default" style=3D"font-family:verdana,sans-ser=
if;color:rgb(102,102,102)"><br></div><div class=3D"gmail_default" style=3D"=
font-family:verdana,sans-serif;color:rgb(102,102,102)">regards</div><div cl=
ass=3D"gmail_default" style=3D"font-family:verdana,sans-serif;color:rgb(102=
,102,102)">Marcos</div><div class=3D"gmail_default" style=3D"font-family:ve=
rdana,sans-serif;color:rgb(102,102,102)"><br></div><div class=3D"gmail_defa=
ult" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">[1] - =
<a href=3D"https://www.postgresql.org/docs/18/functions-string.html#FUNCTIO=
NS-STRING-OTHER">https://www.postgresql.org/docs/18/functions-string.html#F=
UNCTIONS-STRING-OTHER</a></div></div></div>

--00000000000064fffe06518c1d69--

--00000000000064ffff06518c1d6b
Content-Type: application/octet-stream;
	name="DOC jsonb functions with their related operators.diff"
Content-Disposition: attachment;
	filename="DOC jsonb functions with their related operators.diff"
Content-Transfer-Encoding: base64
Content-ID: <f_mp1c3szl0>
X-Attachment-Id: f_mp1c3szl0

RnJvbSAzYjZmZDlmZmJkZDNkMzAxYzVlMzZlZTc5YWM3MTJjZTQ5MTY3NGU3IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBQZWdvcmFyb0YxMCA8bWFyY29zQGYxMC5jb20uYnI+CkRhdGU6
IE1vbiwgMTEgTWF5IDIwMjYgMTE6NTg6MjggLTAzMDAKU3ViamVjdDogW1BBVENIXSBBZGRlZCB0
byBET0MganNvbmIgZnVuY3Rpb25zIHRvIHRoZWlyIGVxdWl2YWxlbnQgb3BlcmF0b3JzCgotLS0K
IGRvYy9zcmMvc2dtbC9mdW5jL2Z1bmMtanNvbi5zZ21sIHwgMjQgKysrKysrKysrKysrKysrKysr
KysrKysrCiAxIGZpbGUgY2hhbmdlZCwgMjQgaW5zZXJ0aW9ucygrKQoKZGlmZiAtLWdpdCBhL2Rv
Yy9zcmMvc2dtbC9mdW5jL2Z1bmMtanNvbi5zZ21sIGIvZG9jL3NyYy9zZ21sL2Z1bmMvZnVuYy1q
c29uLnNnbWwKaW5kZXggM2Q5N2UyYjUzNzUuLmZmZTgxYjcwYTJjIDEwMDY0NAotLS0gYS9kb2Mv
c3JjL3NnbWwvZnVuYy9mdW5jLWpzb24uc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvZnVuYy9mdW5j
LWpzb24uc2dtbApAQCAtMjc1LDYgKzI3NSw5IEBACiAgICAgICAgIERvZXMgdGhlIGZpcnN0IEpT
T04gdmFsdWUgY29udGFpbiB0aGUgc2Vjb25kPwogICAgICAgICAoU2VlIDx4cmVmIGxpbmtlbmQ9
Impzb24tY29udGFpbm1lbnQiLz4gZm9yIGRldGFpbHMgYWJvdXQgY29udGFpbm1lbnQuKQogICAg
ICAgIDwvcGFyYT4KKyAgICAgICA8cGFyYT4KKyAgICAgICAgRXF1aXZhbGVudCB0byB0aGUgPGZ1
bmN0aW9uPmpzb25iX2NvbnRhaW5zKCk8L2Z1bmN0aW9uPiBmdW5jdGlvbi4KKyAgICAgICA8L3Bh
cmE+CiAgICAgICAgPHBhcmE+CiAgICAgICAgIDxsaXRlcmFsPid7ImEiOjEsICJiIjoyfSc6Ompz
b25iICYjNjQ7Jmd0OyAneyJiIjoyfSc6Ompzb25iPC9saXRlcmFsPgogICAgICAgICA8cmV0dXJu
dmFsdWU+dDwvcmV0dXJudmFsdWU+CkBAIC0yODksNiArMjkyLDkgQEAKICAgICAgICA8cGFyYT4K
ICAgICAgICAgSXMgdGhlIGZpcnN0IEpTT04gdmFsdWUgY29udGFpbmVkIGluIHRoZSBzZWNvbmQ/
CiAgICAgICAgPC9wYXJhPgorICAgICAgIDxwYXJhPgorICAgICAgICBFcXVpdmFsZW50IHRvIHRo
ZSA8ZnVuY3Rpb24+anNvbmJfY29udGFpbmVkKCk8L2Z1bmN0aW9uPiBmdW5jdGlvbi4KKyAgICAg
ICA8L3BhcmE+CiAgICAgICAgPHBhcmE+CiAgICAgICAgIDxsaXRlcmFsPid7ImIiOjJ9Jzo6anNv
bmIgJmx0O0AgJ3siYSI6MSwgImIiOjJ9Jzo6anNvbmI8L2xpdGVyYWw+CiAgICAgICAgIDxyZXR1
cm52YWx1ZT50PC9yZXR1cm52YWx1ZT4KQEAgLTMwNCw2ICszMTAsOSBAQAogICAgICAgICBEb2Vz
IHRoZSB0ZXh0IHN0cmluZyBleGlzdCBhcyBhIHRvcC1sZXZlbCBrZXkgb3IgYXJyYXkgZWxlbWVu
dCB3aXRoaW4KICAgICAgICAgdGhlIEpTT04gdmFsdWU/CiAgICAgICAgPC9wYXJhPgorICAgICAg
IDxwYXJhPgorICAgICAgICBFcXVpdmFsZW50IHRvIHRoZSA8ZnVuY3Rpb24+anNvbmJfZXhpc3Rz
KCk8L2Z1bmN0aW9uPiBmdW5jdGlvbi4KKyAgICAgICA8L3BhcmE+CiAgICAgICAgPHBhcmE+CiAg
ICAgICAgIDxsaXRlcmFsPid7ImEiOjEsICJiIjoyfSc6Ompzb25iID8gJ2InPC9saXRlcmFsPgog
ICAgICAgICA8cmV0dXJudmFsdWU+dDwvcmV0dXJudmFsdWU+CkBAIC0zMjMsNiArMzMyLDkgQEAK
ICAgICAgICAgRG8gYW55IG9mIHRoZSBzdHJpbmdzIGluIHRoZSB0ZXh0IGFycmF5IGV4aXN0IGFz
IHRvcC1sZXZlbCBrZXlzIG9yCiAgICAgICAgIGFycmF5IGVsZW1lbnRzPwogICAgICAgIDwvcGFy
YT4KKyAgICAgICA8cGFyYT4KKyAgICAgICAgRXF1aXZhbGVudCB0byB0aGUgPGZ1bmN0aW9uPmpz
b25iX2V4aXN0c19hbnkoKTwvZnVuY3Rpb24+IGZ1bmN0aW9uLgorICAgICAgIDwvcGFyYT4KICAg
ICAgICA8cGFyYT4KICAgICAgICAgPGxpdGVyYWw+J3siYSI6MSwgImIiOjIsICJjIjozfSc6Ompz
b25iID98IGFycmF5WydiJywgJ2QnXTwvbGl0ZXJhbD4KICAgICAgICAgPHJldHVybnZhbHVlPnQ8
L3JldHVybnZhbHVlPgpAQCAtMzM4LDYgKzM1MCw5IEBACiAgICAgICAgIERvIGFsbCBvZiB0aGUg
c3RyaW5ncyBpbiB0aGUgdGV4dCBhcnJheSBleGlzdCBhcyB0b3AtbGV2ZWwga2V5cyBvcgogICAg
ICAgICBhcnJheSBlbGVtZW50cz8KICAgICAgICA8L3BhcmE+CisgICAgICAgPHBhcmE+CisgICAg
ICAgIEVxdWl2YWxlbnQgdG8gdGhlIDxmdW5jdGlvbj5qc29uYl9leGlzdHNfYWxsKCk8L2Z1bmN0
aW9uPiBmdW5jdGlvbi4KKyAgICAgICA8L3BhcmE+CiAgICAgICAgPHBhcmE+CiAgICAgICAgIDxs
aXRlcmFsPidbImEiLCAiYiIsICJjIl0nOjpqc29uYiA/JmFtcDsgYXJyYXlbJ2EnLCAnYiddPC9s
aXRlcmFsPgogICAgICAgICA8cmV0dXJudmFsdWU+dDwvcmV0dXJudmFsdWU+CkBAIC0zNjAsNiAr
Mzc1LDkgQEAKICAgICAgICAgRG9lcyBub3Qgb3BlcmF0ZSByZWN1cnNpdmVseTogb25seSB0aGUg
dG9wLWxldmVsIGFycmF5IG9yIG9iamVjdAogICAgICAgICBzdHJ1Y3R1cmUgaXMgbWVyZ2VkLgog
ICAgICAgIDwvcGFyYT4KKyAgICAgICA8cGFyYT4KKyAgICAgICAgRXF1aXZhbGVudCB0byB0aGUg
PGZ1bmN0aW9uPmpzb25iX2NvbmNhdCgpPC9mdW5jdGlvbj4gZnVuY3Rpb24uCisgICAgICAgPC9w
YXJhPgogICAgICAgIDxwYXJhPgogICAgICAgICA8bGl0ZXJhbD4nWyJhIiwgImIiXSc6Ompzb25i
IHx8ICdbImEiLCAiZCJdJzo6anNvbmI8L2xpdGVyYWw+CiAgICAgICAgIDxyZXR1cm52YWx1ZT5b
ImEiLCAiYiIsICJhIiwgImQiXTwvcmV0dXJudmFsdWU+CkBAIC0zOTUsNiArNDEzLDkgQEAKICAg
ICAgICAgRGVsZXRlcyBhIGtleSAoYW5kIGl0cyB2YWx1ZSkgZnJvbSBhIEpTT04gb2JqZWN0LCBv
ciBtYXRjaGluZyBzdHJpbmcKICAgICAgICAgdmFsdWUocykgZnJvbSBhIEpTT04gYXJyYXkuCiAg
ICAgICAgPC9wYXJhPgorICAgICAgIDxwYXJhPgorICAgICAgICBFcXVpdmFsZW50IHRvIHRoZSA8
ZnVuY3Rpb24+anNvbmJfZGVsZXRlKCk8L2Z1bmN0aW9uPiBmdW5jdGlvbi4KKyAgICAgICA8L3Bh
cmE+CiAgICAgICAgPHBhcmE+CiAgICAgICAgIDxsaXRlcmFsPid7ImEiOiAiYiIsICJjIjogImQi
fSc6Ompzb25iIC0gJ2EnPC9saXRlcmFsPgogICAgICAgICA8cmV0dXJudmFsdWU+eyJjIjogImQi
fTwvcmV0dXJudmFsdWU+CkBAIC00NDQsNiArNDY1LDkgQEAKICAgICAgICAgRGVsZXRlcyB0aGUg
ZmllbGQgb3IgYXJyYXkgZWxlbWVudCBhdCB0aGUgc3BlY2lmaWVkIHBhdGgsIHdoZXJlIHBhdGgK
ICAgICAgICAgZWxlbWVudHMgY2FuIGJlIGVpdGhlciBmaWVsZCBrZXlzIG9yIGFycmF5IGluZGV4
ZXMuCiAgICAgICAgPC9wYXJhPgorICAgICAgIDxwYXJhPgorICAgICAgICBFcXVpdmFsZW50IHRv
IHRoZSA8ZnVuY3Rpb24+anNvbmJfZGVsZXRlX3BhdGgoKTwvZnVuY3Rpb24+IGZ1bmN0aW9uLgor
ICAgICAgIDwvcGFyYT4KICAgICAgICA8cGFyYT4KICAgICAgICAgPGxpdGVyYWw+J1siYSIsIHsi
YiI6MX1dJzo6anNvbmIgIy0gJ3sxLGJ9JzwvbGl0ZXJhbD4KICAgICAgICAgPHJldHVybnZhbHVl
PlsiYSIsIHt9XTwvcmV0dXJudmFsdWU+Ci0tIAoyLjUxLjIud2luZG93cy4xCgo=
--00000000000064ffff06518c1d6b--