- Type Parameters:
T- The field type
- All Superinterfaces:
FieldOrConstraint,FieldOrRow,GroupField,Named,OrderField<T>,QueryPart,SelectField<T>,SelectFieldOrAsterisk,Serializable,Typed<T>
- All Known Subinterfaces:
AggregateFilterStep<T>,AggregateFunction<T>,ArrayAggOrderByStep<T>,CaseConditionStep<T>,CaseWhenStep<V,T>,GroupConcatOrderByStep,GroupConcatSeparatorStep,JSONArrayAggNullStep<T>,JSONArrayAggOrderByStep<J>,JSONArrayAggReturningStep<T>,JSONArrayNullStep<T>,JSONArrayReturningStep<T>,JSONObjectAggNullStep<T>,JSONObjectAggReturningStep<T>,JSONObjectNullStep<T>,JSONObjectReturningStep<T>,JSONValueOnStep<J>,JSONValueReturningStep<T>,Param<T>,Parameter<T>,ParamOrVariable<T>,TableField<R,T>,UDTField<R,T>,Variable<T>,WindowBeforeOverStep<T>,WindowExcludeStep<T>,WindowFinalStep<T>,WindowOrderByStep<T>,WindowPartitionByStep<T>,WindowRowsStep<T>,XMLAggOrderByStep<T>
- All Known Implementing Classes:
CustomField
Column expressions or fields can be used in a variety of SQL statements and clauses, including (non-exhaustive list):
SELECTclause, e.g. throughDSL.select(SelectField)(everyFieldis a subtype ofSelectField)WHEREclause, e.g. throughSelectWhereStep.where(Field)(Field<Boolean>can behave like aCondition, regardless if your RDBMS supports theBOOLEANtype)GROUP BYclause, e.g. throughSelectGroupByStep.groupBy(GroupField...)(everyFieldis a subtype ofGroupField)HAVINGclause, e.g. throughSelectHavingStep.having(Field)ORDER BYclause, e.g. throughSelectOrderByStep.orderBy(OrderField)(everyFieldis a subtype ofOrderField)- When creating a
Condition, e.g. througheq(Field) - As a function argument, e.g. through
DSL.abs(Field) - Many more...
Example:
// Assuming import static org.jooq.impl.DSL.*;
using(configuration)
.select(ACTOR.LAST_NAME) // Field reference
.from(ACTOR)
.groupBy(ACTOR.LAST_NAME) // Field reference
.orderBy(ACTOR.LAST_NAME) // Field reference
.fetch();
Instances can be created using a variety of ways, including:
DSL.field(String)and overloads for plain SQL field expression.DSL.field(Name)and overloads for field identifier references.DSL.field(Condition)for predicates as fields.DSL.field(Select)for correlated subqueries.TableFieldreferenced from generated tablesDSL.val(Object)and overloads to create bind variables explicitlyDSL.inline(Object)and overloads to create inline values (constants, literals) explicitly
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescriptionabs()Deprecated, for removal: This API element is subject to removal in a future version.@NotNull Field<BigDecimal>acos()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.acos(Field)instead.An arithmetic expression adding this to value.An arithmetic expression to add value to this.Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.asc()Create an ascending sort field from this field.ascii()Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.ascii(Field)instead.@NotNull Field<BigDecimal>asin()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.asin(Field)instead.@NotNull Field<BigDecimal>atan()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.atan(Field)instead.@NotNull Field<BigDecimal>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.atan2(Field, Number)instead.@NotNull Field<BigDecimal>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.atan2(Field, Field)instead.@NotNull Field<BigDecimal>avg()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.avg(Field)instead.@NotNull WindowPartitionByStep<BigDecimal>avgOver()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.avg(Field)instead.@NotNull BetweenAndStep<T>Create a condition to check this field against some bounds.@NotNull ConditionCreate a condition to check this field against some bounds.@NotNull BetweenAndStep<T>Create a condition to check this field against some bounds.@NotNull ConditionCreate a condition to check this field against some bounds.@NotNull BetweenAndStep<T>betweenSymmetric(Field<T> minValue)Create a condition to check this field against some bounds.@NotNull ConditionbetweenSymmetric(Field<T> minValue, Field<T> maxValue)Create a condition to check this field against some bounds.@NotNull BetweenAndStep<T>betweenSymmetric(T minValue)Create a condition to check this field against some bounds.@NotNull ConditionbetweenSymmetric(T minValue, T maxValue)Create a condition to check this field against some bounds.The bitwise and operator.The bitwise and operator.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.bitLength(Field)instead.The bitwise not and operator.The bitwise not and operator.The bitwise not or operator.The bitwise not or operator.bitNot()The bitwise not operator.The bitwise or operator.The bitwise or operator.The bitwise not xor operator.The bitwise not xor operator.The bitwise xor operator.The bitwise xor operator.<Z> @NotNull Field<Z>Cast this field to another type.<Z> @NotNull Field<Z>Cast this field to a dialect-specific data type.<Z> @NotNull Field<Z>Cast this field to the type of another field.ceil()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.ceil(Field)instead.booleanThe inverse operation ofRecord.changed(Field).Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.charLength(Field)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.coalesce(Field, Field...)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.coalesce(Object, Object...)instead.<Z> @NotNull Field<Z>Coerce this field to another type.<Z> @NotNull Field<Z>Coerce this field to a dialect-specific data type.<Z> @NotNull Field<Z>Coerce this field to the type of another field.Apply a collation operator to this column expression.Apply a collation operator to this column expression.Apply a collation operator to this column expression.@NotNull Conditioncompare(Comparator comparator, Field<T> field)Compare this field with another field using a dynamic comparator.@NotNull Conditioncompare(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query)Compare this field with a quantified subselect using a dynamic comparator.@NotNull Conditioncompare(Comparator comparator, Select<? extends Record1<T>> query)Compare this field with a subselect using a dynamic comparator.@NotNull Conditioncompare(Comparator comparator, T value)Compare this field with a value using a dynamic comparator.concat(char... values)This method is part of the pre-2.0 API.This method is part of the pre-2.0 API.This method is part of the pre-2.0 API.@NotNull ConditionConvenience method forlike(String, char)including proper adding of wildcards and escaping.@NotNull ConditionConvenience method forlike(String, char)including proper adding of wildcards and escaping.@NotNull ConditioncontainsIgnoreCase(Field<T> value)Convenience method forlikeIgnoreCase(String, char)including proper adding of wildcards and escaping.@NotNull ConditioncontainsIgnoreCase(T value)Convenience method forlikeIgnoreCase(String, char)including proper adding of wildcards and escaping.<U> @NotNull Field<U>convert(Class<U> toType, Function<? super T,? extends U> from, Function<? super U,? extends T> to)Apply an ad-hoc data typeConverterto this field expression.<U> @NotNull Field<U>Apply an ad-hoc data typeBindingto this field expression.<U> @NotNull Field<U>Apply an ad-hoc data typeConverterto this field expression.<U> @NotNull Field<U>convertFrom(Class<U> toType, Function<? super T,? extends U> from)Apply an ad-hoc read-only data typeConverterto this field expression.<U> @NotNull Field<U>convertFrom(Function<? super T,? extends U> from)Apply an ad-hoc read-only data typeConverterto this field expression.<U> @NotNull Field<U>Apply an ad-hoc write-only data typeConverterto this field expression.<U> @NotNull Field<U>Apply an ad-hoc write-only data typeConverterto this field expression.@NotNull Field<BigDecimal>cos()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.cos(Field)instead.@NotNull Field<BigDecimal>cosh()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.cosh(Field)instead.@NotNull Field<BigDecimal>cot()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.cot(Field)instead.@NotNull Field<BigDecimal>coth()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.coth(Field)instead.count()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.count(Field)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.countDistinct(Field)instead.@NotNull WindowPartitionByStep<Integer>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.count(Field)instead.<Z> @NotNull Field<Z>Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.decode(Field, Field, Field)instead.<Z> @NotNull Field<Z>Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.decode(Field, Field, Field, Field...)instead.<Z> @NotNull Field<Z>Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.decode(Object, Object, Object)instead.<Z> @NotNull Field<Z>Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.decode(Object, Object, Object, Object...)instead.@NotNull Field<BigDecimal>deg()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.deg(Field)instead.desc()Create a descending sort field from this field.An arithmetic expression dividing this by value.An arithmetic expression dividing this by value.An alias fordiv(Number).An alias fordiv(Field).@NotNull ConditionConvenience method forlike(String, char)including proper adding of wildcards and escaping.@NotNull ConditionConvenience method forlike(String, char)including proper adding of wildcards and escaping.@NotNull ConditionendsWithIgnoreCase(Field<T> value)Convenience method forlike(String, char)including proper adding of wildcards and escaping.@NotNull ConditionendsWithIgnoreCase(T value)Convenience method forlike(String, char)including proper adding of wildcards and escaping.@NotNull Conditionthis = field.@NotNull Conditioneq(QuantifiedSelect<? extends Record1<T>> query)this = [quantifier] (Select<?> ...).@NotNull Conditionthis = (Select<?> ...).@NotNull Conditionthis = value.@NotNull Conditionthis = field.@NotNull Conditionequal(QuantifiedSelect<? extends Record1<T>> query)this = [quantifier] (Select<?> ...).@NotNull Conditionthis = (Select<?> ...).@NotNull Conditionthis = value.@NotNull ConditionequalIgnoreCase(String value)lower(this) = lower(value).@NotNull ConditionequalIgnoreCase(Field<String> value)lower(this) = lower(value).booleanCheck whether thisQueryPartcan be considered equal to anotherQueryPart.@NotNull Field<BigDecimal>exp()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.exp(Field)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.extract(Field, DatePart)instead.The inverse operation ofFields.field(Field).@NotNull WindowIgnoreNullsStep<T>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.firstValue(Field)instead.floor()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.floor(Field)instead.The inverse operation ofRecord.into(Field).@NotNull Conditionthis >= field.@NotNull Conditionge(QuantifiedSelect<? extends Record1<T>> query)this >= [quantifier] (Select<?> ...).@NotNull Conditionthis >= (Select<?> ...).@NotNull Conditionthis >= value.The inverse operation ofRecord.get(Field).@NotNull StringThe comment given to the field.@NotNull StringgetName()The name of the field.The inverse operation ofRecord.getValue(Field).@NotNull ConditiongreaterOrEqual(Field<T> field)this >= field.@NotNull ConditiongreaterOrEqual(QuantifiedSelect<? extends Record1<T>> query)this >= [quantifier] (Select<?> ...).@NotNull ConditiongreaterOrEqual(Select<? extends Record1<T>> query)this >= (Select<?> ...).@NotNull ConditiongreaterOrEqual(T value)this >= value.@NotNull ConditiongreaterThan(Field<T> field)this > field.@NotNull ConditiongreaterThan(QuantifiedSelect<? extends Record1<T>> query)this > [quantifier] (Select<?> ...).@NotNull ConditiongreaterThan(Select<? extends Record1<T>> query)this > (Select<?> ...).@NotNull ConditiongreaterThan(T value)this > value.Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.greatest(Field, Field...)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.greatest(Field, Field...)instead.@NotNull Conditionthis > field.@NotNull Conditiongt(QuantifiedSelect<? extends Record1<T>> query)this > [quantifier] (Select<?> ...).@NotNull Conditionthis > (Select<?> ...).@NotNull Conditionthis > value.@NotNull Conditionin(Collection<?> values)Create a condition to check this field against several values.@NotNull ConditionCreate a condition to check this field against several values.@NotNull ConditionCreate a condition to check this field against several values from a previous query.@NotNull ConditionCreate a condition to check this field against a subquery.@NotNull ConditionCreate a condition to check this field against several values.@NotNull ConditionisDistinctFrom(Field<T> field)Create a condition to check if this field isDISTINCTfrom another field.@NotNull ConditionisDistinctFrom(Select<? extends Record1<T>> select)Create a condition to check if this field isDISTINCTfrom another field.@NotNull ConditionisDistinctFrom(T value)Create a condition to check if this field isDISTINCTfrom another value.@NotNull ConditionCreate a condition to check if this field contains XML data.@NotNull ConditionisFalse()Create a condition to check this field against known string literals forfalse.@NotNull ConditionisJson()Create a condition to check if this field contains JSON data.@NotNull ConditionisNotDistinctFrom(Field<T> field)Create a condition to check if this field isNOT DISTINCTfrom another field.@NotNull ConditionisNotDistinctFrom(Select<? extends Record1<T>> select)Create a condition to check if this field isNOT DISTINCTfrom another field.@NotNull ConditionisNotDistinctFrom(T value)Create a condition to check if this field isNOT DISTINCTfrom another value.@NotNull ConditionCreate a condition to check if this field does not contain XML data.@NotNull ConditionCreate a condition to check if this field does not contain JSON data.@NotNull ConditionCreate a condition to check this field againstnull.@NotNull ConditionisNull()Create a condition to check this field againstnull.@NotNull ConditionisTrue()Create a condition to check this field against known string literals fortrue.@NotNull WindowIgnoreNullsStep<T>lag()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lag(Field)instead.@NotNull WindowIgnoreNullsStep<T>lag(int offset)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lag(Field, int)instead.@NotNull WindowIgnoreNullsStep<T>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lag(Field, int, Field)instead.@NotNull WindowIgnoreNullsStep<T>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lag(Field, int, Object)instead.@NotNull WindowIgnoreNullsStep<T>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lastValue(Field)instead.@NotNull Conditionthis <= field.@NotNull Conditionle(QuantifiedSelect<? extends Record1<T>> query)this <= [quantifier] (Select<?> ...).@NotNull Conditionthis <= (Select<?> ...).@NotNull Conditionthis <= value.@NotNull WindowIgnoreNullsStep<T>lead()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lead(Field)instead.@NotNull WindowIgnoreNullsStep<T>lead(int offset)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lead(Field, int)instead.@NotNull WindowIgnoreNullsStep<T>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lead(Field, int, Field)instead.@NotNull WindowIgnoreNullsStep<T>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lead(Field, int, Object)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.least(Field, Field...)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.least(Field, Field...)instead.length()Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.length(Field)instead.@NotNull ConditionlessOrEqual(Field<T> field)this <= field.@NotNull ConditionlessOrEqual(QuantifiedSelect<? extends Record1<T>> query)this <= [quantifier] (Select<?> ...).@NotNull ConditionlessOrEqual(Select<? extends Record1<T>> query)this <= (Select<?> ...).@NotNull ConditionlessOrEqual(T value)this <= value.@NotNull Conditionthis < field.@NotNull ConditionlessThan(QuantifiedSelect<? extends Record1<T>> query)this < [quantifier] (Select<?> ...).@NotNull Conditionthis < (Select<?> ...).@NotNull Conditionthis < value.@NotNull LikeEscapeStepCreate a condition to pattern-check this field against a value.@NotNull ConditionCreate a condition to pattern-check this field against a value.@NotNull LikeEscapeStepCreate a condition to pattern-check this field against a value.@NotNull ConditionCreate a condition to pattern-check this field against a value.@NotNull LikeEscapeSteplike(QuantifiedSelect<Record1<String>> query)Create a condition to pattern-check this field against a quantified select.@NotNull LikeEscapeSteplikeIgnoreCase(String value)Create a condition to case-insensitively pattern-check this field against a value.@NotNull ConditionlikeIgnoreCase(String value, char escape)Create a condition to case-insensitively pattern-check this field against a value.@NotNull LikeEscapeSteplikeIgnoreCase(Field<String> field)Create a condition to case-insensitively pattern-check this field against a field.@NotNull ConditionlikeIgnoreCase(Field<String> field, char escape)Create a condition to case-insensitively pattern-check this field against a field.@NotNull ConditionCreate a condition to regex-pattern-check this field against a pattern.@NotNull ConditionCreate a condition to regex-pattern-check this field against a pattern.@NotNull Field<BigDecimal>ln()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.ln(Field)instead.@NotNull Field<BigDecimal>log(int base)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.log(Field, int)instead.lower()Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.lower(Field)instead.lpad(int length)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.lpad(Field, int)instead.lpad(int length, char character)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.lpad(Field, int, char)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.lpad(Field, Field)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.lpad(Field, Field, Field)instead.@NotNull Conditionthis < field.@NotNull Conditionlt(QuantifiedSelect<? extends Record1<T>> query)this < [quantifier] (Select<?> ...).@NotNull Conditionthis < (Select<?> ...).@NotNull Conditionthis < value.ltrim()Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.ltrim(Field)instead.max()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.max(Field)instead.@NotNull WindowPartitionByStep<T>maxOver()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.max(Field)instead.@NotNull Field<BigDecimal>median()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.median(Field)instead.min()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.min(Field)instead.@NotNull WindowPartitionByStep<T>minOver()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.min(Field)instead.An alias forsub(Number).An alias forsub(Field).An arithmetic expression getting the modulo of this divided by value.An arithmetic expression getting the modulo of this divided by value.An alias formod(Number).An alias formod(Field).An arithmetic expression multiplying this with value.An arithmetic expression multiplying this with value.An alias formul(Number).An alias formul(Field).@NotNull Conditionthis != field.@NotNull Conditionne(QuantifiedSelect<? extends Record1<T>> query)this != [quantifier] (Select<?> ...).@NotNull Conditionthis != (Select<?> ...).@NotNull Conditionthis != value.neg()Negate this field to get its negative value.@NotNull BetweenAndStep<T>notBetween(Field<T> minValue)Create a condition to check this field against some bounds.@NotNull ConditionnotBetween(Field<T> minValue, Field<T> maxValue)Create a condition to check this field against some bounds.@NotNull BetweenAndStep<T>notBetween(T minValue)Create a condition to check this field against some bounds.@NotNull ConditionnotBetween(T minValue, T maxValue)Create a condition to check this field against some bounds.@NotNull BetweenAndStep<T>notBetweenSymmetric(Field<T> minValue)Create a condition to check this field against some bounds.@NotNull ConditionnotBetweenSymmetric(Field<T> minValue, Field<T> maxValue)Create a condition to check this field against some bounds.@NotNull BetweenAndStep<T>notBetweenSymmetric(T minValue)Create a condition to check this field against some bounds.@NotNull ConditionnotBetweenSymmetric(T minValue, T maxValue)Create a condition to check this field against some bounds.@NotNull ConditionnotContains(Field<T> value)Inverse ofcontains(Field).@NotNull ConditionnotContains(T value)Inverse ofcontains(Object).@NotNull ConditionnotContainsIgnoreCase(Field<T> value)Inverse ofcontainsIgnoreCase(Field)@NotNull ConditionnotContainsIgnoreCase(T value)Inverse ofcontainsIgnoreCase(Object)@NotNull Conditionthis != field.@NotNull ConditionnotEqual(QuantifiedSelect<? extends Record1<T>> query)this != [quantifier] (Select<?> ...).@NotNull Conditionthis != (Select<?> ...).@NotNull Conditionthis != value.@NotNull ConditionnotEqualIgnoreCase(String value)lower(this) != lower(value).@NotNull ConditionnotEqualIgnoreCase(Field<String> value)lower(this) != lower(value).@NotNull ConditionnotIn(Collection<?> values)Create a condition to check this field against several values.@NotNull ConditionCreate a condition to check this field against several values.@NotNull ConditionCreate a condition to check this field against several values from a previous query.@NotNull ConditionCreate a condition to check this field against a subquery.@NotNull ConditionCreate a condition to check this field against several values.@NotNull LikeEscapeStepCreate a condition to pattern-check this field against a value.@NotNull ConditionCreate a condition to pattern-check this field against a value.@NotNull LikeEscapeStepCreate a condition to pattern-check this field against a field.@NotNull ConditionCreate a condition to pattern-check this field against a field.@NotNull LikeEscapeStepnotLike(QuantifiedSelect<Record1<String>> query)Create a condition to pattern-check this field against a quantified select.@NotNull LikeEscapeStepnotLikeIgnoreCase(String value)Create a condition to case-insensitively pattern-check this field against a value.@NotNull ConditionnotLikeIgnoreCase(String value, char escape)Create a condition to case-insensitively pattern-check this field against a value.@NotNull LikeEscapeStepnotLikeIgnoreCase(Field<String> field)Create a condition to case-insensitively pattern-check this field against a field.@NotNull ConditionnotLikeIgnoreCase(Field<String> field, char escape)Create a condition to case-insensitively pattern-check this field against a field.@NotNull ConditionnotLikeRegex(String pattern)Create a condition to regex-pattern-check this field against a pattern.@NotNull ConditionnotLikeRegex(Field<String> pattern)Create a condition to regex-pattern-check this field against a pattern.@NotNull LikeEscapeStepnotSimilarTo(String value)Create a condition to pattern-check this field against a value.@NotNull ConditionnotSimilarTo(String value, char escape)Create a condition to pattern-check this field against a value.@NotNull LikeEscapeStepnotSimilarTo(Field<String> field)Create a condition to pattern-check this field against a field.@NotNull ConditionnotSimilarTo(Field<String> field, char escape)Create a condition to pattern-check this field against a field.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.nullif(Field, Field)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.nullif(Field, Object)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.nvl(Field, Field)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.nvl(Field, Object)instead.<Z> @NotNull Field<Z>Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.nvl2(Field, Field, Field)instead.<Z> @NotNull Field<Z>nvl2(Z valueIfNotNull, Z valueIfNull)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.nvl2(Field, Object, Object)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.octetLength(Field)instead.The inverse operation ofRecord.original(Field).plus()Turn this field into an Oracle-specific field for use in outer-join predicates.An alias foradd(Number).An alias foradd(Field).Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.position(Field, String)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.position(Field, Field)instead.@NotNull Field<BigDecimal>An arithmetic expression getting this value raised to the power ofexponent.@NotNull Field<BigDecimal>An arithmetic expression getting this value raised to the power ofexponent.@NotNull Field<BigDecimal>An alias forpower(Number).@NotNull Field<BigDecimal>An alias forpower(Field).@NotNull Field<BigDecimal>rad()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.rad(Field)instead.An alias formod(Number).An alias formod(Field).Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.repeat(Field, int)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.repeat(Field, Field)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.replace(Field, String)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.replace(Field, String, String)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.replace(Field, Field)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.replace(Field, Field, Field)instead.voidThe inverse operation ofRecord.reset(Field).round()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.round(Field)instead.round(int decimals)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.round(Field, int)instead.rpad(int length)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.rpad(Field, int)instead.rpad(int length, char character)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.rpad(Field, int, char)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.rpad(Field, Field)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.rpad(Field, Field, Field)instead.rtrim()Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.rtrim(Field)instead.The bitwise left shift operator.The bitwise left shift operator.The bitwise right shift operator.The bitwise right shift operator.sign()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.sign(Field)instead.@NotNull LikeEscapeStepCreate a condition to pattern-check this field against a value.@NotNull ConditionCreate a condition to pattern-check this field against a value.@NotNull LikeEscapeStepCreate a condition to pattern-check this field against a value.@NotNull ConditionCreate a condition to pattern-check this field against a value.@NotNull Field<BigDecimal>sin()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.sin(Field)instead.@NotNull Field<BigDecimal>sinh()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.sinh(Field)instead.<Z> @NotNull SortField<Z>Create an indirected sort field.Create an ascending/descending sort field from this field.sortAsc(Collection<T> sortList)Create an indirected sort field.Create an indirected sort field.Create a default sorted (implicitASC) from this field.sortDesc(Collection<T> sortList)Create an indirected sort field.Create an indirected sort field.@NotNull Field<BigDecimal>sqrt()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.sqrt(Field)instead.@NotNull ConditionstartsWith(Field<T> value)Convenience method forlike(String, char)including proper adding of wildcards and escaping.@NotNull ConditionstartsWith(T value)Convenience method forlike(String, char)including proper adding of wildcards and escaping.@NotNull ConditionstartsWithIgnoreCase(Field<T> value)Convenience method forlike(String, char)including proper adding of wildcards and escaping.@NotNull ConditionstartsWithIgnoreCase(T value)Convenience method forlike(String, char)including proper adding of wildcards and escaping.@NotNull Field<BigDecimal>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.stddevPop(Field)instead.@NotNull WindowPartitionByStep<BigDecimal>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.stddevPop(Field)instead.@NotNull Field<BigDecimal>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.stddevSamp(Field)instead.@NotNull WindowPartitionByStep<BigDecimal>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.stddevSamp(Field)instead.An arithmetic expression subtracting value from this.An arithmetic expression subtracting value from this.substring(int startingPosition)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.substring(Field, int)instead.substring(int startingPosition, int length)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.substring(Field, int, int)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.substring(Field, Field)instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.substring(Field, Field, Field)instead.An alias forsub(Number).An alias forsub(Field).@NotNull Field<BigDecimal>sum()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.sum(Field)instead.@NotNull WindowPartitionByStep<BigDecimal>sumOver()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.sum(Field)instead.@NotNull Field<BigDecimal>tan()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.tan(Field)instead.@NotNull Field<BigDecimal>tanh()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.tanh(Field)instead.An alias formul(Number).An alias formul(Field).trim()Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.trim(Field)instead.Negate this field to get its negative value.Get this field as its positive value (no effect on SQL).upper()Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.upper(Field)instead.@NotNull Field<BigDecimal>varPop()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.varPop(Field)instead.@NotNull WindowPartitionByStep<BigDecimal>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.varPop(Field)instead.@NotNull Field<BigDecimal>varSamp()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.varSamp(Field)instead.@NotNull WindowPartitionByStep<BigDecimal>Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.varSamp(Field)instead.Methods inherited from interface org.jooq.Named
getCommentPart, getQualifiedName, getUnqualifiedNameMethods inherited from interface org.jooq.SelectField
as, as, asMethods inherited from interface org.jooq.Typed
getBinding, getConverter, getDataType, getDataType, getType
-
Method Details
-
getName
The name of the field.The name is any of these:
- The formal name of the field, if it is a physical table/view field
- The alias of an aliased field
- A generated / unspecified value for any other expression
- The name of a parameter if it is a named
Param
-
getComment
The comment given to the field.If this
Fieldis a generated field from your database, it may provide its DDL comment through this method. All other column expressions return the empty string""here, nevernull.- Specified by:
getCommentin interfaceNamed
-
as
@Deprecated(forRemoval=true, since="3.14") @NotNull @Support @NotNull Field<T> as(Function<? super Field<T>,? extends String> aliasFunction)Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ. They offer convenience that is unidiomatic for jOOQ's DSL, without offering functionality that would not be possible otherwise - yet they add complexity in jOOQ's internals.Create an alias for this field.Note that the case-sensitivity of the returned field depends on
Settings.getRenderQuotedNames(). By default, field aliases are quoted, and thus case-sensitive in many SQL dialects!This works like
SelectField.as(String), except that field aliases are provided by a function. This is useful, for instance, to prefix all columns with a common prefix (onTable.as(String, Function)):MY_TABLE.as("t1", f -> "prefix_" + f.getName());And then to use the same function also for individual fields:
MY_TABLE.MY_COLUMN.as(f -> "prefix_" + f.getName());
-
equals
Check whether thisQueryPartcan be considered equal to anotherQueryPart.In general,
QueryPartequality is defined in terms ofQueryPart.toString()equality. In other words, two query parts are considered equal if their rendered SQL (with inlined bind variables) is equal. This means that the two query parts do not necessarily have to be of the same type.Some
QueryPartimplementations may choose to override this behaviour for improved performance, asQueryPart.toString()is an expensive operation, if called many times.Watch out! This is
Object.equals(Object), not a jOOQ DSL feature! -
convert
Apply an ad-hoc data typeBindingto this field expression.Rather than attaching data type bindings at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataType(Binding), this method allows for creating a derived field expression with an ad-hoc data type binding for single query usage.- Type Parameters:
U- The user type.- Parameters:
binding- The binding to be applied on any operations using this field.- Returns:
- A derived field expression using a new binding.
-
convert
Apply an ad-hoc data typeConverterto this field expression.Rather than attaching data type converters at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataType(Converter), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.- Type Parameters:
U- The user type.- Parameters:
converter- The converter to be applied on any operations using this field.- Returns:
- A derived field expression using a new converter.
-
convert
@NotNull <U> @NotNull Field<U> convert(Class<U> toType, Function<? super T,? extends U> from, Function<? super U,? extends T> to)Apply an ad-hoc data typeConverterto this field expression.Rather than attaching data type converters at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataType(Class, Function, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.- Type Parameters:
U- The user type.- Parameters:
converter- The converter to be applied on any operations using this field.- Returns:
- A derived field expression using a new converter.
-
convertFrom
Apply an ad-hoc read-only data typeConverterto this field expression.Rather than attaching data type converters at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataTypeFrom(Class, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.- Type Parameters:
U- The user type.- Parameters:
converter- The read-only converter to be applied on any operations using this field.- Returns:
- A derived field expression using a new converter.
-
convertFrom
Apply an ad-hoc read-only data typeConverterto this field expression.Rather than attaching data type converters at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataTypeFrom(Class, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.EXPERIMENTAL. Unlike
convertFrom(Class, Function), this method attempts to work without an explicitClassreference for the underlyingConverter.toType(). There may be some edge cases where this doesn't work. Please report any bugs here: https://github.com/jOOQ/jOOQ/issues/new/choose- Type Parameters:
U- The user type.- Parameters:
converter- The read-only converter to be applied on any operations using this field.- Returns:
- A derived field expression using a new converter.
-
convertTo
Apply an ad-hoc write-only data typeConverterto this field expression.Rather than attaching data type converters at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataTypeTo(Class, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.- Type Parameters:
U- The user type.- Parameters:
converter- The write-only converter to be applied on any operations using this field.- Returns:
- A derived field expression using a new converter.
-
convertTo
Apply an ad-hoc write-only data typeConverterto this field expression.Rather than attaching data type converters at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataTypeTo(Class, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.EXPERIMENTAL. Unlike
convertTo(Class, Function), this method attempts to work without an explicitClassreference for the underlyingConverter.toType(). There may be some edge cases where this doesn't work. Please report any bugs here: https://github.com/jOOQ/jOOQ/issues/new/choose- Type Parameters:
U- The user type.- Parameters:
converter- The write-only converter to be applied on any operations using this field.- Returns:
- A derived field expression using a new converter.
-
cast
Cast this field to the type of another field.This results in the same as casting this field to
DataType.getCastTypeName()- Type Parameters:
Z- The generic type of the cast field- Parameters:
field- The field whose type is used for the cast- Returns:
- The cast field
- See Also:
cast(DataType)
-
cast
Cast this field to a dialect-specific data type.- Type Parameters:
Z- The generic type of the cast field- Parameters:
type- The data type that is used for the cast- Returns:
- The cast field
-
cast
Cast this field to another type.The actual cast may not be accurate as the
DataTypehas to be "guessed" from the jOOQ-configured data types. Usecast(DataType)for more accurate casts.- Type Parameters:
Z- The generic type of the cast field- Parameters:
type- The type that is used for the cast- Returns:
- The cast field
- See Also:
cast(DataType)
-
coerce
Coerce this field to the type of another field.Unlike with casting, coercing doesn't affect the way the database sees a
Field's type. This is how coercing affects your SQL:Bind values
// This binds an int value to a JDBC PreparedStatement DSL.val(1).coerce(String.class); // This binds an int value to a JDBC PreparedStatement // and casts it to VARCHAR in SQL DSL.val(1).cast(String.class);
Other Field types
// This fetches a String value for the BOOK.ID field from JDBC BOOK.ID.coerce(String.class); // This fetches a String value for the BOOK.ID field from JDBC // after casting it to VARCHAR in the database BOOK.ID.cast(String.class);
- Type Parameters:
Z- The generic type of the coerced field- Parameters:
field- The field whose type is used for the coercion- Returns:
- The coerced field
- See Also:
coerce(DataType),cast(Field)
-
coerce
Coerce this field to a dialect-specific data type.Unlike with casting, coercing doesn't affect the way the database sees a
Field's type. This is how coercing affects your SQL:Bind values
// This binds an int value to a JDBC PreparedStatement DSL.val(1).coerce(String.class); // This binds an int value to a JDBC PreparedStatement // and casts it to VARCHAR in SQL DSL.val(1).cast(String.class);
Other Field types
// This fetches a String value for the BOOK.ID field from JDBC BOOK.ID.coerce(String.class); // This fetches a String value for the BOOK.ID field from JDBC // after casting it to VARCHAR in the database BOOK.ID.cast(String.class);
- Type Parameters:
Z- The generic type of the coerced field- Parameters:
type- The data type that is used for the coercion- Returns:
- The coerced field
- See Also:
cast(DataType)
-
coerce
Coerce this field to another type.Unlike with casting, coercing doesn't affect the way the database sees a
Field's type. This is how coercing affects your SQL:Bind values
// This binds an int value to a JDBC PreparedStatement DSL.val(1).coerce(String.class); // This binds an int value to a JDBC PreparedStatement // and casts it to VARCHAR in SQL DSL.val(1).cast(String.class);
Other Field types
// This fetches a String value for the BOOK.ID field from JDBC BOOK.ID.coerce(String.class); // This fetches a String value for the BOOK.ID field from JDBC // after casting it to VARCHAR in the database BOOK.ID.cast(String.class);
- Type Parameters:
Z- The generic type of the coerced field- Parameters:
type- The type that is used for the coercion- Returns:
- The coerced field
- See Also:
coerce(DataType),cast(Class)
-
asc
Create an ascending sort field from this field.This is the same as calling
sort(SortOrder)withSortOrder.ASC- Returns:
- This field as an ascending sort field
-
desc
Create a descending sort field from this field.This is the same as calling
sort(SortOrder)withSortOrder.DESC- Returns:
- This field as a descending sort field
-
sortDefault
Create a default sorted (implicitASC) from this field.This is the same as calling
sort(SortOrder)withSortOrder.DEFAULT- Returns:
- This field as a default sorted sort field
-
sort
Create an ascending/descending sort field from this field.- Parameters:
order- The sort order- Returns:
- This field as an ascending/descending sort field.
-
sortAsc
Create an indirected sort field.Create a sort field of the form
CASE [this] WHEN [sortList.get(0)] THEN 0 WHEN [sortList.get(1)] THEN 1 ... WHEN [sortList.get(n)] THEN n ELSE null END ASCNote: You can use this in combination with
SortField.nullsFirst()orSortField.nullsLast()to specify whether the default should have highest or lowest priority.- Parameters:
sortList- The list containing sort value preferences- Returns:
- The sort field
-
sortAsc
Create an indirected sort field.Create a sort field of the form
CASE [this] WHEN [sortList[0]] THEN 0 WHEN [sortList[1]] THEN 1 ... WHEN [sortList[n]] THEN n ELSE null END ASCNote: You can use this in combination with
SortField.nullsFirst()orSortField.nullsLast()to specify whether the default should have highest or lowest priority.- Parameters:
sortList- The list containing sort value preferences- Returns:
- The sort field
-
sortDesc
Create an indirected sort field.Create a sort field of the form
CASE [this] WHEN [sortList.get(0)] THEN 0 WHEN [sortList.get(1)] THEN 1 ... WHEN [sortList.get(n)] THEN n ELSE null END DESCNote: You can use this in combination with
SortField.nullsFirst()orSortField.nullsLast()to specify whether the default should have highest or lowest priority.- Parameters:
sortList- The list containing sort value preferences- Returns:
- The sort field
-
sortDesc
Create an indirected sort field.Create a sort field of the form
CASE [this] WHEN [sortList[0]] THEN 0 WHEN [sortList[1]] THEN 1 ... WHEN [sortList[n]] THEN n ELSE null END DESCNote: You can use this in combination with
SortField.nullsFirst()orSortField.nullsLast()to specify whether the default should have highest or lowest priority.- Parameters:
sortList- The list containing sort value preferences- Returns:
- The sort field
-
sort
Create an indirected sort field.Create a sort field of the form (in pseudo code)
CASE [this] WHEN [sortMap.key(0)] THEN sortMap.value(0) WHEN [sortMap.key(1)] THEN sortMap.value(1) ... WHEN [sortMap.key(n)] THEN sortMap.value(n) ELSE null END DESCNote: You can use this in combination with
SortField.nullsFirst()orSortField.nullsLast()to specify whether the default should have highest or lowest priority.- Parameters:
sortMap- The list containing sort value preferences- Returns:
- The sort field
-
neg
Negate this field to get its negative value.This renders the same on all dialects:
-[this]
-
unaryMinus
Negate this field to get its negative value.This is an alias for
neg(), which can be recognised by the Kotlin language for operator overloading. -
unaryPlus
Get this field as its positive value (no effect on SQL).This can be recognised by the Kotlin language for operator overloading.
-
add
An arithmetic expression adding this to value.- See Also:
add(Field)
-
add
An arithmetic expression to add value to this.The behaviour of this operation is as follows:
Operand 1 Operand 2 Result Type Numeric Numeric Numeric Date / Time Numeric Date / Time Date / Time Interval Date / Time Interval Interval Interval -
plus
An alias foradd(Number).- See Also:
add(Number)
-
plus
An alias foradd(Field).- See Also:
add(Field)
-
sub
An arithmetic expression subtracting value from this.- See Also:
sub(Field)
-
sub
An arithmetic expression subtracting value from this.Operand 1 Operand 2 Result Type Numeric Numeric Numeric Date / Time Numeric Date / Time Date / Time Interval Date / Time Interval Interval Interval In order to subtract one date time field from another, use any of these methods:
-
subtract
An alias forsub(Number).- See Also:
sub(Number)
-
subtract
An alias forsub(Field).- See Also:
sub(Field)
-
minus
An alias forsub(Number).- See Also:
sub(Number)
-
minus
An alias forsub(Field).- See Also:
sub(Field)
-
mul
An arithmetic expression multiplying this with value.- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an
INTERVALfield, then the result is also anINTERVALfield (seeInterval)
-
mul
An arithmetic expression multiplying this with value.- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an
INTERVALfield, then the result is also anINTERVALfield (seeInterval)
-
multiply
An alias formul(Number).- See Also:
mul(Number)
-
multiply
An alias formul(Field).- See Also:
mul(Field)
-
times
An alias formul(Number).- See Also:
mul(Number)
-
times
An alias formul(Field).- See Also:
mul(Field)
-
div
An arithmetic expression dividing this by value.- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an
INTERVALfield, then the result is also anINTERVALfield (seeInterval)
-
div
An arithmetic expression dividing this by value.- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an
INTERVALfield, then the result is also anINTERVALfield (seeInterval)
-
divide
An alias fordiv(Number).- See Also:
div(Number)
-
divide
An alias fordiv(Field).- See Also:
div(Field)
-
mod
An arithmetic expression getting the modulo of this divided by value.This renders the modulo operation where available:
... or the modulo function elsewhere:[this] % [value]
mod([this], [value])
-
mod
An arithmetic expression getting the modulo of this divided by value.This renders the modulo operation where available:
... or the modulo function elsewhere:[this] % [value]
mod([this], [value])
-
modulo
An alias formod(Number).- See Also:
mod(Number)
-
modulo
An alias formod(Field).- See Also:
mod(Field)
-
rem
An alias formod(Number).- See Also:
mod(Number)
-
rem
An alias formod(Field).- See Also:
mod(Field)
-
pow
@NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> pow(Number exponent)An arithmetic expression getting this value raised to the power ofexponent.This renders the power operation where available:
... or the power function elsewhere:[this] ^ [value]
power([this], [value])
- See Also:
DSL.power(Field, Number)
-
pow
@NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> pow(Field<? extends Number> exponent)An arithmetic expression getting this value raised to the power ofexponent.This renders the power operation where available:
... or the power function elsewhere:[this] ^ [value]
power([this], [value])
- See Also:
DSL.power(Field, Field)
-
power
@NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> power(Number exponent)An alias forpower(Number).- See Also:
power(Number)
-
power
@NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> power(Field<? extends Number> exponent)An alias forpower(Field).- See Also:
power(Field)
-
bitNot
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> bitNot()The bitwise not operator.- See Also:
DSL.bitNot(Field)
-
bitAnd
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> bitAnd(T value)The bitwise and operator.- See Also:
DSL.bitAnd(Field, Field)
-
bitAnd
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> bitAnd(Field<T> value)The bitwise and operator.- See Also:
DSL.bitAnd(Field, Field)
-
bitNand
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> bitNand(T value)The bitwise not and operator.- See Also:
DSL.bitNand(Field, Field),DSL.bitNot(Field)
-
bitNand
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> bitNand(Field<T> value)The bitwise not and operator.- See Also:
DSL.bitNand(Field, Field),DSL.bitNot(Field)
-
bitOr
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> bitOr(T value)The bitwise or operator.- See Also:
DSL.bitOr(Field, Field)
-
bitOr
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> bitOr(Field<T> value)The bitwise or operator.- See Also:
DSL.bitOr(Field, Field)
-
bitNor
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> bitNor(T value)The bitwise not or operator.- See Also:
DSL.bitNor(Field, Field),DSL.bitNot(Field)
-
bitNor
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> bitNor(Field<T> value)The bitwise not or operator.- See Also:
DSL.bitNor(Field, Field),DSL.bitNot(Field)
-
bitXor
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> bitXor(T value)The bitwise xor operator.- See Also:
DSL.bitXor(Field, Field)
-
bitXor
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> bitXor(Field<T> value)The bitwise xor operator.- See Also:
DSL.bitXor(Field, Field)
-
bitXNor
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> bitXNor(T value)The bitwise not xor operator.- See Also:
DSL.bitXNor(Field, Field),DSL.bitNot(Field)
-
bitXNor
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> bitXNor(Field<T> value)The bitwise not xor operator.- See Also:
DSL.bitXNor(Field, Field),DSL.bitNot(Field)
-
shl
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> shl(Number value)The bitwise left shift operator.- See Also:
DSL.shl(Field, Field),DSL.power(Field, Number)
-
shl
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> shl(Field<? extends Number> value)The bitwise left shift operator.- See Also:
DSL.shl(Field, Field),DSL.power(Field, Number)
-
shr
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> shr(Number value)The bitwise right shift operator.- See Also:
DSL.shr(Field, Field),DSL.power(Field, Number)
-
shr
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<T> shr(Field<? extends Number> value)The bitwise right shift operator.- See Also:
DSL.shr(Field, Field),DSL.power(Field, Number)
-
isDocument
Create a condition to check if this field contains XML data. -
isNotDocument
Create a condition to check if this field does not contain XML data. -
isJson
Create a condition to check if this field contains JSON data. -
isNotJson
Create a condition to check if this field does not contain JSON data. -
isNull
Create a condition to check this field againstnull.SQL:
this is null -
isNotNull
Create a condition to check this field againstnull.SQL:
this is not null -
isDistinctFrom
Create a condition to check if this field isDISTINCTfrom another value.In
SQLDialect.MYSQLandSQLDialect.MARIADB, this can be emulated throughnot([this] <=> [value])
In
SQLDialect.SQLITE, this can be emulated through[this] IS NOT [value]
In databases that support
INTERSECT(seeSelect.intersect(Select), this predicate can be emulated as follows:NOT EXISTS (SELECT [this] INTERSECT SELECT [value])
If this is not supported by the underlying database, jOOQ will render this instead:
SQL:CASE WHEN [this] IS NULL AND [value] IS NULL THEN FALSE WHEN [this] IS NULL AND [value] IS NOT NULL THEN TRUE WHEN [this] IS NOT NULL AND [value] IS NULL THEN TRUE WHEN [this] = [value] THEN FALSE ELSE TRUE ENDthis is distinct from value -
isDistinctFrom
Create a condition to check if this field isDISTINCTfrom another field.In
SQLDialect.MYSQLandSQLDialect.MARIADB, this can be emulated throughnot([this] <=> [value])
In
SQLDialect.SQLITE, this can be emulated through[this] IS NOT [value]
In databases that support
INTERSECT(seeSelect.intersect(Select), this predicate can be emulated as follows:NOT EXISTS (SELECT [this] INTERSECT SELECT [value])
If this is not supported by the underlying database, jOOQ will render this instead:
SQL:CASE WHEN [this] IS NULL AND [field] IS NULL THEN FALSE WHEN [this] IS NULL AND [field] IS NOT NULL THEN TRUE WHEN [this] IS NOT NULL AND [field] IS NULL THEN TRUE WHEN [this] = [field] THEN FALSE ELSE TRUE ENDthis is distinct from field -
isDistinctFrom
Create a condition to check if this field isDISTINCTfrom another field.In
SQLDialect.MYSQLandSQLDialect.MARIADB, this can be emulated throughnot([this] <=> [value])
In
SQLDialect.SQLITE, this can be emulated through[this] IS NOT [value]
In databases that support
INTERSECT(seeSelect.intersect(Select), this predicate can be emulated as follows:NOT EXISTS (SELECT [this] INTERSECT SELECT [value])
If this is not supported by the underlying database, jOOQ will render this instead:
SQL:CASE WHEN [this] IS NULL AND [field] IS NULL THEN FALSE WHEN [this] IS NULL AND [field] IS NOT NULL THEN TRUE WHEN [this] IS NOT NULL AND [field] IS NULL THEN TRUE WHEN [this] = [field] THEN FALSE ELSE TRUE ENDthis is distinct from field -
isNotDistinctFrom
Create a condition to check if this field isNOT DISTINCTfrom another value.In
SQLDialect.MYSQLandSQLDialect.MARIADB, this can be emulated through[this] <=> [value]
In
SQLDialect.SQLITE, this can be emulated through[this] IS [value]
In databases that support
INTERSECT(seeSelect.intersect(Select), this predicate can be emulated as follows:EXISTS (SELECT [this] INTERSECT SELECT [value])
If this is not supported by the underlying database, jOOQ will render this instead:
SQL:CASE WHEN [this] IS NULL AND [value] IS NULL THEN TRUE WHEN [this] IS NULL AND [value] IS NOT NULL THEN FALSE WHEN [this] IS NOT NULL AND [value] IS NULL THEN FALSE WHEN [this] = [value] THEN TRUE ELSE FALSE ENDthis is not distinct from value -
isNotDistinctFrom
Create a condition to check if this field isNOT DISTINCTfrom another field.In
SQLDialect.MYSQLandSQLDialect.MARIADB, this can be emulated through[this] <=> [value]
In
SQLDialect.SQLITE, this can be emulated through[this] IS [value]
In databases that support
INTERSECT(seeSelect.intersect(Select), this predicate can be emulated as follows:EXISTS (SELECT [this] INTERSECT SELECT [value])
If this is not supported by the underlying database, jOOQ will render this instead:
SQL:CASE WHEN [this] IS NULL AND [field] IS NULL THEN TRUE WHEN [this] IS NULL AND [field] IS NOT NULL THEN FALSE WHEN [this] IS NOT NULL AND [field] IS NULL THEN FALSE WHEN [this] = [value] THEN TRUE ELSE FALSE ENDthis is not distinct from field -
isNotDistinctFrom
Create a condition to check if this field isNOT DISTINCTfrom another field.In
SQLDialect.MYSQLandSQLDialect.MARIADB, this can be emulated through[this] <=> [value]
In
SQLDialect.SQLITE, this can be emulated through[this] IS [value]
In databases that support
INTERSECT(seeSelect.intersect(Select), this predicate can be emulated as follows:EXISTS (SELECT [this] INTERSECT SELECT [value])
If this is not supported by the underlying database, jOOQ will render this instead:
SQL:CASE WHEN [this] IS NULL AND [field] IS NULL THEN TRUE WHEN [this] IS NULL AND [field] IS NOT NULL THEN FALSE WHEN [this] IS NOT NULL AND [field] IS NULL THEN FALSE WHEN [this] = [value] THEN TRUE ELSE FALSE ENDthis is not distinct from field -
likeRegex
@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLITE,SYBASE,VERTICA}) @NotNull Condition likeRegex(String pattern)Create a condition to regex-pattern-check this field against a pattern.The SQL:2008 standard specifies a
<regex like predicate>of the following form:<regex like predicate> ::= <row value predicand> <regex like predicate part 2> <regex like predicate part 2> ::= [ NOT ] LIKE_REGEX <XQuery pattern> [ FLAG <XQuery option flag> ]
This particular
LIKE_REGEXoperator comes in several flavours for various databases. jOOQ supports regular expressions as follows:- See Also:
likeRegex(String)
-
likeRegex
@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLITE,SYBASE,VERTICA}) @NotNull Condition likeRegex(Field<String> pattern)Create a condition to regex-pattern-check this field against a pattern.See
likeRegex(String)for more details- See Also:
likeRegex(String)
-
notLikeRegex
@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLITE,SYBASE,VERTICA}) @NotNull Condition notLikeRegex(String pattern)Create a condition to regex-pattern-check this field against a pattern.See
likeRegex(String)for more details- See Also:
likeRegex(String)
-
notLikeRegex
@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLITE,SYBASE,VERTICA}) @NotNull Condition notLikeRegex(Field<String> pattern)Create a condition to regex-pattern-check this field against a pattern.See
likeRegex(String)for more details- See Also:
likeRegex(Field)
-
similarTo
@NotNull @Support({COCKROACHDB,FIREBIRD,POSTGRES}) @NotNull LikeEscapeStep similarTo(Field<String> value)Create a condition to pattern-check this field against a value.SQL:
this similar to value -
similarTo
@NotNull @Support({COCKROACHDB,FIREBIRD,POSTGRES}) @NotNull Condition similarTo(Field<String> value, char escape)Create a condition to pattern-check this field against a value.SQL:
this similar to value escape 'e'- See Also:
LikeEscapeStep.escape(char)
-
similarTo
Create a condition to pattern-check this field against a value.SQL:
this similar to value -
similarTo
@NotNull @Support({COCKROACHDB,FIREBIRD,POSTGRES}) @NotNull Condition similarTo(String value, char escape)Create a condition to pattern-check this field against a value.SQL:
this similar to value escape 'e'- See Also:
LikeEscapeStep.escape(char)
-
notSimilarTo
@NotNull @Support({COCKROACHDB,FIREBIRD,POSTGRES}) @NotNull LikeEscapeStep notSimilarTo(Field<String> field)Create a condition to pattern-check this field against a field.SQL:
this not similar to field -
notSimilarTo
@NotNull @Support({COCKROACHDB,FIREBIRD,POSTGRES}) @NotNull Condition notSimilarTo(Field<String> field, char escape)Create a condition to pattern-check this field against a field.SQL:
this not similar to field escape 'e'- See Also:
LikeEscapeStep.escape(char)
-
notSimilarTo
@NotNull @Support({COCKROACHDB,FIREBIRD,POSTGRES}) @NotNull LikeEscapeStep notSimilarTo(String value)Create a condition to pattern-check this field against a value.SQL:
this not similar to value -
notSimilarTo
@NotNull @Support({COCKROACHDB,FIREBIRD,POSTGRES}) @NotNull Condition notSimilarTo(String value, char escape)Create a condition to pattern-check this field against a value.SQL:
this not similar to value escape 'e'- See Also:
LikeEscapeStep.escape(char)
-
like
Create a condition to pattern-check this field against a value.SQL:
this like value -
like
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition like(Field<String> value, char escape)Create a condition to pattern-check this field against a value.SQL:
this like value escape 'e'- See Also:
LikeEscapeStep.escape(char)
-
like
Create a condition to pattern-check this field against a value.SQL:
this like value -
like
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition like(String value, char escape)Create a condition to pattern-check this field against a value.SQL:
this like value escape 'e'- See Also:
LikeEscapeStep.escape(char)
-
like
Create a condition to pattern-check this field against a quantified select.For example a query like
field.like(any("a%", "b%"))translates into the SQL(field like 'a%' or field like 'b%'). -
likeIgnoreCase
Create a condition to case-insensitively pattern-check this field against a field.This translates to
this ilike fieldinSQLDialect.POSTGRES, or tolower(this) like lower(field)in all other dialects. -
likeIgnoreCase
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition likeIgnoreCase(Field<String> field, char escape)Create a condition to case-insensitively pattern-check this field against a field.This translates to
this ilike fieldinSQLDialect.POSTGRES, or tolower(this) like lower(field)in all other dialects.- See Also:
LikeEscapeStep.escape(char)
-
likeIgnoreCase
Create a condition to case-insensitively pattern-check this field against a value.This translates to
this ilike valueinSQLDialect.POSTGRES, or tolower(this) like lower(value)in all other dialects. -
likeIgnoreCase
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition likeIgnoreCase(String value, char escape)Create a condition to case-insensitively pattern-check this field against a value.This translates to
this ilike valueinSQLDialect.POSTGRES, or tolower(this) like lower(value)in all other dialects.- See Also:
LikeEscapeStep.escape(char)
-
notLike
Create a condition to pattern-check this field against a field.SQL:
this not like field -
notLike
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition notLike(Field<String> field, char escape)Create a condition to pattern-check this field against a field.SQL:
this not like field escape 'e'- See Also:
LikeEscapeStep.escape(char)
-
notLike
Create a condition to pattern-check this field against a value.SQL:
this not like value -
notLike
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition notLike(String value, char escape)Create a condition to pattern-check this field against a value.SQL:
this not like value escape 'e'- See Also:
LikeEscapeStep.escape(char)
-
notLike
Create a condition to pattern-check this field against a quantified select.For example a query like
field.notLike(any("a%", "b%"))translates into the SQL(field not like 'a%' or field not like 'b%'). -
notLikeIgnoreCase
Create a condition to case-insensitively pattern-check this field against a field.This translates to
this not ilike fieldinSQLDialect.POSTGRES, or tolower(this) not like lower(field)in all other dialects. -
notLikeIgnoreCase
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition notLikeIgnoreCase(Field<String> field, char escape)Create a condition to case-insensitively pattern-check this field against a field.This translates to
this not ilike fieldinSQLDialect.POSTGRES, or tolower(this) not like lower(field)in all other dialects.- See Also:
LikeEscapeStep.escape(char)
-
notLikeIgnoreCase
Create a condition to case-insensitively pattern-check this field against a value.This translates to
this not ilike valueinSQLDialect.POSTGRES, or tolower(this) not like lower(value)in all other dialects. -
notLikeIgnoreCase
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition notLikeIgnoreCase(String value, char escape)Create a condition to case-insensitively pattern-check this field against a value.This translates to
this not ilike valueinSQLDialect.POSTGRES, or tolower(this) not like lower(value)in all other dialects.- See Also:
LikeEscapeStep.escape(char)
-
contains
Convenience method forlike(String, char)including proper adding of wildcards and escaping.SQL:
this like ('%' || escape(value, '\') || '%') escape '\'Note: This also works with numbers, for instance
val(1133).contains(13)If you're using
SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator. For example:// Use this expression val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 }) // ... to render this SQL ARRAY[1, 2, 3] @> ARRAY[1, 2]Note, this does not correspond to the Oracle Text
CONTAINS()function. Refer toOracleDSL.contains(Field, String)instead.- See Also:
DSL.escape(String, char),like(String, char)
-
contains
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition contains(Field<T> value)Convenience method forlike(String, char)including proper adding of wildcards and escaping.SQL:
this like ('%' || escape(value, '\') || '%') escape '\'Note: This also works with numbers, for instance
val(1133).contains(13)If you're using
SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator. For example:// Use this expression val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 }) // ... to render this SQL ARRAY[1, 2, 3] @> ARRAY[1, 2]Note, this does not correspond to the Oracle Text
CONTAINS()function. Refer toOracleDSL.contains(Field, String)instead.- See Also:
DSL.escape(Field, char),like(Field, char)
-
notContains
Inverse ofcontains(Object). -
notContains
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition notContains(Field<T> value)Inverse ofcontains(Field). -
containsIgnoreCase
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition containsIgnoreCase(T value)Convenience method forlikeIgnoreCase(String, char)including proper adding of wildcards and escaping.This translates to
this ilike ('%' || escape(value, '\') || '%') escape '\'inSQLDialect.POSTGRES, or tolower(this) not like lower(('%' || escape(value, '\') || '%') escape '\')in all other dialects. -
containsIgnoreCase
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition containsIgnoreCase(Field<T> value)Convenience method forlikeIgnoreCase(String, char)including proper adding of wildcards and escaping.This translates to
this ilike ('%' || escape(value, '\') || '%') escape '\'inSQLDialect.POSTGRES, or tolower(this) like lower(('%' || escape(value, '\') || '%') escape '\')in all other dialects. -
notContainsIgnoreCase
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition notContainsIgnoreCase(T value)Inverse ofcontainsIgnoreCase(Object) -
notContainsIgnoreCase
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition notContainsIgnoreCase(Field<T> value)Inverse ofcontainsIgnoreCase(Field) -
startsWith
Convenience method forlike(String, char)including proper adding of wildcards and escaping.SQL:
this like (escape(value, '\') || '%') escape '\'Note: This also works with numbers, for instance
val(1133).startsWith(11)- See Also:
DSL.escape(String, char),like(String, char)
-
startsWith
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition startsWith(Field<T> value)Convenience method forlike(String, char)including proper adding of wildcards and escaping.SQL:
this like (escape(value, '\') || '%') escape '\'Note: This also works with numbers, for instance
val(1133).startsWith(11)- See Also:
DSL.escape(Field, char),like(Field, char)
-
startsWithIgnoreCase
Convenience method forlike(String, char)including proper adding of wildcards and escaping.SQL:
lower(this) like (lower(escape(value, '\')) || '%') escape '\'Note: This also works with numbers, for instance
val(1133).startsWithIgnoreCase(11)- See Also:
DSL.escape(String, char),like(String, char)
-
startsWithIgnoreCase
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition startsWithIgnoreCase(Field<T> value)Convenience method forlike(String, char)including proper adding of wildcards and escaping.SQL:
lower(this) like (lower(escape(value, '\')) || '%') escape '\'Note: This also works with numbers, for instance
val(1133).startsWithIgnoreCase(11)- See Also:
DSL.escape(Field, char),like(Field, char)
-
endsWith
Convenience method forlike(String, char)including proper adding of wildcards and escaping.SQL:
this like ('%' || escape(value, '\')) escape '\'Note: This also works with numbers, for instance
val(1133).endsWith(33)- See Also:
DSL.escape(String, char),like(String, char)
-
endsWith
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition endsWith(Field<T> value)Convenience method forlike(String, char)including proper adding of wildcards and escaping.SQL:
this like ('%' || escape(value, '\')) escape '\'Note: This also works with numbers, for instance
val(1133).endsWith(33)- See Also:
DSL.escape(Field, char),like(Field, char)
-
endsWithIgnoreCase
Convenience method forlike(String, char)including proper adding of wildcards and escaping.SQL:
lower(this) like ('%' || lower(escape(value, '\'))) escape '\'Note: This also works with numbers, for instance
val(1133).endsWithIgnoreCase(33)- See Also:
DSL.escape(String, char),like(String, char)
-
endsWithIgnoreCase
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA}) @NotNull Condition endsWithIgnoreCase(Field<T> value)Convenience method forlike(String, char)including proper adding of wildcards and escaping.SQL:
this like ('%' || lower(escape(value, '\'))) escape '\'Note: This also works with numbers, for instance
val(1133).endsWithIgnoreCase(33)- See Also:
DSL.escape(Field, char),like(Field, char)
-
in
Create a condition to check this field against several values.SQL:
this in (values...)Note that generating dynamic SQL with arbitrary-length
INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:INpredicates on temporary tablesINpredicates on unnested array bind variables
-
in
Create a condition to check this field against several values from a previous query.SQL:
this in (values...)Note that generating dynamic SQL with arbitrary-length
INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:INpredicates on temporary tablesINpredicates on unnested array bind variables
-
in
Create a condition to check this field against several values.SQL:
this in (values...)Note that generating dynamic SQL with arbitrary-length
INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:INpredicates on temporary tablesINpredicates on unnested array bind variables
-
in
Create a condition to check this field against several values.SQL:
this in (values...) -
in
Create a condition to check this field against a subquery.Note that the subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.
SQL:
this in (select...) -
notIn
Create a condition to check this field against several values.Note that if any of the passed values is
NULL, then the condition will beNULL(orfalse, depending on the dialect) as well. This is standard SQL behaviour.SQL:
this not in (values...)Note that generating dynamic SQL with arbitrary-length
NOT INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:NOT INpredicates on temporary tablesNOT INpredicates on unnested array bind variables
-
notIn
Create a condition to check this field against several values from a previous query.Note that if any of the passed values is
NULL, then the condition will beNULL(orfalse, depending on the dialect) as well. This is standard SQL behaviour.SQL:
this in (values...)Note that generating dynamic SQL with arbitrary-length
NOT INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:NOT INpredicates on temporary tablesNOT INpredicates on unnested array bind variables
-
notIn
Create a condition to check this field against several values.Note that if any of the passed values is
NULL, then the condition will beNULL(orfalse, depending on the dialect) as well. This is standard SQL behaviour.SQL:
this not in (values...)Note that generating dynamic SQL with arbitrary-length
NOT INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:NOT INpredicates on temporary tablesNOT INpredicates on unnested array bind variables
-
notIn
Create a condition to check this field against several values.Note that if any of the passed values is
NULL, then the condition will beNULL(orfalse, depending on the dialect) as well. This is standard SQL behaviour.SQL:
this not in (values...) -
notIn
Create a condition to check this field against a subquery.Note that the subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.
Note that if any of the passed values is
NULL, then the condition will beNULL(orfalse, depending on the dialect) as well. This is standard SQL behaviour.SQL:
this not in (select...) -
between
Create a condition to check this field against some bounds.This is the same as calling
between(minValue).and(maxValue)SQL:
this between minValue and maxValue -
between
Create a condition to check this field against some bounds.This is the same as calling
between(minValue).and(maxValue)SQL:
this between minValue and maxValue -
betweenSymmetric
Create a condition to check this field against some bounds.This is the same as calling
betweenSymmetric(minValue).and(maxValue)SQL:
this between symmetric minValue and maxValue -
betweenSymmetric
Create a condition to check this field against some bounds.This is the same as calling
betweenSymmetric(minValue).and(maxValue)SQL:
this between symmetric minValue and maxValue -
notBetween
Create a condition to check this field against some bounds.This is the same as calling
notBetween(minValue).and(maxValue)SQL:
this not between minValue and maxValue -
notBetween
Create a condition to check this field against some bounds.This is the same as calling
notBetween(minValue).and(maxValue)SQL:
this not between minValue and maxValue -
notBetweenSymmetric
Create a condition to check this field against some bounds.This is the same as calling
notBetweenSymmetric(minValue).and(maxValue)SQL:
this not between symmetric minValue and maxValue -
notBetweenSymmetric
Create a condition to check this field against some bounds.This is the same as calling
notBetweenSymmetric(minValue).and(maxValue)SQL:
this not between symmetric minValue and maxValue -
between
Create a condition to check this field against some bounds.SQL:
this between minValue and maxValue -
between
Create a condition to check this field against some bounds.SQL:
this between minValue and maxValue -
betweenSymmetric
Create a condition to check this field against some bounds.SQL:
this between symmetric minValue and maxValue -
betweenSymmetric
Create a condition to check this field against some bounds.SQL:
this between symmetric minValue and maxValue -
notBetween
Create a condition to check this field against some bounds.SQL:
this not between minValue and maxValue -
notBetween
Create a condition to check this field against some bounds.SQL:
this not between minValue and maxValue -
notBetweenSymmetric
Create a condition to check this field against some bounds.SQL:
this not between symmetric minValue and maxValue -
notBetweenSymmetric
Create a condition to check this field against some bounds.SQL:
this not between symmetric minValue and maxValue -
compare
Compare this field with a value using a dynamic comparator.- Parameters:
comparator- The comparator to use for comparing this field with a valuevalue- The value to compare this field with- Returns:
- A comparison predicate
-
compare
Compare this field with another field using a dynamic comparator.- Parameters:
comparator- The comparator to use for comparing this field with another fieldfield- The field to compare this field with- Returns:
- A comparison predicate
-
compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, Select<? extends Record1<T>> query)Compare this field with a subselect using a dynamic comparator.Consider
Comparator.supportsSubselect()to assess whether a comparator can be used with this method.- Parameters:
comparator- The comparator to use for comparing this field with a subselectquery- The subselect to compare this field with- Returns:
- A comparison predicate
-
compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query)Compare this field with a quantified subselect using a dynamic comparator.Consider
Comparator.supportsQuantifier()to assess whether a comparator can be used with this method.- Parameters:
comparator- The comparator to use for comparing this field with a quantified subselectquery- The quantified subselect to compare this field with- Returns:
- A comparison predicate
-
equal
this = value. -
equal
this = field. -
equal
this = (Select<?> ...). -
equal
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Condition equal(QuantifiedSelect<? extends Record1<T>> query)this = [quantifier] (Select<?> ...). -
eq
this = value.- See Also:
equal(Object)
-
eq
this = field.- See Also:
equal(Field)
-
eq
this = (Select<?> ...).- See Also:
equal(Select)
-
eq
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Condition eq(QuantifiedSelect<? extends Record1<T>> query)this = [quantifier] (Select<?> ...). -
notEqual
this != value. -
notEqual
this != field. -
notEqual
this != (Select<?> ...). -
notEqual
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Condition notEqual(QuantifiedSelect<? extends Record1<T>> query)this != [quantifier] (Select<?> ...). -
ne
this != value.- See Also:
notEqual(Object)
-
ne
this != field.- See Also:
notEqual(Field)
-
ne
this != (Select<?> ...).- See Also:
notEqual(Select)
-
ne
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Condition ne(QuantifiedSelect<? extends Record1<T>> query)this != [quantifier] (Select<?> ...). -
lessThan
this < value. -
lessThan
this < field. -
lessThan
this < (Select<?> ...). -
lessThan
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Condition lessThan(QuantifiedSelect<? extends Record1<T>> query)this < [quantifier] (Select<?> ...). -
lt
this < value.- See Also:
lessThan(Object)
-
lt
this < field.- See Also:
lessThan(Field)
-
lt
this < (Select<?> ...).- See Also:
lessThan(Select)
-
lt
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Condition lt(QuantifiedSelect<? extends Record1<T>> query)this < [quantifier] (Select<?> ...). -
lessOrEqual
this <= value. -
lessOrEqual
this <= field. -
lessOrEqual
this <= (Select<?> ...). -
lessOrEqual
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Condition lessOrEqual(QuantifiedSelect<? extends Record1<T>> query)this <= [quantifier] (Select<?> ...). -
le
this <= value.- See Also:
lessOrEqual(Object)
-
le
this <= field.- See Also:
lessOrEqual(Field)
-
le
this <= (Select<?> ...).- See Also:
lessOrEqual(Select)
-
le
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Condition le(QuantifiedSelect<? extends Record1<T>> query)this <= [quantifier] (Select<?> ...). -
greaterThan
this > value. -
greaterThan
this > field. -
greaterThan
this > (Select<?> ...). -
greaterThan
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Condition greaterThan(QuantifiedSelect<? extends Record1<T>> query)this > [quantifier] (Select<?> ...). -
gt
this > value.- See Also:
greaterThan(Object)
-
gt
this > field.- See Also:
greaterThan(Field)
-
gt
this > (Select<?> ...).- See Also:
greaterThan(Select)
-
gt
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Condition gt(QuantifiedSelect<? extends Record1<T>> query)this > [quantifier] (Select<?> ...). -
greaterOrEqual
this >= value. -
greaterOrEqual
this >= field. -
greaterOrEqual
this >= (Select<?> ...). -
greaterOrEqual
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Condition greaterOrEqual(QuantifiedSelect<? extends Record1<T>> query)this >= [quantifier] (Select<?> ...). -
ge
this >= value.- See Also:
greaterOrEqual(Object)
-
ge
this >= field.- See Also:
greaterOrEqual(Field)
-
ge
this >= (Select<?> ...).- See Also:
greaterOrEqual(Select)
-
ge
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Condition ge(QuantifiedSelect<? extends Record1<T>> query)this >= [quantifier] (Select<?> ...). -
isTrue
Create a condition to check this field against known string literals fortrue.SQL:
lcase(this) in ("1", "y", "yes", "true", "on", "enabled") -
isFalse
Create a condition to check this field against known string literals forfalse.SQL:
lcase(this) in ("0", "n", "no", "false", "off", "disabled") -
equalIgnoreCase
lower(this) = lower(value). -
equalIgnoreCase
lower(this) = lower(value). -
notEqualIgnoreCase
lower(this) != lower(value). -
notEqualIgnoreCase
lower(this) != lower(value). -
sign
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.sign(Field)instead.- See Also:
DSL.sign(Field)
-
abs
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.abs(Field)instead.- See Also:
DSL.abs(Field)
-
round
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.round(Field)instead.- See Also:
DSL.round(Field)
-
round
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.round(Field, int)instead.- See Also:
DSL.round(Field, int)
-
floor
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.floor(Field)instead.- See Also:
DSL.floor(Field)
-
ceil
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.ceil(Field)instead.- See Also:
DSL.ceil(Field)
-
sqrt
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> sqrt()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.sqrt(Field)instead.- See Also:
DSL.sqrt(Field)
-
exp
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> exp()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.exp(Field)instead.- See Also:
DSL.exp(Field)
-
ln
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> ln()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.ln(Field)instead.- See Also:
DSL.ln(Field)
-
log
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> log(int base)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.log(Field, int)instead.- See Also:
DSL.log(Field, int)
-
acos
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> acos()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.acos(Field)instead.- See Also:
DSL.acos(Field)
-
asin
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> asin()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.asin(Field)instead.- See Also:
DSL.asin(Field)
-
atan
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> atan()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.atan(Field)instead.- See Also:
DSL.atan(Field)
-
atan2
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> atan2(Number y)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.atan2(Field, Number)instead.- See Also:
DSL.atan2(Field, Number)
-
atan2
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> atan2(Field<? extends Number> y)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.atan2(Field, Field)instead.- See Also:
DSL.atan2(Field, Field)
-
cos
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> cos()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.cos(Field)instead.- See Also:
DSL.cos(Field)
-
sin
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> sin()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.sin(Field)instead.- See Also:
DSL.sin(Field)
-
tan
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> tan()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.tan(Field)instead.- See Also:
DSL.tan(Field)
-
cot
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> cot()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.cot(Field)instead.- See Also:
DSL.cot(Field)
-
sinh
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> sinh()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.sinh(Field)instead.- See Also:
DSL.sinh(Field)
-
cosh
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> cosh()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.cosh(Field)instead.- See Also:
DSL.cosh(Field)
-
tanh
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> tanh()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.tanh(Field)instead.- See Also:
DSL.tanh(Field)
-
coth
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> coth()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.coth(Field)instead.- See Also:
DSL.coth(Field)
-
deg
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.deg(Field)instead.- See Also:
DSL.deg(Field)
-
rad
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.rad(Field)instead.- See Also:
DSL.rad(Field)
-
count
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.count(Field)instead.- See Also:
DSL.count(Field)
-
countDistinct
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<Integer> countDistinct()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.countDistinct(Field)instead.- See Also:
DSL.countDistinct(Field)
-
max
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.max(Field)instead.- See Also:
DSL.max(Field)
-
min
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.min(Field)instead.- See Also:
DSL.min(Field)
-
sum
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.sum(Field)instead.- See Also:
DSL.sum(Field)
-
avg
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.avg(Field)instead.- See Also:
DSL.avg(Field)
-
median
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({CUBRID,HSQLDB,ORACLE,SNOWFLAKE,SYBASE,TERADATA}) @NotNull Field<BigDecimal> median()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.median(Field)instead.- See Also:
DSL.median(Field)
-
stddevPop
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> stddevPop()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.stddevPop(Field)instead.- See Also:
DSL.stddevPop(Field)
-
stddevSamp
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> stddevSamp()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.stddevSamp(Field)instead.- See Also:
DSL.stddevSamp(Field)
-
varPop
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> varPop()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.varPop(Field)instead.- See Also:
DSL.varPop(Field)
-
varSamp
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<BigDecimal> varSamp()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.varSamp(Field)instead.- See Also:
DSL.varSamp(Field)
-
countOver
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WindowPartitionByStep<Integer> countOver()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.count(Field)instead.- See Also:
DSL.count(Field),WindowOverStep.over()
-
maxOver
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WindowPartitionByStep<T> maxOver()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.max(Field)instead.- See Also:
DSL.max(Field),WindowOverStep.over()
-
minOver
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WindowPartitionByStep<T> minOver()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.min(Field)instead.- See Also:
DSL.min(Field),WindowOverStep.over()
-
sumOver
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WindowPartitionByStep<BigDecimal> sumOver()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.sum(Field)instead.- See Also:
DSL.sum(Field),WindowOverStep.over()
-
avgOver
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WindowPartitionByStep<BigDecimal> avgOver()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.avg(Field)instead.- See Also:
DSL.avg(Field),WindowOverStep.over()
-
firstValue
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA}) @NotNull WindowIgnoreNullsStep<T> firstValue()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.firstValue(Field)instead.- See Also:
DSL.firstValue(Field),WindowOverStep.over()
-
lastValue
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA}) @NotNull WindowIgnoreNullsStep<T> lastValue()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lastValue(Field)instead.- See Also:
DSL.lastValue(Field),WindowOverStep.over()
-
lead
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA}) @NotNull WindowIgnoreNullsStep<T> lead()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lead(Field)instead.- See Also:
DSL.lead(Field),WindowOverStep.over()
-
lead
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA}) @NotNull WindowIgnoreNullsStep<T> lead(int offset)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lead(Field, int)instead.- See Also:
DSL.lead(Field, int),WindowOverStep.over()
-
lead
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA}) @NotNull WindowIgnoreNullsStep<T> lead(int offset, T defaultValue)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lead(Field, int, Object)instead. -
lead
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA}) @NotNull WindowIgnoreNullsStep<T> lead(int offset, Field<T> defaultValue)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lead(Field, int, Field)instead.- See Also:
DSL.lead(Field, int, Field),WindowOverStep.over()
-
lag
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA}) @NotNull WindowIgnoreNullsStep<T> lag()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lag(Field)instead.- See Also:
DSL.lag(Field),WindowOverStep.over()
-
lag
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA}) @NotNull WindowIgnoreNullsStep<T> lag(int offset)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lag(Field, int)instead.- See Also:
DSL.lag(Field, int),WindowOverStep.over()
-
lag
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA}) @NotNull WindowIgnoreNullsStep<T> lag(int offset, T defaultValue)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lag(Field, int, Object)instead.- See Also:
DSL.lag(Field, int, Object),WindowOverStep.over()
-
lag
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA}) @NotNull WindowIgnoreNullsStep<T> lag(int offset, Field<T> defaultValue)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.lag(Field, int, Field)instead.- See Also:
DSL.lag(Field, int, Field),WindowOverStep.over()
-
stddevPopOver
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,CUBRID,DB2,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WindowPartitionByStep<BigDecimal> stddevPopOver()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.stddevPop(Field)instead.- See Also:
DSL.stddevPop(Field),WindowOverStep.over()
-
stddevSampOver
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WindowPartitionByStep<BigDecimal> stddevSampOver()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.stddevSamp(Field)instead.- See Also:
DSL.stddevSamp(Field),WindowOverStep.over()
-
varPopOver
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,CUBRID,DB2,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WindowPartitionByStep<BigDecimal> varPopOver()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.varPop(Field)instead.- See Also:
DSL.varPop(Field),WindowOverStep.over()
-
varSampOver
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WindowPartitionByStep<BigDecimal> varSampOver()Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.varSamp(Field)instead.- See Also:
DSL.varSamp(Field),WindowOverStep.over()
-
upper
Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.upper(Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.upper(Field)
-
lower
Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.lower(Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.lower(Field)
-
trim
Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.trim(Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.trim(Field)
-
rtrim
Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.rtrim(Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.rtrim(Field)
-
ltrim
Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.ltrim(Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.ltrim(Field)
-
rpad
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> rpad(Field<? extends Number> length)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.rpad(Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.rpad(Field, Field)
-
rpad
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> rpad(int length)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.rpad(Field, int)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.rpad(Field, int)
-
rpad
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> rpad(Field<? extends Number> length, Field<String> character)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.rpad(Field, Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.rpad(Field, Field, Field)
-
rpad
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> rpad(int length, char character)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.rpad(Field, int, char)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.rpad(Field, int, char)
-
lpad
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> lpad(Field<? extends Number> length)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.lpad(Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.lpad(Field, Field)
-
lpad
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> lpad(int length)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.lpad(Field, int)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.lpad(Field, int)
-
lpad
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> lpad(Field<? extends Number> length, Field<String> character)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.lpad(Field, Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.lpad(Field, Field, Field)
-
lpad
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> lpad(int length, char character)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.lpad(Field, int, char)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.lpad(Field, int, char)
-
repeat
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> repeat(Number count)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.repeat(Field, int)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.repeat(Field, int)
-
repeat
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> repeat(Field<? extends Number> count)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.repeat(Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.repeat(Field, Field)
-
replace
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> replace(Field<String> search)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.replace(Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.replace(Field, Field)
-
replace
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> replace(String search)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.replace(Field, String)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.replace(Field, String)
-
replace
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> replace(Field<String> search, Field<String> replace)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.replace(Field, Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.replace(Field, Field, Field)
-
replace
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<String> replace(String search, String replace)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.replace(Field, String, String)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.replace(Field, String, String)
-
position
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<Integer> position(String search)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.position(Field, String)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.position(Field, String)
-
position
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<Integer> position(Field<String> search)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.position(Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.position(Field, Field)
-
ascii
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull Field<Integer> ascii()Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.ascii(Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.ascii(Field)
-
collate
@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,HSQLDB,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER}) @NotNull Field<String> collate(String collation)Apply a collation operator to this column expression.- See Also:
DSL.collation(String)
-
collate
@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,HSQLDB,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER}) @NotNull Field<String> collate(Name collation)Apply a collation operator to this column expression.- See Also:
DSL.collation(Name)
-
collate
@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,HSQLDB,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER}) @NotNull Field<String> collate(Collation collation)Apply a collation operator to this column expression. -
concat
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.concat(Field...)
-
concat
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.concat(String...)
-
concat
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.concat(String...)
-
substring
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<String> substring(int startingPosition)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.substring(Field, int)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.substring(Field, int)
-
substring
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<String> substring(Field<? extends Number> startingPosition)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.substring(Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.substring(Field, Field)
-
substring
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<String> substring(int startingPosition, int length)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.substring(Field, int, int)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.substring(Field, int, int)
-
substring
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<String> substring(Field<? extends Number> startingPosition, Field<? extends Number> length)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.substring(Field, Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.substring(Field, Field, Field)
-
length
Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.length(Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.length(Field)
-
charLength
Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.charLength(Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.charLength(Field)
-
bitLength
Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.bitLength(Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.bitLength(Field)
-
octetLength
Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.octetLength(Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.octetLength(Field)
-
extract
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<Integer> extract(DatePart datePart)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.extract(Field, DatePart)instead.- See Also:
DSL.extract(Field, DatePart)
-
greatest
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> greatest(T... others)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.greatest(Field, Field...)instead.- See Also:
DSL.greatest(Field, Field...)
-
greatest
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> greatest(Field<?>... others)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.greatest(Field, Field...)instead.- See Also:
DSL.greatest(Field, Field...)
-
least
Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.least(Field, Field...)instead.- See Also:
DSL.least(Field, Field...)
-
least
@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> least(Field<?>... others)Deprecated, for removal: This API element is subject to removal in a future version.- 3.11 - [#7538] - UseDSL.least(Field, Field...)instead.- See Also:
DSL.least(Field, Field...)
-
nvl
Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.nvl(Field, Object)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.nvl(Field, Object)
-
nvl
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<T> nvl(Field<T> defaultValue)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.nvl(Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.nvl(Field, Field)
-
nvl2
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support <Z> @NotNull Field<Z> nvl2(Z valueIfNotNull, Z valueIfNull)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.nvl2(Field, Object, Object)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.nvl2(Field, Object, Object)
-
nvl2
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support <Z> @NotNull Field<Z> nvl2(Field<Z> valueIfNotNull, Field<Z> valueIfNull)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.nvl2(Field, Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.nvl2(Field, Field, Field)
-
nullif
Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.nullif(Field, Object)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.nullif(Field, Object)
-
nullif
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<T> nullif(Field<T> other)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.nullif(Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.nullif(Field, Field)
-
decode
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support <Z> @NotNull Field<Z> decode(T search, Z result)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.decode(Object, Object, Object)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.decode(Object, Object, Object)
-
decode
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support <Z> @NotNull Field<Z> decode(T search, Z result, Object... more)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.decode(Object, Object, Object, Object...)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext -
decode
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support <Z> @NotNull Field<Z> decode(Field<T> search, Field<Z> result)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.decode(Field, Field, Field)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.decode(Field, Field, Field)
-
decode
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support <Z> @NotNull Field<Z> decode(Field<T> search, Field<Z> result, Field<?>... more)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.decode(Field, Field, Field, Field...)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext -
coalesce
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<T> coalesce(T option, T... options)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.coalesce(Object, Object...)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.coalesce(Object, Object...)
-
coalesce
@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<T> coalesce(Field<T> option, Field<?>... options)Deprecated, for removal: This API element is subject to removal in a future version.- 3.13 - [#9407] - UseDSL.coalesce(Field, Field...)instead.This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext- See Also:
DSL.coalesce(Field, Field...)
-
plus
Turn this field into an Oracle-specific field for use in outer-join predicates. It can be emulated usingSettings.isTransformTableListsToAnsiJoin().Example:
TABLE1.COL.plus().eq(TABLE2.COL); TABLE1.COL.eq(TABLE2.COL.plus());
The above will generate
TABLE1.COL(+) = TABLE2.COL TABLE1.COL = TABLE2.COL(+)
-
field
The inverse operation ofFields.field(Field).This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream.
-
get
The inverse operation ofRecord.get(Field).This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream:
DSL.using(configuration) .fetch("select * from t") .stream() .map(MY_TABLE.ID::get) .forEach(System.out::println); -
getValue
The inverse operation ofRecord.getValue(Field).This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream:
DSL.using(configuration) .fetch("select * from t") .stream() .map(MY_TABLE.ID::getValue) .forEach(System.out::println); -
original
The inverse operation ofRecord.original(Field).This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream:
DSL.using(configuration) .fetch("select * from t") .stream() .map(MY_TABLE.ID::original) .forEach(System.out::println); -
changed
The inverse operation ofRecord.changed(Field).This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream:
DSL.using(configuration) .fetch("select * from t") .stream() .map(MY_TABLE.ID::changed) .forEach(System.out::println); -
reset
The inverse operation ofRecord.reset(Field).This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream:
DSL.using(configuration) .fetch("select * from t") .stream() .forEach(MY_TABLE.ID::reset); -
from
The inverse operation ofRecord.into(Field).This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream:
DSL.using(configuration) .fetch("select * from t") .stream() .map(MY_TABLE.ID::from) .forEach(System.out::println);
-
DSL.abs(Field)instead.