diesel::sql_types

Struct Interval

pub struct Interval;

Expand description

The interval SQL type.

This type is currently only implemented for PostgreSQL.

§`ToSql` impls

PgInterval which can be constructed using IntervalDsl
chrono::Duration with feature = "chrono"

§`FromSql` impls

PgInterval which can be constructed using IntervalDsl
chrono::Duration with feature = "chrono" (There might be some information loss due to special behavior for literal month (or longer) intervals; Please read official documentation of PostgreSQL Interval.)

Trait Implementations§

impl Add for Interval

type Rhs = Interval

The SQL type which can be added to this one

type Output = Interval

The SQL type of the result of adding Rhs to Self

impl<'expr, 'expr2> AsExpression<Interval> for &'expr2 &'expr PgInterval

Available on crate feature postgres_backend only.

type Expression = Bound<Interval, &'expr2 &'expr PgInterval>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl<'expr, 'expr2> AsExpression<Interval> for &'expr2 &'expr Duration

Available on crate feature chrono only.

type Expression = Bound<Interval, &'expr2 &'expr TimeDelta>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl<'expr> AsExpression<Interval> for &'expr PgInterval

Available on crate feature postgres_backend only.

type Expression = Bound<Interval, &'__expr PgInterval>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl<'expr> AsExpression<Interval> for &'expr Duration

Available on crate feature chrono only.

type Expression = Bound<Interval, &'__expr TimeDelta>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl AsExpression<Interval> for PgInterval

Available on crate feature postgres_backend only.

type Expression = Bound<Interval, PgInterval>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl AsExpression<Interval> for Duration

Available on crate feature chrono only.

type Expression = Bound<Interval, TimeDelta>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl Clone for Interval

fn clone(&self) -> Interval

Returns a copy of the value. Read more

1.0.0 · Source§

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source. Read more

impl Debug for Interval

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter. Read more

impl Default for Interval

fn default() -> Interval

Returns the “default value” for a type. Read more

impl Div for Interval

type Rhs = Integer

The SQL type which this one can be divided by

type Output = Interval

The SQL type of the result of dividing Self by Rhs

impl Foldable for Interval

type Sum = Nullable<Interval>

The SQL type of sum(this_type)

type Avg = Nullable<Interval>

The SQL type of avg(this_type)

impl FromSql<Interval, Pg> for PgInterval

Available on crate feature postgres_backend only.

fn from_sql(value: PgValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> Result<Self>

A specialized variant of from_sql for handling null values. Read more

impl FromSql<Interval, Pg> for Duration

Available on crate features chrono and postgres_backend only.

fn from_sql(bytes: PgValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> Result<Self>

A specialized variant of from_sql for handling null values. Read more

impl HasSqlType<Interval> for Pg

fn metadata(_: &mut Self::MetadataLookup) -> PgTypeMetadata

Fetch the metadata for the given type Read more

impl Mul for Interval

type Rhs = Integer

The SQL type which this can be multiplied by

type Output = Interval

The SQL type of the result of multiplying Self by Rhs

impl QueryId for Interval

const HAS_STATIC_QUERY_ID: bool = true

Can the SQL generated by Self be uniquely identified by its type? Read more

type QueryId = Interval

A type which uniquely represents Self in a SQL query. Read more

fn query_id() -> Option<TypeId>

Returns the type id of Self::QueryId if Self::HAS_STATIC_QUERY_ID. Returns None otherwise. Read more

impl SqlType for Interval

type IsNull = NotNull

Is this type nullable? Read more

impl Sub for Interval

type Rhs = Interval

The SQL type which can be subtracted from this one

type Output = Interval

The SQL type of the result of subtracting Rhs from Self

impl ToSql<Interval, Pg> for PgInterval

Available on crate feature postgres_backend only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

See the trait documentation.

impl ToSql<Interval, Pg> for Duration

Available on crate features chrono and postgres_backend only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

See the trait documentation.

impl Copy for Interval

impl SingleValue for Interval

impl SqlOrd for Interval

Auto Trait Implementations§

impl Freeze for Interval

impl RefUnwindSafe for Interval

impl Send for Interval

impl Sync for Interval

impl Unpin for Interval

impl UnwindSafe for Interval

Blanket Implementations§

impl<T> Any for T
where T: 'static + ?Sized,

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more

impl<T> Borrow<T> for T
where T: ?Sized,

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more

impl<T> BorrowMut<T> for T
where T: ?Sized,

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more

impl<T> CloneToUninit for T
where T: Clone,

unsafe fn clone_to_uninit(&self, dst: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)

Performs copy-assignment from self to dst. Read more

impl<ST, U, DB> CompatibleType<U, DB> for ST
where DB: Backend, ST: SqlType + SingleValue, U: FromSqlRow<ST, DB>,

type SqlType = ST

Available on crate feature i-implement-a-third-party-backend-and-opt-into-breaking-changes only.

impl<T> From<T> for T

fn from(t: T) -> T

Returns the argument unchanged.

impl<T, U> Into<U> for T
where U: From<T>,

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

impl<T> IntoNotNullable for T
where T: SqlType<IsNull = NotNull>,

type NotNullable = T

The not nullable representation of this type. Read more

impl<T> IntoNullable for T
where T: SqlType<IsNull = NotNull> + SingleValue,

type Nullable = Nullable<T>

The nullable representation of this type. Read more

impl<T> IntoSql for T

fn into_sql<T>(self) -> AsExprOf<Self, T>
where Self: AsExpression<T> + Sized, T: SqlType + TypedExpressionType,

Convert self to an expression for Diesel’s query builder. Read more

fn as_sql<'a, T>(&'a self) -> AsExprOf<&'a Self, T>
where &'a Self: AsExpression<T>, T: SqlType + TypedExpressionType,

Convert &self to an expression for Diesel’s query builder. Read more

impl<T> ToOwned for T
where T: Clone,

type Owned = T

The resulting type after obtaining ownership.

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more

impl<T, U> TryFrom<U> for T
where U: Into<T>,

type Error = Infallible

The type returned in the event of a conversion error.

fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>

Performs the conversion.

impl<T, U> TryInto<U> for T
where U: TryFrom<T>,

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

Performs the conversion.

impl<V, T> VZip<V> for T
where V: MultiLane<T>,

fn vzip(self) -> V

impl<T> ErasedDestructor for T
where T: 'static,

impl<T> MaybeSendSync for T

impl<ST> TypedExpressionType for ST
where ST: SingleValue,