Function diesel::pg::expression::functions::array_replace

pub fn array_replace<Arr: ArrayOrNullableArray<Inner = T> + SingleValue, T: SingleValue, a, e, r>(
    a: a,
    e: e,
    r: r,
) -> array_replace<Arr, T, a, e, r>
where
    a: AsExpression<Arr>,
    e: AsExpression<T>,
    r: AsExpression<T>,

Available on crate feature postgres_backend only.

Replace all occurrences of an element in an array with a given element

Example

let ints = diesel::select(array_replace::<Array<_>, Integer, _, _, _>(vec![1, 2, 5, 4], 5, 3))
    .get_result::<Vec<i32>>(connection)?;
assert_eq!(vec![1, 2, 3, 4], ints);

let ints = diesel::select(array_replace::<Array<_>, Nullable<Integer>, _, _, _>(vec![Some(1), Some(2), Some(3)], Some(3), None::<i32>))
    .get_result::<Vec<Option<i32>>>(connection)?;
assert_eq!(vec![Some(1), Some(2), None], ints);

let ints = diesel::select(array_replace::<Nullable<Array<_>>, Integer, _, _, _>(None::<Vec<i32>>, 1, 2))
    .get_result::<Option<Vec<i32>>>(connection)?;

let ints = diesel::select(array_replace::<Nullable<Array<_>>, Nullable<Integer>, _, _, _>(None::<Vec<i32>>, None::<i32>, Some(1)))
    .get_result::<Option<Vec<Option<i32>>>>(connection)?;
assert_eq!(None, ints);