Function int8range

pub fn int8range<lower, upper, bound>(
    lower: lower,
    upper: upper,
    bound: bound,
) -> int8range<lower, upper, bound>
where
    lower: AsExpression<Nullable<BigInt>>,
    upper: AsExpression<Nullable<BigInt>>,
    bound: AsExpression<RangeBoundEnum>,

Available on crate feature postgres_backend only.

Returns range of big ints

Example

use diesel::dsl::int8range;
use diesel::pg::sql_types::RangeBound;

diesel::insert_into(posts)
    .values(&[
       versions.eq(int8range(Some(3), Some(5), RangeBound::LowerBoundInclusiveUpperBoundInclusive)),
       versions.eq(int8range(None, Some(2), RangeBound::LowerBoundInclusiveUpperBoundExclusive)),
    ]).execute(conn)?;

let cool_posts = posts.select(versions)
    .load::<(Bound<i64>, Bound<i64>)>(conn)?;
assert_eq!(vec![
         (Bound::Included(3), Bound::Excluded(6)), // Postgres cast this internally
         (Bound::Unbounded, Bound::Excluded(2)),
     ], cool_posts);