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
expressionCreates a SQL
COUNT(DISTINCT ...)
expressionCreates a SQL
COUNT(*)
expressionRepresents 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.existsNon-
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
expressionCreates 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)
AndNet
postgres_backend
The return type of
lsh.and(rhs)
for network typesArrayContains
postgres_backend
The return type of
lhs.contains(rhs)
for array expressionsArrayIndex
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()
AtTimeZone
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)
ConcatBinary
postgres_backend
The return type of
lhs.remove_by_path(rhs)
ConcatJsonb
postgres_backend
The return type of
lsh.concat(rhs)
ContainsJsonb
postgres_backend
The return type of
lsh.contains(rhs)
for jsonb typesContainsNet
postgres_backend
The return type of
lhs.contains(rhs)
for network typesContainsNetLoose
postgres_backend
The return type of
lhs.contains_or_eq(rhs)
The return type of
expr.desc()
DifferenceNet
postgres_backend
The return type of
lsh.diff(rhs)
Represents the return type of
.distinct()
DistinctOn
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)
HasAllKeysJsonb
postgres_backend
The return type of
lsh.has_all_keys(rhs)
HasAnyKeyJsonb
postgres_backend
The return type of
lsh.has_any_key(rhs)
HasKeyJsonb
postgres_backend
The return type of
lsh.has_key(rhs)
Represents the return type of
.having(predicate)
ILike
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>()
Is
sqlite
The return type of
lhs.is(rhs)
.IsContainedBy
postgres_backend
The return type of
lhs.is_contained_by(rhs)
IsContainedByJsonb
postgres_backend
The return type of
lsh.is_contained_by(rhs)
for jsonb typesIsContainedByNet
postgres_backend
The return type of [
lhs.is_contained_by(rhs)
]((super::expression_methods::PgNetExpressionMethods::is_contained_by)
for network typesIsContainedByNetLoose
postgres_backend
The return type of
lhs.is_contained_by_or_eq(rhs)
IsDistinctFrom
postgres_backend
The return type of
lhs.is_distinct_from(rhs)
IsNot
sqlite
The return type of
lhs.is_not(rhs)
.IsNotDistinctFrom
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)
LikeBinary
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)
NotILike
postgres_backend
The return type of
lhs.not_ilike(rhs)
The return type of
lhs.not_like(rhs)
NotLikeBinary
postgres_backend
The return type of
lhs.remove_by_path(rhs)
NotSimilarTo
postgres_backend
The return type of
lhs.not_similar_to(rhs)
The return type of
expr.nullable()
Represents the return type of
.nullable()
NullsFirst
postgres_backend
The return type of
expr.nulls_first()
NullsLast
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)
OrNet
postgres_backend
The return type of
lsh.or(rhs)
for network typesRepresents the return type of
.order(ordering)
OverlapsWith
postgres_backend
The return type of
lhs.overlaps_with(rhs)
OverlapsWithNet
postgres_backend
The return type of
lhs.overlaps_with(rhs)
for network typesRangeContains
postgres_backend
The return type of
lhs.contains(rhs)
for range expressionsRemoveByPathFromJsonb
postgres_backend
The return type of
lhs.remove_by_path(rhs)
RemoveFromJsonb
postgres_backend
The return type of
lhs.remove(rhs)
RetrieveAsObjectJson
postgres_backend
The return type of
lhs.retrieve_as_object(rhs)
RetrieveAsTextJson
postgres_backend
The return type of
lhs.retrieve_as_text(rhs)
RetrieveByPathAsObjectJson
postgres_backend
The return type of
lhs.retrieve_by_path_as_object(rhs)
RetrieveByPathAsTextJson
postgres_backend
The return type of
lhs.retrieve_by_path_as_text(rhs)
Represents the return type of
.select(selection)
SimilarTo
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)