risingwave_expr_impl::scalar::jsonb_path

Function jsonb_path_match4

Source 
fn jsonb_path_match4(
    target: JsonbRef<'_>,
    vars: JsonbRef<'_>,
    silent: bool,
    path: &JsonPath,
) -> Result<Option<bool>>
Expand description

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. The optional vars and silent arguments act the same as for jsonb_path_exists.

ยงExamples

query B
select jsonb_path_match('{"a":[1,2,3,4,5]}', 'exists($.a[*] ? (@ >= $min && @ <= $max))', '{"min":2, "max":4}');
----
t