PostgrestNullableColumn<Row, Value extends Object> class
final
A stored column the database allows to be NULL, see
PostgrestStoredColumn.
Value stays the non-nullable type, PostgrestNullableColumn<Row, String>
for a nullable text column; NULL is tested with
PostgrestNullableExpression.isNull, and the column is read from a
PostgrestPartialRow as Value?.
- Inheritance
-
- Object
- PostgrestSelectable<
Row> - PostgrestColumnExpression<
Row, Value> - PostgrestStoredColumn<
Row, Value> - PostgrestNullableColumn
- Implemented types
-
- PostgrestReadable<
Row, Value?>
- PostgrestReadable<
- Mixed-in types
-
- PostgrestNullableExpression<
Row, Value>
- PostgrestNullableExpression<
- Available extensions
- Annotations
-
- @experimental
Constructors
- PostgrestNullableColumn(String name, {Value fromJson(Object json)?})
-
const
Properties
- expression → String
-
The text PostgREST expects in a
selectlist and, for a column expression, on the left of an operator. A JSON path, cast or aggregate is renamed to its responseKey in aselectlist.no setterinherited - hashCode → int
-
The hash code for this object.
no setterinherited
- name → String
-
Name of the column in the database.
finalinherited
- orderKey → String
-
The rendered key as it appears in the
orderparameter, for exampletitle.desc.nullslast.no setterinherited - responseKey → String
-
The key the entry comes back under in a response row: the column name,
the expression of a JSON path, cast or aggregate, or the
PostgrestRelation.key of an embed.
no setterinherited
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
Methods
-
asc(
) → PostgrestColumnOrdering< Row> -
Sorts smallest first.
inherited
-
avg(
) → PostgrestDerivedExpression< Row, double> -
The mean of this expression across the group.
inherited
-
cast<
Target extends Object> (PostgrestCastTarget< Target> target) → PostgrestDerivedExpression<Row, Target> -
Casts this expression to another Postgres type,
cost::text.inherited -
containedBy(
List< Element?> values) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose array elements are all contained inRow, List< , provided by the PostgrestArrayFilters extensionElement> >values. -
containedBy(
PostgresRange< Bound> range) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose range lies withinRow, PostgresRange< , provided by the PostgrestRangeFilters extensionBound> >range. -
containedBy(
PostgresMultirange< Bound> multirange) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose multirange lies withinRow, PostgresMultirange< , provided by the PostgrestMultirangeFilters extensionBound> >multirange. -
containedByJson(
Object? value) → PostgrestFilter< Row> -
Available on PostgrestFilterableExpression<
Only rows whoseRow, PostgrestJson> , provided by the PostgrestJsonFilters extensionjsonbvalue is contained byvalue. -
contains(
List< Element?> values) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose array contains every element ofRow, List< , provided by the PostgrestArrayFilters extensionElement> >values. -
contains(
PostgresMultirange< Bound> multirange) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose multirange contains every value ofRow, PostgresMultirange< , provided by the PostgrestMultirangeFilters extensionBound> >multirange. -
contains(
PostgresRange< Bound> range) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose range contains every value ofRow, PostgresRange< , provided by the PostgrestRangeFilters extensionBound> >range. -
containsElement(
Bound value) → PostgrestFilter< Row> -
Available on PostgrestFilterableExpression<
Only rows whose range containsRow, PostgresRange< , provided by the PostgrestRangeFilters extensionBound> >value. -
containsJson(
Object? value) → PostgrestFilter< Row> -
Available on PostgrestFilterableExpression<
Only rows whoseRow, PostgrestJson> , provided by the PostgrestJsonFilters extensionjsonbvalue containsvalue. -
count(
) → PostgrestDerivedExpression< Row, int> -
How many non-null values of this expression are in the group.
inherited
-
desc(
) → PostgrestColumnOrdering< Row> -
Sorts largest first.
inherited
-
eq(
Value value) → PostgrestFilter< Row> -
Only rows where this expression equals
value.inherited -
gt(
Value value) → PostgrestFilter< Row> -
Only rows where this expression is greater than
value.inherited -
gte(
Value value) → PostgrestFilter< Row> -
Only rows where this expression is greater than or equal to
value.inherited -
ilike(
String pattern) → PostgrestFilter< Row> -
Available on PostgrestFilterableExpression<
Only rows matching theRow, String> , provided by the PostgrestTextFilters extensionLIKEpatterncase-insensitively. -
ilikeAllOf(
List< String> patterns) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows matching every one ofRow, String> , provided by the PostgrestTextFilters extensionpatternscase-insensitively. -
ilikeAnyOf(
List< String> patterns) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows matching at least one ofRow, String> , provided by the PostgrestTextFilters extensionpatternscase-insensitively. -
imatchRegex(
String pattern) → PostgrestFilter< Row> -
Available on PostgrestFilterableExpression<
Only rows matching the POSIX regular expressionRow, String> , provided by the PostgrestTextFilters extensionpatterncase-insensitively. -
inFilter(
List< Value> values) → PostgrestFilter<Row> -
Only rows where this expression equals one of
values.inherited -
isDistinct(
Value value) → PostgrestFilter< Row> -
Only rows where this expression is distinct from
value.inherited -
isFalse(
) → PostgrestFilter< Row> -
Available on PostgrestFilterableExpression<
Only rows where this boolean expressionRow, bool> , provided by the PostgrestBooleanFilters extensionIS FALSE. -
isNull(
) → PostgrestFilter< Row> -
Only rows where this expression is SQL
NULL.inherited -
isTrue(
) → PostgrestFilter< Row> -
Available on PostgrestFilterableExpression<
Only rows where this boolean expressionRow, bool> , provided by the PostgrestBooleanFilters extensionIS TRUE. -
jsonObject(
String key) → PostgrestJsonPath< Row, PostgrestJson> -
Reads a
json/jsonbobject key as JSON, with->.inherited -
jsonObjectAt(
int index) → PostgrestJsonPath< Row, PostgrestJson> -
Reads a
json/jsonbarray element as JSON, with->.inherited -
jsonText(
String key) → PostgrestJsonPath< Row, String> -
Reads a
json/jsonbobject key as text, with->>.inherited -
jsonTextAt(
int index) → PostgrestJsonPath< Row, String> -
Reads a
json/jsonbarray element as text, with->>.inherited -
like(
String pattern) → PostgrestFilter< Row> -
Available on PostgrestFilterableExpression<
Only rows matching theRow, String> , provided by the PostgrestTextFilters extensionLIKEpatterncase-sensitively. -
likeAllOf(
List< String> patterns) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows matching every one ofRow, String> , provided by the PostgrestTextFilters extensionpatternscase-sensitively. -
likeAnyOf(
List< String> patterns) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows matching at least one ofRow, String> , provided by the PostgrestTextFilters extensionpatternscase-sensitively. -
lt(
Value value) → PostgrestFilter< Row> -
Only rows where this expression is less than
value.inherited -
lte(
Value value) → PostgrestFilter< Row> -
Only rows where this expression is less than or equal to
value.inherited -
matchRegex(
String pattern) → PostgrestFilter< Row> -
Available on PostgrestFilterableExpression<
Only rows matching the POSIX regular expressionRow, String> , provided by the PostgrestTextFilters extensionpatterncase-sensitively. -
max(
) → PostgrestDerivedExpression< Row, Value> -
The largest value of this expression in the group, keeping the
expression's own type.
inherited
-
min(
) → PostgrestDerivedExpression< Row, Value> -
The smallest value of this expression in the group, keeping the
expression's own type.
inherited
-
neq(
Value value) → PostgrestFilter< Row> -
Only rows where this expression does not equal
value.inherited -
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
nullsFirst(
) → PostgrestOrdering< Row> -
Places
NULLs before non-null values.inherited -
nullsLast(
) → PostgrestOrdering< Row> -
Places
NULLs after non-null values.inherited -
overlaps(
List< Element?> values) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose array shares at least one element withRow, List< , provided by the PostgrestArrayFilters extensionElement> >values. -
overlaps(
PostgresMultirange< Bound> multirange) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose multirange shares at least one value withRow, PostgresMultirange< , provided by the PostgrestMultirangeFilters extensionBound> >multirange. -
overlaps(
PostgresRange< Bound> range) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose range shares at least one value withRow, PostgresRange< , provided by the PostgrestRangeFilters extensionBound> >range. -
rangeAdjacent(
PostgresMultirange< Bound> multirange) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose multirange is adjacent toRow, PostgresMultirange< , provided by the PostgrestMultirangeFilters extensionBound> >multirange. -
rangeAdjacent(
PostgresRange< Bound> range) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose range is adjacent toRow, PostgresRange< , provided by the PostgrestRangeFilters extensionBound> >range. -
rangeGt(
PostgresRange< Bound> range) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose range is strictly to the right ofRow, PostgresRange< , provided by the PostgrestRangeFilters extensionBound> >range. -
rangeGt(
PostgresMultirange< Bound> multirange) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose multirange is strictly to the right ofRow, PostgresMultirange< , provided by the PostgrestMultirangeFilters extensionBound> >multirange. -
rangeGte(
PostgresMultirange< Bound> multirange) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose multirange does not extend to the left ofRow, PostgresMultirange< , provided by the PostgrestMultirangeFilters extensionBound> >multirange. -
rangeGte(
PostgresRange< Bound> range) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose range does not extend to the left ofRow, PostgresRange< , provided by the PostgrestRangeFilters extensionBound> >range. -
rangeLt(
PostgresRange< Bound> range) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose range is strictly to the left ofRow, PostgresRange< , provided by the PostgrestRangeFilters extensionBound> >range. -
rangeLt(
PostgresMultirange< Bound> multirange) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose multirange is strictly to the left ofRow, PostgresMultirange< , provided by the PostgrestMultirangeFilters extensionBound> >multirange. -
rangeLte(
PostgresRange< Bound> range) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose range does not extend to the right ofRow, PostgresRange< , provided by the PostgrestRangeFilters extensionBound> >range. -
rangeLte(
PostgresMultirange< Bound> multirange) → PostgrestFilter<Row> -
Available on PostgrestFilterableExpression<
Only rows whose multirange does not extend to the right ofRow, PostgresMultirange< , provided by the PostgrestMultirangeFilters extensionBound> >multirange. -
raw(
String operand) → PostgrestFilter< Row> -
Applies an operator this package has no method for, keeping the column
compile-time checked.
inherited
-
sum(
) → PostgrestDerivedExpression< Row, double> -
The sum of this expression across the group, typed double whatever
the column's type. Past 2^53 the value rounds silently.
inherited
-
textSearch(
String query, {String? config, TextSearchType? type}) → PostgrestFilter< Row> -
Only rows whose
textortsvectorvalue matches the full text searchquery.inherited -
toString(
) → String -
A string representation of this object.
inherited
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited