Skip to main content

sql_json_path

Function sql_json_path 

Source
pub fn sql_json_path(
    call: &Call<'_>,
    target: &Value,
    path: &Value,
    vars: &[PathVar],
    throw: bool,
    want: bool,
) -> Result<Option<(bool, Vec<SqlJsonItem>)>>
Expand description

executeJsonPath for JSON_EXISTS, JSON_QUERY and JSON_VALUE: whether the path on the jsonb value finds an item, and the items when want is true. The result is None for an error of the path when throw is false. The casts of the datetime values can use the zone of the session.

ยงErrors

The error of the path when throw is true, and the errors that a silent path also gives, such as a variable that PASSING does not have.