Skip to main content

position

dbkit_core::func

Function position 

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

Returns the 1-based position of substring in expression, or zero when absent. Returns NULL if either argument is NULL; position("banana", "ana") evaluates to 2. Maps to PostgreSQL STRPOS.