ColumnQueryExpressions<T, V> extension

Bound comparisons and orderings on a Column.

on

Methods

asc({bool? nullsFirst}) → SqlOrdering<T>

Available on Column<T, V>, provided by the ColumnQueryExpressions extension

Ascending order. nullsFirst selects NULLS FIRST or NULLS LAST.
desc({bool? nullsFirst}) → SqlOrdering<T>

Available on Column<T, V>, provided by the ColumnQueryExpressions extension

Descending order. nullsFirst selects NULLS FIRST or NULLS LAST.
eq(V value) → SqlPredicate<T>

Available on Column<T, V>, provided by the ColumnQueryExpressions extension

column = ?.
gt(V value) → SqlPredicate<T>

Available on Column<T, V>, provided by the ColumnQueryExpressions extension

column > ?.
gte(V value) → SqlPredicate<T>

Available on Column<T, V>, provided by the ColumnQueryExpressions extension

column >= ?.
inValues(Iterable<V> values) → SqlPredicate<T>

Available on Column<T, V>, provided by the ColumnQueryExpressions extension

column IN (...) with one bound value per element.
isNotNull() → SqlPredicate<T>

Available on Column<T, V>, provided by the ColumnQueryExpressions extension

column IS NOT NULL.
isNull() → SqlPredicate<T>

Available on Column<T, V>, provided by the ColumnQueryExpressions extension

column IS NULL.
lt(V value) → SqlPredicate<T>

Available on Column<T, V>, provided by the ColumnQueryExpressions extension

column < ?.
lte(V value) → SqlPredicate<T>

Available on Column<T, V>, provided by the ColumnQueryExpressions extension

column <= ?.
notEq(V value) → SqlPredicate<T>

Available on Column<T, V>, provided by the ColumnQueryExpressions extension

column <> ?.