Numeric

diesel::sql_types

Struct Numeric

pub struct Numeric;

Expand description

The arbitrary precision numeric SQL type.

This type is only supported on PostgreSQL and MySQL. On SQLite, Double should be used instead.

§`ToSql` impls

bigdecimal::BigDecimal with feature = ["numeric"]

§`FromSql` impls

bigdecimal::BigDecimal with feature = ["numeric"]

Trait Implementations§

impl Add for Numeric

type Rhs = Numeric

The SQL type which can be added to this one

type Output = Numeric

The SQL type of the result of adding Rhs to Self

impl<'expr, 'expr2> AsExpression<Numeric> for &'expr2 &'expr BigDecimal

Available on crate feature numeric only.

type Expression = Bound<Numeric, &'expr2 &'expr BigDecimal>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Numeric>>::Expression

Perform the conversion

impl<'expr, 'expr2> AsExpression<Numeric> for &'expr2 &'expr PgNumeric

Available on crate feature postgres_backend only.

type Expression = Bound<Numeric, &'expr2 &'expr PgNumeric>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Numeric>>::Expression

Perform the conversion

impl<'expr> AsExpression<Numeric> for &'expr BigDecimal

Available on crate feature numeric only.

type Expression = Bound<Numeric, &'__expr BigDecimal>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Numeric>>::Expression

Perform the conversion

impl<'expr> AsExpression<Numeric> for &'expr PgNumeric

Available on crate feature postgres_backend only.

type Expression = Bound<Numeric, &'__expr PgNumeric>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Numeric>>::Expression

Perform the conversion

impl AsExpression<Numeric> for BigDecimal

Available on crate feature numeric only.

type Expression = Bound<Numeric, BigDecimal>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Numeric>>::Expression

Perform the conversion

impl AsExpression<Numeric> for PgNumeric

Available on crate feature postgres_backend only.

type Expression = Bound<Numeric, PgNumeric>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Numeric>>::Expression

Perform the conversion

impl Clone for Numeric

fn clone(&self) -> Numeric

Returns a duplicate 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 Numeric

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

Formats the value using the given formatter. Read more

impl Default for Numeric

fn default() -> Numeric

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

impl Div for Numeric

type Rhs = Numeric

The SQL type which this one can be divided by

type Output = Numeric

The SQL type of the result of dividing Self by Rhs

impl Foldable for Numeric

type Sum = Nullable<Numeric>

The SQL type of sum(this_type)

type Avg = Nullable<Numeric>

The SQL type of avg(this_type)

impl FromSql<Numeric, Mysql> for BigDecimal

Available on crate features numeric and mysql_backend only.

fn from_sql(value: MysqlValue<'_>) -> 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<Numeric, Pg> for BigDecimal

Available on crate features numeric and postgres_backend only.

fn from_sql(numeric: 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<Numeric, Pg> for PgNumeric

Available on crate feature 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 FromSql<Numeric, Sqlite> for BigDecimal

Available on crate features numeric and sqlite only.

fn from_sql(bytes: SqliteValue<'_, '_, '_>) -> 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<Numeric> for Mysql

fn metadata(_: &mut ()) -> MysqlType

Fetch the metadata for the given type Read more

impl HasSqlType<Numeric> for Pg

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

Fetch the metadata for the given type Read more

impl HasSqlType<Numeric> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type Read more

impl KnownCastSqlTypeName<Pg> for Numeric

Available on crate feature postgres_backend only.

const SQL_TYPE_NAME: &'static str = "numeric"

What to write as sql_type in the CAST(expr AS sql_type) SQL for Self

impl Mul for Numeric

type Rhs = Numeric

The SQL type which this can be multiplied by

type Output = Numeric

The SQL type of the result of multiplying Self by Rhs

impl QueryId for Numeric

const HAS_STATIC_QUERY_ID: bool = true

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

type QueryId = Numeric

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 Numeric

type IsNull = NotNull

Is this type nullable? Read more

impl Sub for Numeric

type Rhs = Numeric

The SQL type which can be subtracted from this one

type Output = Numeric

The SQL type of the result of subtracting Rhs from Self

impl ToSql<Numeric, Mysql> for BigDecimal

Available on crate features numeric and mysql_backend only.

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

See the trait documentation.

impl ToSql<Numeric, Pg> for BigDecimal

Available on crate features numeric and postgres_backend only.

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

See the trait documentation.

impl ToSql<Numeric, Pg> for PgNumeric

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<Numeric, Sqlite> for BigDecimal

Available on crate features numeric and sqlite only.

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

See the trait documentation.

impl Copy for Numeric

impl SingleValue for Numeric

Auto Trait Implementations§

impl Freeze for Numeric

impl RefUnwindSafe for Numeric

impl Send for Numeric

impl Sync for Numeric

impl Unpin for Numeric

impl UnwindSafe for Numeric

Blanket Implementations§

impl<T> AggregateExpressionMethods for T

fn aggregate_distinct(self) -> AggregateDistinct<Self>
where Self: DistinctDsl,

DISTINCT modifier for aggregate functions Read more

fn aggregate_all(self) -> AggregateAll<Self>
where Self: AllDsl,

ALL modifier for aggregate functions Read more

fn aggregate_filter<P>(self, f: P) -> AggregateFilter<Self, P>
where P: AsExpression<Bool>, Self: FilterDsl<P::Expression>,

Add an aggregate function filter Read more

fn aggregate_order<O>(self, o: O) -> AggregateOrder<Self, O>
where Self: OrderAggregateDsl<O>,

Add an aggregate function order Read more

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, dest: *mut u8)

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

Performs copy-assignment from self to dest. 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> Downcast for T
where T: Any,

fn into_any(self: Box<T>) -> Box<dyn Any>

Converts Box<dyn Trait> (where Trait: Downcast) to Box<dyn Any>, which can then be downcast into Box<dyn ConcreteType> where ConcreteType implements Trait.

fn into_any_rc(self: Rc<T>) -> Rc<dyn Any>

Converts Rc<Trait> (where Trait: Downcast) to Rc<Any>, which can then be further downcast into Rc<ConcreteType> where ConcreteType implements Trait.

fn as_any(&self) -> &(dyn Any + 'static)

Converts &Trait (where Trait: Downcast) to &Any. This is needed since Rust cannot generate &Any’s vtable from &Trait’s.

fn as_any_mut(&mut self) -> &mut (dyn Any + 'static)

Converts &mut Trait (where Trait: Downcast) to &Any. This is needed since Rust cannot generate &mut Any’s vtable from &mut Trait’s.

impl<T> DowncastSend for T
where T: Any + Send,

fn into_any_send(self: Box<T>) -> Box<dyn Any + Send>

Converts Box<Trait> (where Trait: DowncastSend) to Box<dyn Any + Send>, which can then be downcast into Box<ConcreteType> where ConcreteType implements Trait.

impl<T> DowncastSync for T
where T: Any + Send + Sync,

fn into_any_sync(self: Box<T>) -> Box<dyn Any + Sync + Send>

Converts Box<Trait> (where Trait: DowncastSync) to Box<dyn Any + Send + Sync>, which can then be downcast into Box<ConcreteType> where ConcreteType implements Trait.

fn into_any_arc(self: Arc<T>) -> Arc<dyn Any + Sync + Send>

Converts Arc<Trait> (where Trait: DowncastSync) to Arc<Any>, which can then be downcast into Arc<ConcreteType> where ConcreteType implements Trait.

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<T> WindowExpressionMethods for T

fn over(self) -> Over<Self>
where Self: OverDsl,

Turn a function call into a window function call Read more

fn window_filter<P>(self, f: P) -> WindowFilter<Self, P>
where P: AsExpression<Bool>, Self: FilterDsl<P::Expression>,

Add a filter to the current window function Read more

fn partition_by<E>(self, expr: E) -> PartitionBy<Self, E>
where Self: PartitionByDsl<E>,

Add a partition clause to the current window function Read more

fn window_order<E>(self, expr: E) -> WindowOrder<Self, E>
where Self: OrderWindowDsl<E>,

Add a order clause to the current window function Read more

fn frame_by<E>(self, expr: E) -> FrameBy<Self, E>
where Self: FrameDsl<E>,

Add a frame clause to the current window function Read more

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

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