Skip to main content

regex_not_match

Function regex_not_match 

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

PostgreSQL !~ operator - case-sensitive regex non-match.

ยงExample

let name = SQL::<PostgresValue>::raw("name");
let cond = regex_not_match(name, "^[0-9]");
assert!(cond.to_sql().sql().contains("!~"));