Request a Demo
Home   >   mailing lists

Re: Document that jsonpath == can be used as ANY - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Re: Document that jsonpath == can be used as ANY
Date
Msg-id CAB-JLwbu07pHwYEzn-2ehJdpmJmraK8rV-ZdMCMc0gCcwV0OLQ@mail.gmail.com
Whole thread
Responses Re: Document that jsonpath == can be used as ANY
List pgsql-hackers
Tree view
Em seg., 17 de ago. de 2026 às 09:04, Marcos Pegoraro <marcos@f10.com.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

pgsql-hackers by date:

Previous
From: Andrey Rachitskiy
Date:
Subject: Re: Residual cleanups for tied objects in PL/Perl
Next
From: Alexander Lakhin
Date:
Subject: Re: [PATCH] intXshr, intXshl: return error on shift count out of range