On Wed, Sep 30, 2026 at 1:22 PM Marcos Pegoraro <[email protected]> wrote:

> Em qua., 30 de set. de 2026 às 16:14, David G. Johnston <
> [email protected]> escreveu:
>
>> I feel like simply including an example here is insufficient.  There
>> isn't anything special about == going on here;
>>
>
> Yes, I agree that an example only is insufficient.
> But the behavior of == is indeed different when it's an array or a scalar
> value.
> It will only work as an array only if assigned to a parameter, and a
> scalar works the same way for both.
>
>
Apparently this is a side-effect of lax mode:

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

produces and empty array: []

So I like the example only patch even less as it doesn't explain at all why
that random example has been included or how/why it works.

Maybe move the example and exposition to 19.6.2.2 ?

David J.

Reply via email to