MIME-Version: 1.0
From: Marcos Pegoraro <marcos@f10.com.br>
Date: Sun, 10 May 2026 13:49:51 -0300
Message-ID: 
 <CAB-JLwbPuNY+4Ez48TZpXg-ZuxRSJ_igsNOa-nX7jBEs97qHCQ@mail.gmail.com>
Subject: Missing jsonb_ ... functions on DOCs
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005954890651796dc6"
Archived-At: 
 <https://www.postgresql.org/message-id/CAB-JLwbPuNY%2B4Ez48TZpXg-ZuxRSJ_igsNOa-nX7jBEs97qHCQ%40mail.gmail.com>
Precedence: bulk

--0000000000005954890651796dc6
Content-Type: text/plain; charset="UTF-8"

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 ?

-- jsonb_exists - corresponds to ? operator
select jsonb_exists('{"a":null, "b":"qq"}', 'a');
select '{"a":null, "b":"qq"}'::jsonb ? 'a';

-- jsonb_exists_any - corresponds to ?| operator
select jsonb_exists_any('{"a":null, "b":"qq"}', ARRAY['a','c']);
select '{"a":null, "b":"qq"}'::jsonb ?| ARRAY['a','c'];

-- jsonb_exists_all - corresponds to ?& operator
select jsonb_exists_all('{"a":null, "b":"qq"}', ARRAY['a','b']);
select '{"a":null, "b":"qq"}'::jsonb ?& ARRAY['a','b'];

-- jsonb_contains - corresponds to @> operator
select jsonb_contains('{"a":null, "b":"qq"}', '{"b":"qq"}');
select '{"a":null, "b":"qq"}'::jsonb @> '{"b":"qq"}';

-- jsonb_contained - corresponds to <@ operator
select jsonb_contained('{"b":"qq"}','{"a":null, "b":"qq"}');
select '{"b":"qq"}' <@ '{"a":null, "b":"qq"}'::jsonb;

-- jsonb_concat - corresponds to || operator
select jsonb_concat('{"b":"qq"}','{"a":null}');
select '{"b":"qq"}'::jsonb || '{"a":null}'::jsonb;

-- jsonb_delete - corresponds to - operator
select jsonb_delete('{"b":"qq", "a":null}','b');
select '{"b":"qq", "a":null}'::jsonb - 'b'

-- jsonb_delete_path - corresponds to #- operator
select jsonb_delete_path('{"a":1, "b": {"c": 5, "d":3}}'::jsonb, '{b,c}');
select '{"a":1, "b": {"c": 5, "d":3}}'::jsonb #- '{b,c}';

regards
Marcos

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

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:verdana,=
sans-serif;color:rgb(102,102,102)"><span style=3D"font-family:Arial,Helveti=
ca,sans-serif;color:rgb(34,34,34)">None of these functions are documented, =
Is this intentional ?</span></div>If not, how can these functions be there =
?<div>An additional table right after operators ?</div><div>Just a comment =
on the correspondent operator ?</div><div><br>-- jsonb_exists - corresponds=
 to ? operator</div><div>select jsonb_exists(&#39;{&quot;a&quot;:null, &quo=
t;b&quot;:&quot;qq&quot;}&#39;, &#39;a&#39;);<br>select &#39;{&quot;a&quot;=
:null, &quot;b&quot;:&quot;qq&quot;}&#39;::jsonb ? &#39;a&#39;;<br><br></di=
v><div>-- jsonb_exists_any - corresponds to ?| operator<br>select jsonb_exi=
sts_any(&#39;{&quot;a&quot;:null, &quot;b&quot;:&quot;qq&quot;}&#39;, ARRAY=
[&#39;a&#39;,&#39;c&#39;]);<br>select &#39;{&quot;a&quot;:null, &quot;b&quo=
t;:&quot;qq&quot;}&#39;::jsonb ?| ARRAY[&#39;a&#39;,&#39;c&#39;];<br><br></=
div><div>-- jsonb_exists_all - corresponds to ?&amp; operator<br>select jso=
nb_exists_all(&#39;{&quot;a&quot;:null, &quot;b&quot;:&quot;qq&quot;}&#39;,=
 ARRAY[&#39;a&#39;,&#39;b&#39;]);<br>select &#39;{&quot;a&quot;:null, &quot=
;b&quot;:&quot;qq&quot;}&#39;::jsonb ?&amp; ARRAY[&#39;a&#39;,&#39;b&#39;];=
<br><br></div><div>-- jsonb_contains - corresponds to @&gt; operator<br>sel=
ect jsonb_contains(&#39;{&quot;a&quot;:null, &quot;b&quot;:&quot;qq&quot;}&=
#39;, &#39;{&quot;b&quot;:&quot;qq&quot;}&#39;);<br>select &#39;{&quot;a&qu=
ot;:null, &quot;b&quot;:&quot;qq&quot;}&#39;::jsonb @&gt; &#39;{&quot;b&quo=
t;:&quot;qq&quot;}&#39;;<br><br></div><div>-- jsonb_contained - corresponds=
 to &lt;@ operator<br>select jsonb_contained(&#39;{&quot;b&quot;:&quot;qq&q=
uot;}&#39;,&#39;{&quot;a&quot;:null, &quot;b&quot;:&quot;qq&quot;}&#39;);<b=
r>select &#39;{&quot;b&quot;:&quot;qq&quot;}&#39; &lt;@ &#39;{&quot;a&quot;=
:null, &quot;b&quot;:&quot;qq&quot;}&#39;::jsonb;<br><br></div><div>-- json=
b_concat - corresponds to || operator<br>select jsonb_concat(&#39;{&quot;b&=
quot;:&quot;qq&quot;}&#39;,&#39;{&quot;a&quot;:null}&#39;);<br>select &#39;=
{&quot;b&quot;:&quot;qq&quot;}&#39;::jsonb || &#39;{&quot;a&quot;:null}&#39=
;::jsonb;<br><br></div><div>-- jsonb_delete - corresponds to - operator<br>=
select jsonb_delete(&#39;{&quot;b&quot;:&quot;qq&quot;, &quot;a&quot;:null}=
&#39;,&#39;b&#39;);<br>select &#39;{&quot;b&quot;:&quot;qq&quot;, &quot;a&q=
uot;:null}&#39;::jsonb - &#39;b&#39;<br><br></div><div>-- jsonb_delete_path=
 - corresponds to #- operator<br>select jsonb_delete_path(&#39;{&quot;a&quo=
t;:1, &quot;b&quot;: {&quot;c&quot;: 5, &quot;d&quot;:3}}&#39;::jsonb, &#39=
;{b,c}&#39;);<br>select &#39;{&quot;a&quot;:1, &quot;b&quot;: {&quot;c&quot=
;: 5, &quot;d&quot;:3}}&#39;::jsonb #- &#39;{b,c}&#39;<span class=3D"gmail_=
default" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">;<=
/span></div><div><font color=3D"#666666" face=3D"verdana, sans-serif"><br><=
/font>regards<br>Marcos<br><br></div></div>

--0000000000005954890651796dc6--