risingwave_expr_impl::scalar::jsonb_path

Function jsonb_path_query_array4

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

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

ยงExamples

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