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
Implemented types
Mixed-in types
Available extensions
Annotations
  • @experimental

Constructors

PostgrestNullableColumn(String name, {Value fromJson(Object json)?})
const

Properties

expression → String
The text PostgREST expects in a select list and, for a column expression, on the left of an operator. A JSON path, cast or aggregate is renamed to its responseKey in a select list.
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 order parameter, for example title.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<Row, List<Element>>, provided by the PostgrestArrayFilters extension

Only rows whose array elements are all contained in values.
containedBy(PostgresRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range lies within range.
containedBy(PostgresMultirange<Bound> multirange) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresMultirange<Bound>>, provided by the PostgrestMultirangeFilters extension

Only rows whose multirange lies within multirange.
containedByJson(Object? value) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgrestJson>, provided by the PostgrestJsonFilters extension

Only rows whose jsonb value is contained by value.
contains(List<Element?> values) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, List<Element>>, provided by the PostgrestArrayFilters extension

Only rows whose array contains every element of values.
contains(PostgresMultirange<Bound> multirange) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresMultirange<Bound>>, provided by the PostgrestMultirangeFilters extension

Only rows whose multirange contains every value of multirange.
contains(PostgresRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range contains every value of range.
containsElement(Bound value) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range contains value.
containsJson(Object? value) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgrestJson>, provided by the PostgrestJsonFilters extension

Only rows whose jsonb value contains value.
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<Row, String>, provided by the PostgrestTextFilters extension

Only rows matching the LIKE pattern case-insensitively.
ilikeAllOf(List<String> patterns) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, String>, provided by the PostgrestTextFilters extension

Only rows matching every one of patterns case-insensitively.
ilikeAnyOf(List<String> patterns) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, String>, provided by the PostgrestTextFilters extension

Only rows matching at least one of patterns case-insensitively.
imatchRegex(String pattern) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, String>, provided by the PostgrestTextFilters extension

Only rows matching the POSIX regular expression pattern case-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<Row, bool>, provided by the PostgrestBooleanFilters extension

Only rows where this boolean expression IS FALSE.
isNull() → PostgrestFilter<Row>
Only rows where this expression is SQL NULL.
inherited
isTrue() → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, bool>, provided by the PostgrestBooleanFilters extension

Only rows where this boolean expression IS TRUE.
jsonObject(String key) → PostgrestJsonPath<Row, PostgrestJson>
Reads a json/jsonb object key as JSON, with ->.
inherited
jsonObjectAt(int index) → PostgrestJsonPath<Row, PostgrestJson>
Reads a json/jsonb array element as JSON, with ->.
inherited
jsonText(String key) → PostgrestJsonPath<Row, String>
Reads a json/jsonb object key as text, with ->>.
inherited
jsonTextAt(int index) → PostgrestJsonPath<Row, String>
Reads a json/jsonb array element as text, with ->>.
inherited
like(String pattern) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, String>, provided by the PostgrestTextFilters extension

Only rows matching the LIKE pattern case-sensitively.
likeAllOf(List<String> patterns) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, String>, provided by the PostgrestTextFilters extension

Only rows matching every one of patterns case-sensitively.
likeAnyOf(List<String> patterns) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, String>, provided by the PostgrestTextFilters extension

Only rows matching at least one of patterns case-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<Row, String>, provided by the PostgrestTextFilters extension

Only rows matching the POSIX regular expression pattern case-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<Row, List<Element>>, provided by the PostgrestArrayFilters extension

Only rows whose array shares at least one element with values.
overlaps(PostgresMultirange<Bound> multirange) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresMultirange<Bound>>, provided by the PostgrestMultirangeFilters extension

Only rows whose multirange shares at least one value with multirange.
overlaps(PostgresRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range shares at least one value with range.
rangeAdjacent(PostgresMultirange<Bound> multirange) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresMultirange<Bound>>, provided by the PostgrestMultirangeFilters extension

Only rows whose multirange is adjacent to multirange.
rangeAdjacent(PostgresRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range is adjacent to range.
rangeGt(PostgresRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range is strictly to the right of range.
rangeGt(PostgresMultirange<Bound> multirange) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresMultirange<Bound>>, provided by the PostgrestMultirangeFilters extension

Only rows whose multirange is strictly to the right of multirange.
rangeGte(PostgresMultirange<Bound> multirange) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresMultirange<Bound>>, provided by the PostgrestMultirangeFilters extension

Only rows whose multirange does not extend to the left of multirange.
rangeGte(PostgresRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range does not extend to the left of range.
rangeLt(PostgresRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range is strictly to the left of range.
rangeLt(PostgresMultirange<Bound> multirange) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresMultirange<Bound>>, provided by the PostgrestMultirangeFilters extension

Only rows whose multirange is strictly to the left of multirange.
rangeLte(PostgresRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range does not extend to the right of range.
rangeLte(PostgresMultirange<Bound> multirange) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgresMultirange<Bound>>, provided by the PostgrestMultirangeFilters extension

Only rows whose multirange does not extend to the right of 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 text or tsvector value matches the full text search query.
inherited
toString() → String
A string representation of this object.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited