Skip to main content

starts_with

Function starts_with 

Source
pub fn starts_with<L, R>(
    expression: impl IntoExpr<L>,
    prefix: impl IntoExpr<R>,
) -> Expr<<L as StringBinaryExpr<R, bool>>::Output>
where L: StringBinaryExpr<R, bool>,
Expand description

Tests whether expression begins with the exact, case-sensitive prefix. Returns NULL if either argument is NULL; starts_with("PostgreSQL", "Post") evaluates to true. Requires PostgreSQL 11 or newer. Maps to PostgreSQL STARTS_WITH.