- 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):
SELECT
clause, e.g. throughDSL.select(SelectField)
(everyField
is a subtype ofSelectField
)WHERE
clause, e.g. throughSelectWhereStep.where(Field)
(Field<Boolean>
can behave like aCondition
, regardless if your RDBMS supports theBOOLEAN
type)GROUP BY
clause, e.g. throughSelectGroupByStep.groupBy(GroupField...)
(everyField
is a subtype ofGroupField
)HAVING
clause, e.g. throughSelectHavingStep.having(Field)
ORDER BY
clause, e.g. throughSelectOrderByStep.orderBy(OrderField)
(everyField
is 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.TableField
referenced 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 Condition
Create a condition to check this field against some bounds.@NotNull BetweenAndStep<T>
Create a condition to check this field against some bounds.@NotNull Condition
Create 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 Condition
betweenSymmetric(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 Condition
betweenSymmetric(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.boolean
The 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 Condition
compare(Comparator comparator, Field<T> field)
Compare this field with another field using a dynamic comparator.@NotNull Condition
compare(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query)
Compare this field with a quantified subselect using a dynamic comparator.@NotNull Condition
compare(Comparator comparator, Select<? extends Record1<T>> query)
Compare this field with a subselect using a dynamic comparator.@NotNull Condition
compare(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 Condition
Convenience method forlike(String, char)
including proper adding of wildcards and escaping.@NotNull Condition
Convenience method forlike(String, char)
including proper adding of wildcards and escaping.@NotNull Condition
containsIgnoreCase(Field<T> value)
Convenience method forlikeIgnoreCase(String, char)
including proper adding of wildcards and escaping.@NotNull Condition
containsIgnoreCase(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 typeConverter
to this field expression.<U> @NotNull Field<U>
Apply an ad-hoc data typeBinding
to this field expression.<U> @NotNull Field<U>
Apply an ad-hoc data typeConverter
to this field expression.<U> @NotNull Field<U>
convertFrom(Class<U> toType, Function<? super T,? extends U> from)
Apply an ad-hoc read-only data typeConverter
to this field expression.<U> @NotNull Field<U>
convertFrom(Function<? super T,? extends U> from)
Apply an ad-hoc read-only data typeConverter
to this field expression.<U> @NotNull Field<U>
Apply an ad-hoc write-only data typeConverter
to this field expression.<U> @NotNull Field<U>
Apply an ad-hoc write-only data typeConverter
to 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 Condition
Convenience method forlike(String, char)
including proper adding of wildcards and escaping.@NotNull Condition
Convenience method forlike(String, char)
including proper adding of wildcards and escaping.@NotNull Condition
endsWithIgnoreCase(Field<T> value)
Convenience method forlike(String, char)
including proper adding of wildcards and escaping.@NotNull Condition
endsWithIgnoreCase(T value)
Convenience method forlike(String, char)
including proper adding of wildcards and escaping.@NotNull Condition
this = field
.@NotNull Condition
eq(QuantifiedSelect<? extends Record1<T>> query)
this = [quantifier] (Select<?> ...)
.@NotNull Condition
this = (Select<?> ...)
.@NotNull Condition
this = value
.@NotNull Condition
this = field
.@NotNull Condition
equal(QuantifiedSelect<? extends Record1<T>> query)
this = [quantifier] (Select<?> ...)
.@NotNull Condition
this = (Select<?> ...)
.@NotNull Condition
this = value
.@NotNull Condition
equalIgnoreCase(String value)
lower(this) = lower(value)
.@NotNull Condition
equalIgnoreCase(Field<String> value)
lower(this) = lower(value)
.boolean
Check whether thisQueryPart
can 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 Condition
this >= field
.@NotNull Condition
ge(QuantifiedSelect<? extends Record1<T>> query)
this >= [quantifier] (Select<?> ...)
.@NotNull Condition
this >= (Select<?> ...)
.@NotNull Condition
this >= value
.The inverse operation ofRecord.get(Field)
.@NotNull String
The comment given to the field.@NotNull String
getName()
The name of the field.The inverse operation ofRecord.getValue(Field)
.@NotNull Condition
greaterOrEqual(Field<T> field)
this >= field
.@NotNull Condition
greaterOrEqual(QuantifiedSelect<? extends Record1<T>> query)
this >= [quantifier] (Select<?> ...)
.@NotNull Condition
greaterOrEqual(Select<? extends Record1<T>> query)
this >= (Select<?> ...)
.@NotNull Condition
greaterOrEqual(T value)
this >= value
.@NotNull Condition
greaterThan(Field<T> field)
this > field
.@NotNull Condition
greaterThan(QuantifiedSelect<? extends Record1<T>> query)
this > [quantifier] (Select<?> ...)
.@NotNull Condition
greaterThan(Select<? extends Record1<T>> query)
this > (Select<?> ...)
.@NotNull Condition
greaterThan(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 Condition
this > field
.@NotNull Condition
gt(QuantifiedSelect<? extends Record1<T>> query)
this > [quantifier] (Select<?> ...)
.@NotNull Condition
this > (Select<?> ...)
.@NotNull Condition
this > value
.@NotNull Condition
in(Collection<?> values)
Create a condition to check this field against several values.@NotNull Condition
Create a condition to check this field against several values.@NotNull Condition
Create a condition to check this field against several values from a previous query.@NotNull Condition
Create a condition to check this field against a subquery.@NotNull Condition
Create a condition to check this field against several values.@NotNull Condition
isDistinctFrom(Field<T> field)
Create a condition to check if this field isDISTINCT
from another field.@NotNull Condition
isDistinctFrom(Select<? extends Record1<T>> select)
Create a condition to check if this field isDISTINCT
from another field.@NotNull Condition
isDistinctFrom(T value)
Create a condition to check if this field isDISTINCT
from another value.@NotNull Condition
Create a condition to check if this field contains XML data.@NotNull Condition
isFalse()
Create a condition to check this field against known string literals forfalse
.@NotNull Condition
isJson()
Create a condition to check if this field contains JSON data.@NotNull Condition
isNotDistinctFrom(Field<T> field)
Create a condition to check if this field isNOT DISTINCT
from another field.@NotNull Condition
isNotDistinctFrom(Select<? extends Record1<T>> select)
Create a condition to check if this field isNOT DISTINCT
from another field.@NotNull Condition
isNotDistinctFrom(T value)
Create a condition to check if this field isNOT DISTINCT
from another value.@NotNull Condition
Create a condition to check if this field does not contain XML data.@NotNull Condition
Create a condition to check if this field does not contain JSON data.@NotNull Condition
Create a condition to check this field againstnull
.@NotNull Condition
isNull()
Create a condition to check this field againstnull
.@NotNull Condition
isTrue()
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 Condition
this <= field
.@NotNull Condition
le(QuantifiedSelect<? extends Record1<T>> query)
this <= [quantifier] (Select<?> ...)
.@NotNull Condition
this <= (Select<?> ...)
.@NotNull Condition
this <= 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 Condition
lessOrEqual(Field<T> field)
this <= field
.@NotNull Condition
lessOrEqual(QuantifiedSelect<? extends Record1<T>> query)
this <= [quantifier] (Select<?> ...)
.@NotNull Condition
lessOrEqual(Select<? extends Record1<T>> query)
this <= (Select<?> ...)
.@NotNull Condition
lessOrEqual(T value)
this <= value
.@NotNull Condition
this < field
.@NotNull Condition
lessThan(QuantifiedSelect<? extends Record1<T>> query)
this < [quantifier] (Select<?> ...)
.@NotNull Condition
this < (Select<?> ...)
.@NotNull Condition
this < value
.@NotNull LikeEscapeStep
Create a condition to pattern-check this field against a value.@NotNull Condition
Create a condition to pattern-check this field against a value.@NotNull LikeEscapeStep
Create a condition to pattern-check this field against a value.@NotNull Condition
Create a condition to pattern-check this field against a value.@NotNull LikeEscapeStep
like(QuantifiedSelect<Record1<String>> query)
Create a condition to pattern-check this field against a quantified select.@NotNull LikeEscapeStep
likeIgnoreCase(String value)
Create a condition to case-insensitively pattern-check this field against a value.@NotNull Condition
likeIgnoreCase(String value, char escape)
Create a condition to case-insensitively pattern-check this field against a value.@NotNull LikeEscapeStep
likeIgnoreCase(Field<String> field)
Create a condition to case-insensitively pattern-check this field against a field.@NotNull Condition
likeIgnoreCase(Field<String> field, char escape)
Create a condition to case-insensitively pattern-check this field against a field.@NotNull Condition
Create a condition to regex-pattern-check this field against a pattern.@NotNull Condition
Create 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 Condition
this < field
.@NotNull Condition
lt(QuantifiedSelect<? extends Record1<T>> query)
this < [quantifier] (Select<?> ...)
.@NotNull Condition
this < (Select<?> ...)
.@NotNull Condition
this < 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 Condition
this != field
.@NotNull Condition
ne(QuantifiedSelect<? extends Record1<T>> query)
this != [quantifier] (Select<?> ...)
.@NotNull Condition
this != (Select<?> ...)
.@NotNull Condition
this != 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 Condition
notBetween(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 Condition
notBetween(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 Condition
notBetweenSymmetric(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 Condition
notBetweenSymmetric(T minValue, T maxValue)
Create a condition to check this field against some bounds.@NotNull Condition
notContains(Field<T> value)
Inverse ofcontains(Field)
.@NotNull Condition
notContains(T value)
Inverse ofcontains(Object)
.@NotNull Condition
notContainsIgnoreCase(Field<T> value)
Inverse ofcontainsIgnoreCase(Field)
@NotNull Condition
notContainsIgnoreCase(T value)
Inverse ofcontainsIgnoreCase(Object)
@NotNull Condition
this != field
.@NotNull Condition
notEqual(QuantifiedSelect<? extends Record1<T>> query)
this != [quantifier] (Select<?> ...)
.@NotNull Condition
this != (Select<?> ...)
.@NotNull Condition
this != value
.@NotNull Condition
notEqualIgnoreCase(String value)
lower(this) != lower(value)
.@NotNull Condition
notEqualIgnoreCase(Field<String> value)
lower(this) != lower(value)
.@NotNull Condition
notIn(Collection<?> values)
Create a condition to check this field against several values.@NotNull Condition
Create a condition to check this field against several values.@NotNull Condition
Create a condition to check this field against several values from a previous query.@NotNull Condition
Create a condition to check this field against a subquery.@NotNull Condition
Create a condition to check this field against several values.@NotNull LikeEscapeStep
Create a condition to pattern-check this field against a value.@NotNull Condition
Create a condition to pattern-check this field against a value.@NotNull LikeEscapeStep
Create a condition to pattern-check this field against a field.@NotNull Condition
Create a condition to pattern-check this field against a field.@NotNull LikeEscapeStep
notLike(QuantifiedSelect<Record1<String>> query)
Create a condition to pattern-check this field against a quantified select.@NotNull LikeEscapeStep
notLikeIgnoreCase(String value)
Create a condition to case-insensitively pattern-check this field against a value.@NotNull Condition
notLikeIgnoreCase(String value, char escape)
Create a condition to case-insensitively pattern-check this field against a value.@NotNull LikeEscapeStep
notLikeIgnoreCase(Field<String> field)
Create a condition to case-insensitively pattern-check this field against a field.@NotNull Condition
notLikeIgnoreCase(Field<String> field, char escape)
Create a condition to case-insensitively pattern-check this field against a field.@NotNull Condition
notLikeRegex(String pattern)
Create a condition to regex-pattern-check this field against a pattern.@NotNull Condition
notLikeRegex(Field<String> pattern)
Create a condition to regex-pattern-check this field against a pattern.@NotNull LikeEscapeStep
notSimilarTo(String value)
Create a condition to pattern-check this field against a value.@NotNull Condition
notSimilarTo(String value, char escape)
Create a condition to pattern-check this field against a value.@NotNull LikeEscapeStep
notSimilarTo(Field<String> field)
Create a condition to pattern-check this field against a field.@NotNull Condition
notSimilarTo(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.void
The 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 LikeEscapeStep
Create a condition to pattern-check this field against a value.@NotNull Condition
Create a condition to pattern-check this field against a value.@NotNull LikeEscapeStep
Create a condition to pattern-check this field against a value.@NotNull Condition
Create 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 Condition
startsWith(Field<T> value)
Convenience method forlike(String, char)
including proper adding of wildcards and escaping.@NotNull Condition
startsWith(T value)
Convenience method forlike(String, char)
including proper adding of wildcards and escaping.@NotNull Condition
startsWithIgnoreCase(Field<T> value)
Convenience method forlike(String, char)
including proper adding of wildcards and escaping.@NotNull Condition
startsWithIgnoreCase(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, getUnqualifiedName
Methods inherited from interface org.jooq.SelectField
as, as, as
Methods 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
Field
is 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:
getComment
in 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 thisQueryPart
can be considered equal to anotherQueryPart
.In general,
QueryPart
equality 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
QueryPart
implementations 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 typeBinding
to 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 typeConverter
to 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 typeConverter
to 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 typeConverter
to 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 typeConverter
to 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 explicitClass
reference 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 typeConverter
to 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 typeConverter
to 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 explicitClass
reference 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
DataType
has 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 ASC
Note: 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 ASC
Note: 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 DESC
Note: 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 DESC
Note: 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 DESC
Note: 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
INTERVAL
field, then the result is also anINTERVAL
field (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
INTERVAL
field, then the result is also anINTERVAL
field (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
INTERVAL
field, then the result is also anINTERVAL
field (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
INTERVAL
field, then the result is also anINTERVAL
field (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 isDISTINCT
from another value.In
SQLDialect.MYSQL
andSQLDialect.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 END
this is distinct from value
-
isDistinctFrom
Create a condition to check if this field isDISTINCT
from another field.In
SQLDialect.MYSQL
andSQLDialect.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 END
this is distinct from field
-
isDistinctFrom
Create a condition to check if this field isDISTINCT
from another field.In
SQLDialect.MYSQL
andSQLDialect.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 END
this is distinct from field
-
isNotDistinctFrom
Create a condition to check if this field isNOT DISTINCT
from another value.In
SQLDialect.MYSQL
andSQLDialect.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 END
this is not distinct from value
-
isNotDistinctFrom
Create a condition to check if this field isNOT DISTINCT
from another field.In
SQLDialect.MYSQL
andSQLDialect.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 END
this is not distinct from field
-
isNotDistinctFrom
Create a condition to check if this field isNOT DISTINCT
from another field.In
SQLDialect.MYSQL
andSQLDialect.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 END
this 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_REGEX
operator 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 field
inSQLDialect.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 field
inSQLDialect.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 value
inSQLDialect.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 value
inSQLDialect.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 field
inSQLDialect.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 field
inSQLDialect.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 value
inSQLDialect.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 value
inSQLDialect.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
IN
predicates 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 avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates 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
IN
predicates 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 avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates 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
IN
predicates 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 avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates 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 IN
predicates 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 avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates 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 IN
predicates 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 avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates 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 IN
predicates 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 avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates 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.