Skip to main content

split_part

dbkit_core::func

Function split_part 

Source 
pub fn split_part<S, D>(
    expression: impl IntoExpr<S>,
    delimiter: impl IntoExpr<D>,
    index: impl IntoExpr<i32>,
) -> Expr<<S as StringBinaryExpr<D, String>>::Output>
where
    S: StringBinaryExpr<D, String>,
Expand description

Returns the 1-based field from a delimited string. Negative indexes count from the end on PostgreSQL 14 or newer. PostgreSQL rejects an index of zero and returns an empty string for an out-of-range index. Maps to PostgreSQL SPLIT_PART.