Re: Document that jsonpath == can be used as ANY

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Document that jsonpath == can be used as ANY
Date: 2026-09-30 18:47:25
Message-ID: CAB-JLwbu07pHwYEzn-2ehJdpmJmraK8rV-ZdMCMc0gCcwV0OLQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Em seg., 17 de ago. de 2026 às 09:04, Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
escreveu:

> Additional example of == operator being used like ANY
>

I insist on this, there is no documentation on how to find an array of
values in a JSON object.

select jsonb_path_query_array('[5,6,7,8,9]', '$[*] ? (@ == $arr)','{"arr":
[2,5,8]}')
-------
[5, 8]

regards
Marcos

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Lakhin 2026-09-30 19:00:00 Re: [PATCH] intXshr, intXshl: return error on shift count out of range
Previous Message Andrey Rachitskiy 2026-09-30 18:35:10 Re: Residual cleanups for tied objects in PL/Perl