risingwave_expr_impl::scalar::jsonb_path

Function jsonb_path_query4

Source 
fn jsonb_path_query4<'a>(
    target: JsonbRef<'a>,
    vars: JsonbRef<'a>,
    silent: bool,
    path: &JsonPath,
) -> Result<Option<impl Iterator<Item = JsonbVal> + 'a>>
Expand description

Returns all JSON items returned by the JSON path for the specified JSON value. The optional vars and silent arguments act the same as for jsonb_path_exists.

ยงExamples

query I
select * from jsonb_path_query(jsonb '{"a":[1,2,3,4,5]}', '$.a[*] ? (@ >= $min && @ <= $max)', jsonb '{"min":2, "max":4}');
----
2
3
4