Struct Money

pub struct Money;

Available on crate feature postgres_backend only.

The PostgreSQL Money type.

ToSql impls

• Cents (also aliased as PgMoney)

FromSql impls

• Cents (also aliased as PgMoney)

Examples

use diesel::data_types::Cents;

table! {
    items {
        id -> Integer,
        name -> VarChar,
        price -> Money,
    }
}

let inserted_price = insert_into(items)
    .values((name.eq("Shiny Thing"), price.eq(Cents(123_456))))
    .returning(price)
    .get_result(connection);
assert_eq!(Ok(Cents(123_456)), inserted_price);

Trait Implementations

impl<'__expr, '__expr2> AsExpression<Money> for &'__expr2 &'__expr PgMoney

type Expression = Bound<Money, &'__expr2 &'__expr PgMoney>

The expression being returned

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

Perform the conversion

impl<'__expr> AsExpression<Money> for &'__expr PgMoney

type Expression = Bound<Money, &'__expr PgMoney>

The expression being returned

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

Perform the conversion

impl AsExpression<Money> for PgMoney

type Expression = Bound<Money, PgMoney>

The expression being returned

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

Perform the conversion

impl Clone for Money

fn clone(&self) -> Money

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Money

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

Formats the value using the given formatter.

impl Default for Money

fn default() -> Money

Returns the “default value” for a type.

impl FromSql<Money, Pg> for PgMoney

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.

impl HasSqlType<Money> for Pg

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

Fetch the metadata for the given type

impl QueryId for Money

const HAS_STATIC_QUERY_ID: bool = true

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

type QueryId = Money

A type which uniquely represents Self in a SQL query.

fn query_id() -> Option<TypeId>

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

impl SqlType for Money

type IsNull = NotNull

Is this type nullable?

impl ToSql<Money, Pg> for PgMoney

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

See the trait documentation.

impl Copy for Money

impl SingleValue for Money