Function diesel::pg::expression::functions::tstzrange

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

Available on crate feature postgres_backend only.

Returns range of timestamps with timezone

Example

use diesel::dsl::tstzrange;
use diesel::pg::sql_types::RangeBound;
use time::{OffsetDateTime, macros::datetime};

diesel::insert_into(posts)
    .values(&[
       versions.eq(tstzrange(Some(datetime!(2020-01-01 0:00 UTC)), Some(datetime!(2021-01-01 0:00 -3)), RangeBound::LowerBoundInclusiveUpperBoundInclusive)),
       versions.eq(tstzrange(None, Some(datetime!(2020-01-01 0:00 +2)), RangeBound::LowerBoundInclusiveUpperBoundExclusive)),
    ]).execute(conn)?;

let cool_posts = posts.select(versions)
    .load::<(Bound<OffsetDateTime>, Bound<OffsetDateTime>)>(conn)?;
assert_eq!(vec![
         (Bound::Included(datetime!(2020-01-01 0:00 UTC)), Bound::Included(datetime!(2021-01-01 0:00 -3))),
         (Bound::Unbounded, Bound::Excluded(datetime!(2020-01-01 0:00 +2))),
     ], cool_posts);