Skip to main content

regex_position

dbkit_core::func

Function regex_position 

Source 
pub fn regex_position<L, R>(
    expression: impl IntoExpr<L>,
    pattern: impl IntoExpr<R>,
) -> Expr<<L as StringBinaryExpr<R, i32>>::Output>
where
    L: StringBinaryExpr<R, i32>,
Expand description

Returns the 1-based position of the first match, or zero when absent. Requires PostgreSQL 15 or newer. Maps to PostgreSQL REGEXP_INSTR.