Skip to main content

jsonb_contains

Function jsonb_contains 

Source
pub fn jsonb_contains<'a, L, R>(
    left: L,
    right: R,
) -> SQLExpr<'a, PostgresValue<'a>, Boolean, NonNull, Scalar>
where L: Expr<'a, PostgresValue<'a>>, R: ToSQL<'a, PostgresValue<'a>>,
Expand description

PostgreSQL @> operator for JSONB - left JSON contains right JSON.

ยงExample

let data = SQL::<PostgresValue>::raw("data");
let cond = jsonb_contains(data, r#"{"key": "value"}"#);
assert!(cond.to_sql().sql().contains("@>"));