​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account

[jian he <jian.universality@xxxxxxxxx>]

Hi,

https://www.postgresql.org/docs/current/functions-json.html

jsonb @@ jsonpath → boolean

Returns the result of a JSON path predicate check for the specified JSON value. Only the first item of the result is taken into account. If the result is not Boolean, then NULL is returned.

'{"a":[1,2,3,4,5]}'::jsonb @@ '$.a[*] > 2' → t


select jsonb_path_query('{"a":[1,2,3,4,5]}',  '$.a[*]');

return

 jsonb_path_query
------------------
 1
 2
 3
 4
 5
(5 rows)

I don't understand: "Only the first item of the result is taken into account.".

Here, JSON path predicate check for the specified JSON value return true, some return false. (1 > 2 is false, 2 > 2 is false).