Skip to main content

jsonb_exists_all

Function jsonb_exists_all 

Source
pub fn jsonb_exists_all<'a, E>(
    expr: E,
    keys: &[&'a str],
) -> SQLExpr<'a, PostgresValue<'a>, Boolean, NonNull, Scalar>
where E: Expr<'a, PostgresValue<'a>>,
Expand description

PostgreSQL ?& operator for JSONB - do all of the keys exist?

ยงExample

let data = SQL::<PostgresValue>::raw("data");
let cond = jsonb_exists_all(data, &["name", "email"]);
assert!(cond.to_sql().sql().contains("?&"));