Hi,
wanted to share the below case:
‘postgres[146443]=#’SELECT JSON_EXISTS(jsonb '{"customer_name": "test", "salary":1000, "department_id":1}', '$.* ? (@== $dept_id && @ == $sal)' PASSING 1000 AS sal, 1 as dept_id);
json_exists
-------------
f
(1 row)
isn't it supposed to return "true" as json in input is matching with both the condition dept_id and salary?
--