Skip to main content

json_get_path

Function json_get_path 

Source
pub fn json_get_path<'a, E>(
    expr: E,
    path: &'a str,
) -> SQLExpr<'a, PostgresValue<'a>, Json, Null, Scalar>
where E: Expr<'a, PostgresValue<'a>>,
Expand description

PostgreSQL #> operator - get JSON object at specified path, returns JSON.

ยงExample

let data = SQL::<PostgresValue>::raw("data");
let nested = json_get_path(data, "{a,b}");
assert!(nested.to_sql().sql().contains("#>"));