Expand description
Includes various helper types and bare functions which are named too generically to be included in prelude, but are often used when using Diesel.
Re-exports
pub use crate::pg::expression::dsl::*;
Structs
Represents the SQL CURRENT_TIMESTAMP
constant. This is equivalent to the
NOW()
function on backends that support it.
Represents the SQL CURRENT_DATE
constant.
Functions
Represents a SQL AVG
function. This function can only take types which are
Foldable.
Creates a SQL COUNT
expression
Creates a SQL COUNT(DISTINCT ...)
expression
Creates a SQL COUNT(*)
expression
Represents the SQL DATE
function. The argument should be a Timestamp
expression, and the return value will be an expression of type Date.
Creates a DELETE
statement.
i-implement-a-third-party-backend-and-opt-into-breaking-changes
Creates a SQL EXISTS
expression.
Creates an INSERT
statement for the target table.
Creates an INSERT [OR] IGNORE
statement.
Represents a SQL MAX
function. This function can only take types which are
ordered.
Represents a SQL MIN
function. This function can only take types which are
ordered.
Creates a SQL NOT
expression
Creates a REPLACE
statement.
Creates a bare select statement, with no from clause. Primarily used for testing diesel itself, but likely useful for third party crates as well. The given expressions must be selectable from anywhere.
Use literal SQL in the query builder.
Construct a full SQL query using raw SQL.
Represents a SQL SUM
function. This function can only take types which are
Foldable.
Creates an UPDATE
statement.
Type Definitions
Maps F
to Alias<S>
The return type of
lhs.and(rhs)
postgres_backend
The return type of lsh.and(rhs)
for network types
postgres_backend
The return type of lhs.contains(rhs)
for array expressions
postgres_backend
The return type of lhs.index(rhs)
The type of Item
when converted to an expression with the same type as TargetExpr
The type of Item
when converted to an expression of Type
Represents the return type of .as_select()
The return type of
expr.asc()
The return type of
expr.assume_not_null()
postgres_backend
The return type of expr.at_time_zone(tz)
Represents the return type of diesel::select(selection)
The return type of
lhs.between(lower, upper)
The return type of
lhs.concat(rhs)
postgres_backend
The return type of lhs.remove_by_path(rhs)
postgres_backend
The return type of lsh.concat(rhs)
postgres_backend
The return type of lsh.contains(rhs)
for jsonb types
postgres_backend
The return type of lhs.contains(rhs)
for network types
postgres_backend
The return type of lhs.contains_or_eq(rhs)
The return type of
expr.desc()
postgres_backend
The return type of lsh.diff(rhs)
Represents the return type of .distinct()
postgres_backend
Represents the return type of .distinct_on(expr)
The return type of
lhs.eq(rhs)
The return type of
lhs.eq_any(rhs)
The return type of
lhs.escape('x')
Represents the return type of .except(rhs)
Represents the return type of .except_all(rhs)
Represents the return type of .filter(predicate)
Represents the return type of .filter(lhs.eq(rhs))
Represents the return type of .for_key_share()
Represents the return type of .for_no_key_update()
Represents the return type of .for_share()
Represents the return type of .for_update()
Represents the return type of .group_by(expr)
The return type of
lhs.gt(rhs)
The return type of
lhs.ge(rhs)
postgres_backend
The return type of lsh.has_all_keys(rhs)
postgres_backend
The return type of lsh.has_any_key(rhs)
postgres_backend
The return type of lsh.has_key(rhs)
Represents the return type of .having(predicate)
postgres_backend
The return type of lhs.ilike(rhs)
Represents the return type of .inner_join(rhs)
Represents the return type of .inner_join(rhs.on(on))
A query source representing the inner join between two tables.
For example, for the inner join between three tables that implement JoinTo
:
InnerJoinQuerySource<InnerJoinQuerySource<table1, table2>, table3>
Which conveniently lets you omit the exact join condition.
Represents the return type of .intersect(rhs)
Represents the return type of .intersect_all(rhs)
Represents the return type of .into_boxed::<'a, DB>()
sqlite
The return type of lhs.is(rhs)
.
postgres_backend
The return type of lhs.is_contained_by(rhs)
postgres_backend
The return type of lsh.is_contained_by(rhs)
for jsonb types
postgres_backend
The return type of [lhs.is_contained_by(rhs)
]((super::expression_methods::PgNetExpressionMethods::is_contained_by)
for network types
postgres_backend
The return type of lhs.is_contained_by_or_eq(rhs)
postgres_backend
The return type of lhs.is_distinct_from(rhs)
sqlite
The return type of lhs.is_not(rhs)
.
postgres_backend
The return type of lhs.is_not_distinct_from(rhs)
The return type of
expr.is_not_null()
The return type of
expr.is_null()
Represents the return type of .left_join(rhs)
Represents the return type of .left_join(rhs.on(on))
A query source representing the left outer join between two tables.
For example, for the left join between three tables that implement JoinTo
:
LeftJoinQuerySource<LeftJoinQuerySource<table1, table2>, table3>
Which conveniently lets you omit the exact join condition.
The return type of
lhs.like(rhs)
postgres_backend
The return type of lhs.remove_by_path(rhs)
The return type of
lhs.lt(rhs)
The return type of
lhs.le(rhs)
The return type of
lhs.ne_all(rhs)
Represents the return type of .no_wait()
The return type of
lhs.not_between(lower, upper)
The return type of
lhs.ne(rhs)
postgres_backend
The return type of lhs.not_ilike(rhs)
The return type of
lhs.not_like(rhs)
postgres_backend
The return type of lhs.remove_by_path(rhs)
postgres_backend
The return type of lhs.not_similar_to(rhs)
The return type of
expr.nullable()
Represents the return type of .nullable()
postgres_backend
The return type of expr.nulls_first()
postgres_backend
The return type of expr.nulls_last()
Represents the return type of rhs.on(on)
The return type of
lhs.or(rhs)
Represents the return type of .or_filter(predicate)
postgres_backend
The return type of lsh.or(rhs)
for network types
Represents the return type of .order(ordering)
postgres_backend
The return type of lhs.overlaps_with(rhs)
postgres_backend
The return type of lhs.overlaps_with(rhs)
for network types
postgres_backend
The return type of lhs.contains(rhs)
for range expressions
postgres_backend
The return type of lhs.remove_by_path(rhs)
postgres_backend
The return type of lhs.remove(rhs)
postgres_backend
The return type of lhs.retrieve_as_object(rhs)
postgres_backend
The return type of lhs.retrieve_as_text(rhs)
postgres_backend
The return type of lhs.retrieve_by_path_as_object(rhs)
postgres_backend
The return type of lhs.retrieve_by_path_as_text(rhs)
Represents the return type of .select(selection)
postgres_backend
The return type of lhs.similar_to(rhs)
Represents the return type of .single_value()
Represents the return type of .skip_locked()
The SQL type of an expression
Represents the return type of .then_order_by(ordering)
Represents the return type of .union(rhs)
Represents the return type of .union_all(rhs)
Represents the return type of update(lhs).set(rhs)
The return type of count(expr)
The return type of count_distinct()
The return type of count_star()
The return type of date(expr)
The return type of exists(expr)