Struct Calc 

pub struct Calc<M, T> { /* private fields */ }

Result of arithmetic on typed handles: an expression that is still known to have type T, so it can be compared with and assigned to T fields.

Implementations

impl<M, T> Calc<M, T>

pub fn alias(self, name: impl Into<Ident>) -> SelectExpr

Name this expression for values(..).

impl<M, T> Calc<M, T>

pub fn expr(self) -> Expr

Untyped expression for this handle.

pub fn asc(self) -> OrderExpr

Ascending ordering.

pub fn desc(self) -> OrderExpr

Descending ordering.

pub fn is_null(self) -> Expr

IS NULL.

pub fn is_not_null(self) -> Expr

IS NOT NULL.

pub fn is_in<L: Literal<T>>(self, values: impl IntoIterator<Item = L>) -> Expr

Membership in a list of literals.

pub fn in_subquery(self, plan: QueryPlan) -> Expr

Membership in the single column a subquery selects.

pub fn range(self, lo: impl Literal<T>, hi: impl Literal<T>) -> Expr

Inclusive range.

pub fn cast(self, ty: SqlType) -> Expr

CAST(self AS ty).

impl<M, T: TextLike> Calc<M, T>

pub fn iexact(self, v: impl Into<String>) -> Expr

Case-insensitive equality.

pub fn regex(self, pattern: impl Into<String>) -> Expr

Regex match (requires Feature::Regex).

impl<M, T: DateLike> Calc<M, T>

pub fn year(self) -> Expr

Year component.

pub fn month(self) -> Expr

Month component.

pub fn day(self) -> Expr

Day-of-month component.

pub fn week(self) -> Expr

ISO week number.

pub fn quarter(self) -> Expr

Quarter 1..=4.

pub fn date(self) -> Expr

The date part of a timestamp.

impl<M, T: TimeLike> Calc<M, T>

pub fn hour(self) -> Expr

Hour component.

pub fn minute(self) -> Expr

Minute component.

pub fn second(self) -> Expr

Second component.

impl<M, T> Calc<M, T>

pub fn eq(self, rhs: impl Operand<M, T>) -> Expr

Typed eq comparison.

pub fn ne(self, rhs: impl Operand<M, T>) -> Expr

Typed ne comparison.

pub fn lt(self, rhs: impl Operand<M, T>) -> Expr

Typed lt comparison.

pub fn le(self, rhs: impl Operand<M, T>) -> Expr

Typed le comparison.

pub fn gt(self, rhs: impl Operand<M, T>) -> Expr

Typed gt comparison.

pub fn ge(self, rhs: impl Operand<M, T>) -> Expr

Typed ge comparison.

impl<M, T: TextLike> Calc<M, T>

pub fn contains(self, needle: impl Into<String>) -> Expr

Text lookup contains.

pub fn icontains(self, needle: impl Into<String>) -> Expr

Text lookup icontains.

pub fn starts_with(self, needle: impl Into<String>) -> Expr

Text lookup starts_with.

pub fn istarts_with(self, needle: impl Into<String>) -> Expr

Text lookup istarts_with.

pub fn ends_with(self, needle: impl Into<String>) -> Expr

Text lookup ends_with.

pub fn iends_with(self, needle: impl Into<String>) -> Expr

Text lookup iends_with.

Trait Implementations

impl<M, T: Numeric, R: Operand<M, T>> Add<R> for Calc<M, T>

type Output = Calc<M, T>

The resulting type after applying the + operator.

fn add(self, rhs: R) -> Calc<M, T>

Performs the + operation.

impl<M, T> Clone for Calc<M, T>

fn clone(&self) -> Self

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<M, T> Debug for Calc<M, T>

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

Formats the value using the given formatter.

impl<M, T: Numeric, R: Operand<M, T>> Div<R> for Calc<M, T>

type Output = Calc<M, T>

The resulting type after applying the / operator.

fn div(self, rhs: R) -> Calc<M, T>

Performs the / operation.

impl<M, T> From<Calc<M, T>> for Expr

fn from(c: Calc<M, T>) -> Self

Converts to this type from the input type.

impl<M, T: Numeric, R: Operand<M, T>> Mul<R> for Calc<M, T>

type Output = Calc<M, T>

The resulting type after applying the * operator.

fn mul(self, rhs: R) -> Calc<M, T>

Performs the * operation.

impl<M, T: Numeric> Neg for Calc<M, T>

type Output = Calc<M, T>

The resulting type after applying the - operator.

fn neg(self) -> Calc<M, T>

Performs the unary - operation.

impl<M, T> Operand<M, T> for Calc<M, T>

fn into_expr(self) -> Expr

Convert into an expression.

impl<M, T: Numeric, R: Operand<M, T>> Rem<R> for Calc<M, T>

type Output = Calc<M, T>

The resulting type after applying the % operator.

fn rem(self, rhs: R) -> Calc<M, T>

Performs the % operation.

impl<M, T: Numeric, R: Operand<M, T>> Sub<R> for Calc<M, T>

type Output = Calc<M, T>

The resulting type after applying the - operator.

fn sub(self, rhs: R) -> Calc<M, T>

Performs the - operation.