pack-priv abstract Class AbstractField<T>

$alias()

Implements org.jooq.impl.QOM.Aliasable.$alias.

The alias if any.

abs()

Implements org.jooq.Field.abs.

acos()

Implements org.jooq.Field.acos.

add(Field<?> value)

Implements org.jooq.Field.add.

An arithmetic expression to add value to this.

as(Name

The alias name

alias)

Implements org.jooq.Field.as.

Create an alias for this field.

as(Function<? super Field<T>, ? extends String> aliasFunction)

Implements org.jooq.Field.as.

Create an alias for this field.

ascii()

Implements org.jooq.Field.ascii.

This method is part of the pre-2.0 API.

atan()

Implements org.jooq.Field.atan.

atan2(Field<? extends Number> y)

Implements org.jooq.Field.atan2.

avgOver()

Implements org.jooq.Field.avgOver.

between(Field<T> minValue, Field<T> maxValue)

Implements org.jooq.Field.between, org.jooq.Field.between.

Create a condition to check this field against some bounds.

between(Field<T> minValue)

Implements org.jooq.Field.between, org.jooq.Field.between.

Create a condition to check this field against some bounds.

betweenSymmetric(Field<T> minValue, Field<T> maxValue)

Implements org.jooq.Field.betweenSymmetric, org.jooq.Field.betweenSymmetric.

Create a condition to check this field against some bounds.

betweenSymmetric(Field<T> minValue)

Implements org.jooq.Field.betweenSymmetric, org.jooq.Field.betweenSymmetric.

Create a condition to check this field against some bounds.

bitAnd(Field<T> arg2)

Implements org.jooq.Field.bitAnd, org.jooq.Field.bitAnd.

The BIT_AND operator.

bitNand(T

is wrapped as val(Object).

arg2)

Implements org.jooq.Field.bitNand.

The BIT_NAND operator.

bitNor(T

is wrapped as val(Object).

arg2)

Implements org.jooq.Field.bitNor.

The BIT_NOR operator.

bitNot()

Implements org.jooq.Field.bitNot.

The BIT_NOT operator.

bitOr(Field<T> arg2)

Implements org.jooq.Field.bitOr, org.jooq.Field.bitOr.

The BIT_OR operator.

bitXNor(Field<T> arg2)

Implements org.jooq.Field.bitXNor, org.jooq.Field.bitXNor.

The BIT_XNOR operator.

bitXor(Field<T> arg2)

Implements org.jooq.Field.bitXor, org.jooq.Field.bitXor.

The BIT_XOR operator.

cast(DataType<Z>

The data type that is used for the cast

type)

Implements org.jooq.Field.cast.

Cast this field to a dialect-specific data type.

ceil()

Implements org.jooq.Field.ceil.

charLength()

Implements org.jooq.Field.charLength.

This method is part of the pre-2.0 API.

coalesce(T option, T... options)

Implements org.jooq.Field.coalesce.

This method is part of the pre-2.0 API.

coerce(Field<Z>

The field whose type is used for the coercion

field)

Implements org.jooq.Field.coerce.

Coerce this field to the type of another field.

coerce(Class<Z>

The type that is used for the coercion

type)

Implements org.jooq.Field.coerce.

Coerce this field to another type.

collate(Name collation)

Implements org.jooq.Field.collate.

Apply a collation operator to this column expression.

comment(String comment)

Implements org.jooq.Field.comment.

Attach a Comment to this field, for use in DDL statements, such as DSLContext#createTable(Table).

compare(Comparator

The comparator to use for comparing this field with a value

comparator, T

The value to compare this field with

value)

Implements org.jooq.Field.compare.

Compare this field with a value using a dynamic comparator.

compare(Comparator

The comparator to use for comparing this field with a subselect

comparator, Select<? extends Record1<T>>

The subselect to compare this field with

query)

Implements org.jooq.Field.compare, org.jooq.Field.compare.

Compare this field with a subselect using a dynamic comparator.

concat(Field<?>... fields)

Implements org.jooq.Field.concat.

This method is part of the pre-2.0 API.

concat(char... values)

Implements org.jooq.Field.concat.

This method is part of the pre-2.0 API.

contains(Field<T> content)

Implements org.jooq.Field.contains, org.jooq.Field.contains.

The CONTAINS operator.

containsIgnoreCase(Field<T> content)

Implements org.jooq.Field.containsIgnoreCase, org.jooq.Field.containsIgnoreCase.

The CONTAINS_IGNORE_CASE operator.

convert(Converter<T, U>

The converter to be applied on any operations using this field.

converter)

Implements org.jooq.Field.convert.

Apply an ad-hoc data type Converter to this field expression.

convertFrom(Class<U>

The read-only converter to be applied on any operations using this field.

toType, Function<? super T, ? extends U> from)

Implements org.jooq.Field.convertFrom.

Apply an ad-hoc read-only data type Converter to this field expression.

convertTo(Class<U>

The write-only converter to be applied on any operations using this field.

toType, Function<? super U, ? extends T> to)

Implements org.jooq.Field.convertTo.

Apply an ad-hoc write-only data type Converter to this field expression.

cos()

Implements org.jooq.Field.cos.

cot()

Implements org.jooq.Field.cot.

count()

Implements org.jooq.Field.count.

countOver()

Implements org.jooq.Field.countOver.

decode(T search, Z result)

Implements org.jooq.Field.decode.

This method is part of the pre-2.0 API.

decode(Field<T> search, Field<Z> result)

Implements org.jooq.Field.decode, org.jooq.Field.decode.

This method is part of the pre-2.0 API.

deg()

Implements org.jooq.Field.deg.

div(Number value)

Implements org.jooq.Field.div.

An arithmetic expression dividing this by value.

divide(Number value)

Implements org.jooq.Field.divide.

An alias for div(Number).

endsWith(T

is wrapped as val(Object).

suffix)

Implements org.jooq.Field.endsWith.

The ENDS_WITH operator.

endsWithIgnoreCase(T

is wrapped as val(Object).

suffix)

Implements org.jooq.Field.endsWithIgnoreCase.

The ENDS_WITH_IGNORE_CASE operator.

eq(T arg2)

Implements org.jooq.Field.eq.

The EQ operator.

eq(Field<T> arg2)

Implements org.jooq.Field.eq, org.jooq.Field.eq.

The EQ operator.

equal(T arg2)

Implements org.jooq.Field.equal.

The EQUAL operator, an alias for the EQ operator.

equal(Field<T> arg2)

Implements org.jooq.Field.equal, org.jooq.Field.equal.

The EQUAL operator, an alias for the EQ operator.

equalIgnoreCase(String value)

Implements org.jooq.Field.equalIgnoreCase.

lower(this) = lower(value).

exp()

Implements org.jooq.Field.exp.

field(Record record)

Implements org.jooq.Field.field.

The inverse operation of Record#field(Field).

floor()

Implements org.jooq.Field.floor.

ge(T arg2)

Implements org.jooq.Field.ge.

The GE operator.

ge(Field<T> arg2)

Implements org.jooq.Field.ge, org.jooq.Field.ge.

The GE operator.

get(Record record)

Implements org.jooq.Field.get.

The inverse operation of Record#get(Field).

greaterOrEqual(T arg2)

Implements org.jooq.Field.greaterOrEqual.

The GREATER_OR_EQUAL operator, an alias for the GE operator.

greaterOrEqual(Field<T> arg2)

Implements org.jooq.Field.greaterOrEqual, org.jooq.Field.greaterOrEqual.

The GREATER_OR_EQUAL operator, an alias for the GE operator.

greaterThan(T arg2)

Implements org.jooq.Field.greaterThan.

The GREATER_THAN operator, an alias for the GT operator.

greaterThan(Field<T> arg2)

Implements org.jooq.Field.greaterThan, org.jooq.Field.greaterThan.

The GREATER_THAN operator, an alias for the GT operator.

greatest(T... others)

Implements org.jooq.Field.greatest.

gt(T arg2)

Implements org.jooq.Field.gt.

The GT operator.

gt(Field<T> arg2)

Implements org.jooq.Field.gt, org.jooq.Field.gt.

The GT operator.

in(Select<? extends Record1<T>> arg2)

Implements org.jooq.Field.in.

The IN operator.

in(Field<?>... values)

Implements org.jooq.Field.in, org.jooq.Field.in.

Create a condition to check this field against several values.

in(Result<? extends Record1<T>> result)

Implements org.jooq.Field.in.

Create a condition to check this field against several values from a previous query.

isDistinctFrom(Select<? extends Record1<T>> arg2)

Implements org.jooq.Field.isDistinctFrom, org.jooq.Field.isDistinctFrom.

The IS_DISTINCT_FROM operator.

isDocument()

Implements org.jooq.Field.isDocument.

The IS_DOCUMENT operator.

isJson()

Implements org.jooq.Field.isJson.

The IS_JSON operator.

isNotDistinctFrom(Select<? extends Record1<T>> arg2)

Implements org.jooq.Field.isNotDistinctFrom, org.jooq.Field.isNotDistinctFrom.

The IS_NOT_DISTINCT_FROM operator.

isNotDocument()

Implements org.jooq.Field.isNotDocument.

The IS_NOT_DOCUMENT operator.

isNotNull()

Implements org.jooq.Field.isNotNull.

The IS_NOT_NULL operator.

isTrue()

Implements org.jooq.Field.isTrue.

Create a condition to check this field against known string literals for true.

lag(int offset)

Implements org.jooq.Field.lag.

lag(int offset, Field<T> defaultValue)

Implements org.jooq.Field.lag, org.jooq.Field.lag.

le(T arg2)

Implements org.jooq.Field.le.

The LE operator.

le(Field<T> arg2)

Implements org.jooq.Field.le, org.jooq.Field.le.

The LE operator.

lead()

Implements org.jooq.Field.lead.

lead(int offset, T defaultValue)

Implements org.jooq.Field.lead.

least(T... others)

Implements org.jooq.Field.least.

length()

Implements org.jooq.Field.length.

This method is part of the pre-2.0 API.

lessOrEqual(Select<? extends Record1<T>> arg2)

Implements org.jooq.Field.lessOrEqual, org.jooq.Field.lessOrEqual.

The LESS_OR_EQUAL operator, an alias for the LE operator.

lessOrEqual(QuantifiedSelect<? extends Record1<T>> arg2)

Implements org.jooq.Field.lessOrEqual, org.jooq.Field.lessOrEqual.

The LESS_OR_EQUAL operator, an alias for the LE operator.

lessThan(Select<? extends Record1<T>> arg2)

Implements org.jooq.Field.lessThan, org.jooq.Field.lessThan.

The LESS_THAN operator, an alias for the LT operator.

lessThan(QuantifiedSelect<? extends Record1<T>> arg2)

Implements org.jooq.Field.lessThan, org.jooq.Field.lessThan.

The LESS_THAN operator, an alias for the LT operator.

like(Field<String> pattern)

Implements org.jooq.Field.like.

The LIKE operator.

like(String value, char escape)

Implements org.jooq.Field.like.

Create a condition to pattern-check this field against a value.

likeIgnoreCase(String

is wrapped as val(Object).

pattern)

Implements org.jooq.Field.likeIgnoreCase.

The LIKE_IGNORE_CASE operator.

likeIgnoreCase(String value, char escape)

Implements org.jooq.Field.likeIgnoreCase.

Create a condition to case-insensitively pattern-check this field against a value.

likeRegex(String pattern)

Implements org.jooq.Field.likeRegex.

Create a condition to regex-pattern-check this field against a pattern.

ln()

Implements org.jooq.Field.ln.

lower()

Implements org.jooq.Field.lower.

This method is part of the pre-2.0 API.

lpad(int length)

Implements org.jooq.Field.lpad.

This method is part of the pre-2.0 API.

lpad(int length, char character)

Implements org.jooq.Field.lpad.

This method is part of the pre-2.0 API.

lt(Select<? extends Record1<T>> arg2)

Implements org.jooq.Field.lt, org.jooq.Field.lt.

The LT operator.

lt(QuantifiedSelect<? extends Record1<T>> arg2)

Implements org.jooq.Field.lt, org.jooq.Field.lt.

The LT operator.

max()

Implements org.jooq.Field.max.

median()

Implements org.jooq.Field.median.

minOver()

Implements org.jooq.Field.minOver.

minus(Field<?> value)

Implements org.jooq.Field.minus.

An alias for sub(Field).

mod(Field<? extends Number> divisor)

Implements org.jooq.Field.mod.

The MOD operator.

modulo(Field<? extends Number> divisor)

Implements org.jooq.Field.modulo.

The MODULO operator, an alias for the MOD operator.

mul(Field<? extends Number> value)

Implements org.jooq.Field.mul.

An arithmetic expression multiplying this with value.

multiply(Field<? extends Number> value)

Implements org.jooq.Field.multiply.

An alias for mul(Field).

ne(Select<? extends Record1<T>> arg2)

Implements org.jooq.Field.ne, org.jooq.Field.ne.

The NE operator.

ne(QuantifiedSelect<? extends Record1<T>> arg2)

Implements org.jooq.Field.ne, org.jooq.Field.ne.

The NE operator.

notBetween(T minValue, T maxValue)

Implements org.jooq.Field.notBetween.

Create a condition to check this field against some bounds.

notBetween(T minValue)

Implements org.jooq.Field.notBetween.

Create a condition to check this field against some bounds.

notBetweenSymmetric(T minValue, T maxValue)

Implements org.jooq.Field.notBetweenSymmetric.

Create a condition to check this field against some bounds.

notBetweenSymmetric(T minValue)

Implements org.jooq.Field.notBetweenSymmetric.

Create a condition to check this field against some bounds.

notContains(T value)

Implements org.jooq.Field.notContains.

Inverse of contains(Object).

notContainsIgnoreCase(T value)

Implements org.jooq.Field.notContainsIgnoreCase.

Inverse of containsIgnoreCase(Object)

notEqual(T arg2)

Implements org.jooq.Field.notEqual.

The NOT_EQUAL operator, an alias for the NE operator.

notEqual(Field<T> arg2)

Implements org.jooq.Field.notEqual, org.jooq.Field.notEqual.

The NOT_EQUAL operator, an alias for the NE operator.

notEqualIgnoreCase(String value)

Implements org.jooq.Field.notEqualIgnoreCase.

lower(this) != lower(value).

notIn(Select<? extends Record1<T>> arg2)

Implements org.jooq.Field.notIn.

The NOT_IN operator.

notIn(Field<?>... values)

Implements org.jooq.Field.notIn, org.jooq.Field.notIn.

Create a condition to check this field against several values.

notIn(Result<? extends Record1<T>> result)

Implements org.jooq.Field.notIn.

Create a condition to check this field against several values from a previous query.

notLike(Field<String> pattern)

Implements org.jooq.Field.notLike.

The NOT_LIKE operator.

notLike(String value, char escape)

Implements org.jooq.Field.notLike.

Create a condition to pattern-check this field against a value.

notLikeIgnoreCase(String

is wrapped as val(Object).

pattern)

Implements org.jooq.Field.notLikeIgnoreCase.

The NOT_LIKE_IGNORE_CASE operator.

notLikeIgnoreCase(String value, char escape)

Implements org.jooq.Field.notLikeIgnoreCase.

Create a condition to case-insensitively pattern-check this field against a value.

notLikeRegex(String pattern)

Implements org.jooq.Field.notLikeRegex.

Create a condition to regex-pattern-check this field against a pattern.

notSimilarTo(String

is wrapped as val(Object).

pattern)

Implements org.jooq.Field.notSimilarTo.

The NOT_SIMILAR_TO operator.

notSimilarTo(QuantifiedSelect<? extends Record1<String>> pattern)

Implements org.jooq.Field.notSimilarTo.

The NOT_SIMILAR_TO operator.

notSimilarTo(Field<String> field, char escape)

Implements org.jooq.Field.notSimilarTo.

Create a condition to pattern-check this field against a field.

nullif(Field<T> other)

Implements org.jooq.Field.nullif, org.jooq.Field.nullif.

This method is part of the pre-2.0 API.

nullsLast()

Implements org.jooq.Field.nullsLast.

Convenience method for sortDefault() and then SortField#nullsLast().

nvl(T defaultValue)

Implements org.jooq.Field.nvl.

This method is part of the pre-2.0 API.

nvl2(Z valueIfNotNull, Z valueIfNull)

Implements org.jooq.Field.nvl2.

This method is part of the pre-2.0 API.

octetLength()

Implements org.jooq.Field.octetLength.

This method is part of the pre-2.0 API.

plus(Field<?> value)

Implements org.jooq.Field.plus.

An alias for add(Field).

position(Field<String> search)

Implements org.jooq.Field.position.

This method is part of the pre-2.0 API.

pow(Field<? extends Number> exponent)

Implements org.jooq.Field.pow.

The POW operator, an alias for the POWER operator.

power(Field<? extends Number> exponent)

Implements org.jooq.Field.power.

The POWER operator.

rad()

Implements org.jooq.Field.rad.

rem(Field<? extends Number> divisor)

Implements org.jooq.Field.rem.

The REM operator, an alias for the MOD operator.

repeat(Field<? extends Number> count)

Implements org.jooq.Field.repeat.

This method is part of the pre-2.0 API.