MIME-Version: 1.0
References: 
 <CAB-JLwbPuNY+4Ez48TZpXg-ZuxRSJ_igsNOa-nX7jBEs97qHCQ@mail.gmail.com>
 <agE6JF1AvxKL0anI@paquier.xyz>
 <CAB-JLwb+m=gspBheMGWq9TCPqgD70K30AQ3bNxPzg3KBsym2Bg@mail.gmail.com>
 <2077214.1778512784@sss.pgh.pa.us>
In-Reply-To: <2077214.1778512784@sss.pgh.pa.us>
From: Marcos Pegoraro <marcos@f10.com.br>
Date: Mon, 11 May 2026 15:33:08 -0300
Message-ID: 
 <CAB-JLwZLitbYDPa8zU5=tb+9t5eXA6Cq8qE5uSEbM9=x2ebVDQ@mail.gmail.com>
Subject: Re: Missing jsonb_ ... functions on DOCs
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Michael Paquier <michael@paquier.xyz>,
 pgsql-hackers <pgsql-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009c6cb906518efc10"
Archived-At: 
 <https://www.postgresql.org/message-id/CAB-JLwZLitbYDPa8zU5%3Dtb%2B9t5eXA6Cq8qE5uSEbM9%3Dx2ebVDQ%40mail.gmail.com>
Precedence: bulk

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

Em seg., 11 de mai. de 2026 =C3=A0s 12:19, Tom Lane <tgl@sss.pgh.pa.us> esc=
reveu:

> There are circa 800 entries in pg_operator (and that's just for the core
> code).
>

It is precisely because of this number of operators that I would like to
document the functions related to them.
When you read SQL and there is an operator, you need to think, "Did I use
the right operator? I'll check the documentation to see if that's the one."
If I use a word, I have no doubt. The word Diff is completely different
than the word Equal, but the operator !=3D is very similar to the operator =
=3D

Maybe we can find a way to have both on DOCs.
Maybe put function name just after operator definition
jsonb @> jsonb =E2=86=92 boolean (jsonb_contains())
Maybe a tooltip on that operator.

I don't know how, but from a user's point of view, I know that not
documenting isn't the best approach.

regards
Marcos

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

<div dir=3D"ltr"><div dir=3D"ltr"><div>Em seg., 11 de mai. de 2026 =C3=A0s =
12:19, Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us<=
/a>&gt; escreveu:</div></div><div class=3D"gmail_quote gmail_quote_containe=
r"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex"><span class=3D"gmail_d=
efault" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)"></s=
pan>There are circa<span class=3D"gmail_default" style=3D"font-family:verda=
na,sans-serif;color:rgb(102,102,102)">=C2=A0</span>800 entries in pg_operat=
or (and that&#39;s just for the core code).<br></blockquote><div><br></div>=
<div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;color:=
rgb(102,102,102)">It is precisely because of this number of operators that =
I would like to document the functions related to them.=C2=A0</div><div cla=
ss=3D"gmail_default" style=3D"font-family:verdana,sans-serif;color:rgb(102,=
102,102)">When you read SQL and there is an operator, you need to think, &q=
uot;Did I use the right operator? I&#39;ll check the documentation to see i=
f that&#39;s the one.&quot;=C2=A0</div><div class=3D"gmail_default" style=
=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">If I use a word,=
 I have no doubt. The word Diff is completely different than the word Equal=
, but the operator !=3D is very similar to the operator =3D</div><div class=
=3D"gmail_default" style=3D"font-family:verdana,sans-serif;color:rgb(102,10=
2,102)"><br></div><div class=3D"gmail_default" style=3D"font-family:verdana=
,sans-serif;color:rgb(102,102,102)">Maybe we can find a way to have both on=
 DOCs.</div><div class=3D"gmail_default" style=3D"font-family:verdana,sans-=
serif;color:rgb(102,102,102)">Maybe put function name just after operator d=
efinition<br>jsonb @&gt; jsonb =E2=86=92 boolean (jsonb_contains())</div><d=
iv class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;color:rg=
b(102,102,102)">Maybe a tooltip on that operator.</div><div class=3D"gmail_=
default" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)"><b=
r></div><div class=3D"gmail_default" style=3D"font-family:verdana,sans-seri=
f;color:rgb(102,102,102)">I don&#39;t know how, but from a user&#39;s point=
 of view, I know that not documenting isn&#39;t the best approach.</div><di=
v 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)">regards</div><div class=3D"gmail=
_default" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">M=
arcos</div></div></div>

--0000000000009c6cb906518efc10--