Module org.jooq

Package org.jooq

Interface Field<T>

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>, JSONArrayNullStep<T>, JSONObjectAggNullStep<T>, JSONObjectNullStep<T>, JSONValueOnStep<J>, Param<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

public interface Field<T>
extends SelectField<T>, GroupField, OrderField<T>, FieldOrRow, FieldOrConstraint

A column expression.

Column expressions or fields can be used in a variety of SQL statements and clauses, including (non-exhaustive list):

• SELECT clause, e.g. through DSL.select(SelectField) (every Field is a subtype of SelectField)
• WHERE clause, e.g. through SelectWhereStep.where(Field) (Field<Boolean> can behave like a Condition, regardless if your RDBMS supports the BOOLEAN type)
• GROUP BY clause, e.g. through SelectGroupByStep.groupBy(GroupField...) (every Field is a subtype of GroupField)
• HAVING clause, e.g. through SelectHavingStep.having(Field)
• ORDER BY clause, e.g. through SelectOrderByStep.orderBy(OrderField) (every Field is a subtype of OrderField)
• When creating a Condition, e.g. through eq(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.
• Fields referenced from generated tables

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull Field<T>	abs()	Deprecated. - 3.11 - [#7538] - Use DSL.abs(Field) instead.
@NotNull Field<BigDecimal>	acos()	Deprecated. - 3.11 - [#7538] - Use DSL.acos(Field) instead.
@NotNull Field<T>	add(Number value)	An arithmetic expression adding this to value.
@NotNull Field<T>	add(Field<?> value)	An arithmetic expression to add value to this.
@NotNull Field<T>	as(String alias)	Create an alias for this field.
@NotNull Field<T>	as(Function<? super Field<T>,? extends String> aliasFunction)	Deprecated. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull Field<T>	as(Field<?> otherField)	Create an alias for this field based on another field's name.
@NotNull Field<T>	as(Name alias)	Create an alias for this field.
@NotNull SortField<T>	asc()	Create an ascending sort field from this field.
@NotNull Field<Integer>	ascii()	Deprecated. - 3.13 - [#9407] - Use DSL.ascii(Field) instead.
@NotNull Field<BigDecimal>	asin()	Deprecated. - 3.11 - [#7538] - Use DSL.asin(Field) instead.
@NotNull Field<BigDecimal>	atan()	Deprecated. - 3.11 - [#7538] - Use DSL.atan(Field) instead.
@NotNull Field<BigDecimal>	atan2(Number y)	Deprecated. - 3.11 - [#7538] - Use DSL.atan2(Field, Number) instead.
@NotNull Field<BigDecimal>	atan2(Field<? extends Number> y)	Deprecated. - 3.11 - [#7538] - Use DSL.atan2(Field, Field) instead.
@NotNull Field<BigDecimal>	avg()	Deprecated. - 3.11 - [#7538] - Use DSL.avg(Field) instead.
@NotNull WindowPartitionByStep<BigDecimal>	avgOver()	Deprecated. - 3.11 - [#7538] - Use DSL.avg(Field) instead.
@NotNull BetweenAndStep<T>	between(Field<T> minValue)	Create a condition to check this field against some bounds.
@NotNull Condition	between(Field<T> minValue, Field<T> maxValue)	Create a condition to check this field against some bounds.
@NotNull BetweenAndStep<T>	between(T minValue)	Create a condition to check this field against some bounds.
@NotNull Condition	between(T minValue, T maxValue)	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.
@NotNull Field<T>	bitAnd(Field<T> value)	The bitwise and operator.
@NotNull Field<T>	bitAnd(T value)	The bitwise and operator.
@NotNull Field<Integer>	bitLength()	Deprecated. - 3.13 - [#9407] - Use DSL.bitLength(Field) instead.
@NotNull Field<T>	bitNand(Field<T> value)	The bitwise not and operator.
@NotNull Field<T>	bitNand(T value)	The bitwise not and operator.
@NotNull Field<T>	bitNor(Field<T> value)	The bitwise not or operator.
@NotNull Field<T>	bitNor(T value)	The bitwise not or operator.
@NotNull Field<T>	bitNot()	The bitwise not operator.
@NotNull Field<T>	bitOr(Field<T> value)	The bitwise or operator.
@NotNull Field<T>	bitOr(T value)	The bitwise or operator.
@NotNull Field<T>	bitXNor(Field<T> value)	The bitwise not xor operator.
@NotNull Field<T>	bitXNor(T value)	The bitwise not xor operator.
@NotNull Field<T>	bitXor(Field<T> value)	The bitwise xor operator.
@NotNull Field<T>	bitXor(T value)	The bitwise xor operator.
<Z> @NotNull Field<Z>	cast(Class<Z> type)	Cast this field to another type.
<Z> @NotNull Field<Z>	cast(DataType<Z> type)	Cast this field to a dialect-specific data type.
<Z> @NotNull Field<Z>	cast(Field<Z> field)	Cast this field to the type of another field.
@NotNull Field<T>	ceil()	Deprecated. - 3.11 - [#7538] - Use DSL.ceil(Field) instead.
boolean	changed(Record record)	The inverse operation of Record.changed(Field).
@NotNull Field<Integer>	charLength()	Deprecated. - 3.13 - [#9407] - Use DSL.charLength(Field) instead.
@NotNull Field<T>	coalesce(Field<T> option, Field<?>... options)	Deprecated. - 3.13 - [#9407] - Use DSL.coalesce(Field, Field...) instead.
@NotNull Field<T>	coalesce(T option, T... options)	Deprecated. - 3.13 - [#9407] - Use DSL.coalesce(Object, Object...) instead.
<Z> @NotNull Field<Z>	coerce(Class<Z> type)	Coerce this field to another type.
<Z> @NotNull Field<Z>	coerce(DataType<Z> type)	Coerce this field to a dialect-specific data type.
<Z> @NotNull Field<Z>	coerce(Field<Z> field)	Coerce this field to the type of another field.
@NotNull Field<String>	collate(String collation)	Apply a collation operator to this column expression.
@NotNull Field<String>	collate(Collation collation)	Apply a collation operator to this column expression.
@NotNull Field<String>	collate(Name collation)	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.
@NotNull Field<String>	concat(char... values)	This method is part of the pre-2.0 API.
@NotNull Field<String>	concat(String... values)	This method is part of the pre-2.0 API.
@NotNull Field<String>	concat(Field<?>... fields)	This method is part of the pre-2.0 API.
@NotNull Condition	contains(Field<T> value)	Convenience method for like(String, char) including proper adding of wildcards and escaping.
@NotNull Condition	contains(T value)	Convenience method for like(String, char) including proper adding of wildcards and escaping.
@NotNull Condition	containsIgnoreCase(Field<T> value)	Convenience method for likeIgnoreCase(String, char) including proper adding of wildcards and escaping.
@NotNull Condition	containsIgnoreCase(T value)	Convenience method for likeIgnoreCase(String, char) including proper adding of wildcards and escaping.
@NotNull Field<BigDecimal>	cos()	Deprecated. - 3.11 - [#7538] - Use DSL.cos(Field) instead.
@NotNull Field<BigDecimal>	cosh()	Deprecated. - 3.11 - [#7538] - Use DSL.cosh(Field) instead.
@NotNull Field<BigDecimal>	cot()	Deprecated. - 3.11 - [#7538] - Use DSL.cot(Field) instead.
@NotNull Field<BigDecimal>	coth()	Deprecated. - 3.11 - [#7538] - Use DSL.coth(Field) instead.
@NotNull Field<Integer>	count()	Deprecated. - 3.11 - [#7538] - Use DSL.count(Field) instead.
@NotNull Field<Integer>	countDistinct()	Deprecated. - 3.11 - [#7538] - Use DSL.countDistinct(Field) instead.
@NotNull WindowPartitionByStep<Integer>	countOver()	Deprecated. - 3.11 - [#7538] - Use DSL.count(Field) instead.
<Z> @NotNull Field<Z>	decode(Field<T> search, Field<Z> result)	Deprecated. - 3.13 - [#9407] - Use DSL.decode(Field, Field, Field) instead.
<Z> @NotNull Field<Z>	decode(Field<T> search, Field<Z> result, Field<?>... more)	Deprecated. - 3.13 - [#9407] - Use DSL.decode(Field, Field, Field, Field...) instead.
<Z> @NotNull Field<Z>	decode(T search, Z result)	Deprecated. - 3.13 - [#9407] - Use DSL.decode(Object, Object, Object) instead.
<Z> @NotNull Field<Z>	decode(T search, Z result, Object... more)	Deprecated. - 3.13 - [#9407] - Use DSL.decode(Object, Object, Object, Object...) instead.
@NotNull Field<BigDecimal>	deg()	Deprecated. - 3.11 - [#7538] - Use DSL.deg(Field) instead.
@NotNull SortField<T>	desc()	Create a descending sort field from this field.
@NotNull Field<T>	div(Number value)	An arithmetic expression dividing this by value.
@NotNull Field<T>	div(Field<? extends Number> value)	An arithmetic expression dividing this by value.
@NotNull Field<T>	divide(Number value)	An alias for div(Number).
@NotNull Field<T>	divide(Field<? extends Number> value)	An alias for div(Field).
@NotNull Condition	endsWith(Field<T> value)	Convenience method for like(String, char) including proper adding of wildcards and escaping.
@NotNull Condition	endsWith(T value)	Convenience method for like(String, char) including proper adding of wildcards and escaping.
@NotNull Condition	endsWithIgnoreCase(Field<T> value)	Convenience method for like(String, char) including proper adding of wildcards and escaping.
@NotNull Condition	endsWithIgnoreCase(T value)	Convenience method for like(String, char) including proper adding of wildcards and escaping.
@NotNull Condition	eq(Field<T> field)	this = field.
@NotNull Condition	eq(QuantifiedSelect<? extends Record1<T>> query)	this = [quantifier] (Select<?> ...).
@NotNull Condition	eq(Select<? extends Record1<T>> query)	this = (Select<?> ...).
@NotNull Condition	eq(T value)	this = value.
@NotNull Condition	equal(Field<T> field)	this = field.
@NotNull Condition	equal(QuantifiedSelect<? extends Record1<T>> query)	this = [quantifier] (Select<?> ...).
@NotNull Condition	equal(Select<? extends Record1<T>> query)	this = (Select<?> ...).
@NotNull Condition	equal(T value)	this = value.
@NotNull Condition	equalIgnoreCase(String value)	lower(this) = lower(value).
@NotNull Condition	equalIgnoreCase(Field<String> value)	lower(this) = lower(value).
boolean	equals(Object other)	Check whether this QueryPart can be considered equal to another QueryPart.
@NotNull Field<BigDecimal>	exp()	Deprecated. - 3.11 - [#7538] - Use DSL.exp(Field) instead.
@NotNull Field<Integer>	extract(DatePart datePart)	Deprecated. - 3.11 - [#7538] - Use DSL.extract(Field, DatePart) instead.
@Nullable Field<T>	field(Record record)	The inverse operation of Record.field(Field).
@NotNull WindowIgnoreNullsStep<T>	firstValue()	Deprecated. - 3.11 - [#7538] - Use DSL.firstValue(Field) instead.
@NotNull Field<T>	floor()	Deprecated. - 3.11 - [#7538] - Use DSL.floor(Field) instead.
@Nullable Record1<T>	from(Record record)	The inverse operation of Record.into(Field).
@NotNull Condition	ge(Field<T> field)	this >= field.
@NotNull Condition	ge(QuantifiedSelect<? extends Record1<T>> query)	this >= [quantifier] (Select<?> ...).
@NotNull Condition	ge(Select<? extends Record1<T>> query)	this >= (Select<?> ...).
@NotNull Condition	ge(T value)	this >= value.
T	get(Record record)	The inverse operation of Record.get(Field).
@NotNull String	getComment()	The comment given to the field.
@NotNull String	getName()	The name of the field.
T	getValue(Record record)	The inverse operation of Record.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.
@NotNull Field<T>	greatest(Field<?>... others)	Deprecated. - 3.11 - [#7538] - Use DSL.greatest(Field, Field...) instead.
@NotNull Field<T>	greatest(T... others)	Deprecated. - 3.11 - [#7538] - Use DSL.greatest(Field, Field...) instead.
@NotNull Condition	gt(Field<T> field)	this > field.
@NotNull Condition	gt(QuantifiedSelect<? extends Record1<T>> query)	this > [quantifier] (Select<?> ...).
@NotNull Condition	gt(Select<? extends Record1<T>> query)	this > (Select<?> ...).
@NotNull Condition	gt(T value)	this > value.
@NotNull Condition	in(Collection<?> values)	Create a condition to check this field against several values.
@NotNull Condition	in(Field<?>... values)	Create a condition to check this field against several values.
@NotNull Condition	in(Result<? extends Record1<T>> result)	Create a condition to check this field against several values from a previous query.
@NotNull Condition	in(Select<? extends Record1<T>> query)	Create a condition to check this field against a subquery.
@NotNull Condition	in(T... values)	Create a condition to check this field against several values.
@NotNull Condition	isDistinctFrom(Field<T> field)	Create a condition to check if this field is DISTINCT from another field.
@NotNull Condition	isDistinctFrom(Select<? extends Record1<T>> select)	Create a condition to check if this field is DISTINCT from another field.
@NotNull Condition	isDistinctFrom(T value)	Create a condition to check if this field is DISTINCT from another value.
@NotNull Condition	isDocument()	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 for false.
@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 is NOT DISTINCT from another field.
@NotNull Condition	isNotDistinctFrom(Select<? extends Record1<T>> select)	Create a condition to check if this field is NOT DISTINCT from another field.
@NotNull Condition	isNotDistinctFrom(T value)	Create a condition to check if this field is NOT DISTINCT from another value.
@NotNull Condition	isNotDocument()	Create a condition to check if this field does not contain XML data.
@NotNull Condition	isNotJson()	Create a condition to check if this field does not contain JSON data.
@NotNull Condition	isNotNull()	Create a condition to check this field against null.
@NotNull Condition	isNull()	Create a condition to check this field against null.
@NotNull Condition	isTrue()	Create a condition to check this field against known string literals for true.
@NotNull WindowIgnoreNullsStep<T>	lag()	Deprecated. - 3.11 - [#7538] - Use DSL.lag(Field) instead.
@NotNull WindowIgnoreNullsStep<T>	lag(int offset)	Deprecated. - 3.11 - [#7538] - Use DSL.lag(Field, int) instead.
@NotNull WindowIgnoreNullsStep<T>	lag(int offset, Field<T> defaultValue)	Deprecated. - 3.11 - [#7538] - Use DSL.lag(Field, int, Field) instead.
@NotNull WindowIgnoreNullsStep<T>	lag(int offset, T defaultValue)	Deprecated. - 3.11 - [#7538] - Use DSL.lag(Field, int, Object) instead.
@NotNull WindowIgnoreNullsStep<T>	lastValue()	Deprecated. - 3.11 - [#7538] - Use DSL.lastValue(Field) instead.
@NotNull Condition	le(Field<T> field)	this <= field.
@NotNull Condition	le(QuantifiedSelect<? extends Record1<T>> query)	this <= [quantifier] (Select<?> ...).
@NotNull Condition	le(Select<? extends Record1<T>> query)	this <= (Select<?> ...).
@NotNull Condition	le(T value)	this <= value.
@NotNull WindowIgnoreNullsStep<T>	lead()	Deprecated. - 3.11 - [#7538] - Use DSL.lead(Field) instead.
@NotNull WindowIgnoreNullsStep<T>	lead(int offset)	Deprecated. - 3.11 - [#7538] - Use DSL.lead(Field, int) instead.
@NotNull WindowIgnoreNullsStep<T>	lead(int offset, Field<T> defaultValue)	Deprecated. - 3.11 - [#7538] - Use DSL.lead(Field, int, Field) instead.
@NotNull WindowIgnoreNullsStep<T>	lead(int offset, T defaultValue)	Deprecated. - 3.11 - [#7538] - Use DSL.lead(Field, int, Object) instead.
@NotNull Field<T>	least(Field<?>... others)	Deprecated. - 3.11 - [#7538] - Use DSL.least(Field, Field...) instead.
@NotNull Field<T>	least(T... others)	Deprecated. - 3.11 - [#7538] - Use DSL.least(Field, Field...) instead.
@NotNull Field<Integer>	length()	Deprecated. - 3.13 - [#9407] - Use DSL.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	lessThan(Field<T> field)	this < field.
@NotNull Condition	lessThan(QuantifiedSelect<? extends Record1<T>> query)	this < [quantifier] (Select<?> ...).
@NotNull Condition	lessThan(Select<? extends Record1<T>> query)	this < (Select<?> ...).
@NotNull Condition	lessThan(T value)	this < value.
@NotNull LikeEscapeStep	like(String value)	Create a condition to pattern-check this field against a value.
@NotNull Condition	like(String value, char escape)	Create a condition to pattern-check this field against a value.
@NotNull LikeEscapeStep	like(Field<String> value)	Create a condition to pattern-check this field against a value.
@NotNull Condition	like(Field<String> value, char escape)	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	likeRegex(String pattern)	Create a condition to regex-pattern-check this field against a pattern.
@NotNull Condition	likeRegex(Field<String> pattern)	Create a condition to regex-pattern-check this field against a pattern.
@NotNull Field<BigDecimal>	ln()	Deprecated. - 3.11 - [#7538] - Use DSL.ln(Field) instead.
@NotNull Field<BigDecimal>	log(int base)	Deprecated. - 3.11 - [#7538] - Use DSL.log(Field, int) instead.
@NotNull Field<String>	lower()	Deprecated. - 3.13 - [#9407] - Use DSL.lower(Field) instead.
@NotNull Field<String>	lpad(int length)	Deprecated. - 3.13 - [#9407] - Use DSL.lpad(Field, int) instead.
@NotNull Field<String>	lpad(int length, char character)	Deprecated. - 3.13 - [#9407] - Use DSL.lpad(Field, int, char) instead.
@NotNull Field<String>	lpad(Field<? extends Number> length)	Deprecated. - 3.13 - [#9407] - Use DSL.lpad(Field, Field) instead.
@NotNull Field<String>	lpad(Field<? extends Number> length, Field<String> character)	Deprecated. - 3.13 - [#9407] - Use DSL.lpad(Field, Field, Field) instead.
@NotNull Condition	lt(Field<T> field)	this < field.
@NotNull Condition	lt(QuantifiedSelect<? extends Record1<T>> query)	this < [quantifier] (Select<?> ...).
@NotNull Condition	lt(Select<? extends Record1<T>> query)	this < (Select<?> ...).
@NotNull Condition	lt(T value)	this < value.
@NotNull Field<String>	ltrim()	Deprecated. - 3.13 - [#9407] - Use DSL.ltrim(Field) instead.
@NotNull Field<T>	max()	Deprecated. - 3.11 - [#7538] - Use DSL.max(Field) instead.
@NotNull WindowPartitionByStep<T>	maxOver()	Deprecated. - 3.11 - [#7538] - Use DSL.max(Field) instead.
@NotNull Field<BigDecimal>	median()	Deprecated. - 3.11 - [#7538] - Use DSL.median(Field) instead.
@NotNull Field<T>	min()	Deprecated. - 3.11 - [#7538] - Use DSL.min(Field) instead.
@NotNull WindowPartitionByStep<T>	minOver()	Deprecated. - 3.11 - [#7538] - Use DSL.min(Field) instead.
@NotNull Field<T>	minus(Number value)	An alias for sub(Number).
@NotNull Field<T>	minus(Field<?> value)	An alias for sub(Field).
@NotNull Field<T>	mod(Number value)	An arithmetic expression getting the modulo of this divided by value.
@NotNull Field<T>	mod(Field<? extends Number> value)	An arithmetic expression getting the modulo of this divided by value.
@NotNull Field<T>	modulo(Number value)	An alias for mod(Number).
@NotNull Field<T>	modulo(Field<? extends Number> value)	An alias for mod(Field).
@NotNull Field<T>	mul(Number value)	An arithmetic expression multiplying this with value.
@NotNull Field<T>	mul(Field<? extends Number> value)	An arithmetic expression multiplying this with value.
@NotNull Field<T>	multiply(Number value)	An alias for mul(Number).
@NotNull Field<T>	multiply(Field<? extends Number> value)	An alias for mul(Field).
@NotNull Condition	ne(Field<T> field)	this != field.
@NotNull Condition	ne(QuantifiedSelect<? extends Record1<T>> query)	this != [quantifier] (Select<?> ...).
@NotNull Condition	ne(Select<? extends Record1<T>> query)	this != (Select<?> ...).
@NotNull Condition	ne(T value)	this != value.
@NotNull Field<T>	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 of contains(Field).
@NotNull Condition	notContains(T value)	Inverse of contains(Object).
@NotNull Condition	notContainsIgnoreCase(Field<T> value)	Inverse of containsIgnoreCase(Field)
@NotNull Condition	notContainsIgnoreCase(T value)	Inverse of containsIgnoreCase(Object)
@NotNull Condition	notEqual(Field<T> field)	this != field.
@NotNull Condition	notEqual(QuantifiedSelect<? extends Record1<T>> query)	this != [quantifier] (Select<?> ...).
@NotNull Condition	notEqual(Select<? extends Record1<T>> query)	this != (Select<?> ...).
@NotNull Condition	notEqual(T value)	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	notIn(Field<?>... values)	Create a condition to check this field against several values.
@NotNull Condition	notIn(Result<? extends Record1<T>> result)	Create a condition to check this field against several values from a previous query.
@NotNull Condition	notIn(Select<? extends Record1<T>> query)	Create a condition to check this field against a subquery.
@NotNull Condition	notIn(T... values)	Create a condition to check this field against several values.
@NotNull LikeEscapeStep	notLike(String value)	Create a condition to pattern-check this field against a value.
@NotNull Condition	notLike(String value, char escape)	Create a condition to pattern-check this field against a value.
@NotNull LikeEscapeStep	notLike(Field<String> field)	Create a condition to pattern-check this field against a field.
@NotNull Condition	notLike(Field<String> field, char escape)	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.
@NotNull Field<T>	nullif(Field<T> other)	Deprecated. - 3.13 - [#9407] - Use DSL.nullif(Field, Field) instead.
@NotNull Field<T>	nullif(T other)	Deprecated. - 3.13 - [#9407] - Use DSL.nullif(Field, Object) instead.
@NotNull Field<T>	nvl(Field<T> defaultValue)	Deprecated. - 3.13 - [#9407] - Use DSL.nvl(Field, Field) instead.
@NotNull Field<T>	nvl(T defaultValue)	Deprecated. - 3.13 - [#9407] - Use DSL.nvl(Field, Object) instead.
<Z> @NotNull Field<Z>	nvl2(Field<Z> valueIfNotNull, Field<Z> valueIfNull)	Deprecated. - 3.13 - [#9407] - Use DSL.nvl2(Field, Field, Field) instead.
<Z> @NotNull Field<Z>	nvl2(Z valueIfNotNull, Z valueIfNull)	Deprecated. - 3.13 - [#9407] - Use DSL.nvl2(Field, Object, Object) instead.
@NotNull Field<Integer>	octetLength()	Deprecated. - 3.13 - [#9407] - Use DSL.octetLength(Field) instead.
T	original(Record record)	The inverse operation of Record.original(Field).
@NotNull Field<T>	plus()	Turn this field into an Oracle-specific field for use in outer-join predicates.
@NotNull Field<T>	plus(Number value)	An alias for add(Number).
@NotNull Field<T>	plus(Field<?> value)	An alias for add(Field).
@NotNull Field<Integer>	position(String search)	Deprecated. - 3.13 - [#9407] - Use DSL.position(Field, String) instead.
@NotNull Field<Integer>	position(Field<String> search)	Deprecated. - 3.13 - [#9407] - Use DSL.position(Field, Field) instead.
@NotNull Field<BigDecimal>	pow(Number exponent)	An arithmetic expression getting this value raised to the power of exponent.
@NotNull Field<BigDecimal>	pow(Field<? extends Number> exponent)	An arithmetic expression getting this value raised to the power of exponent.
@NotNull Field<BigDecimal>	power(Number exponent)	An alias for power(Number).
@NotNull Field<BigDecimal>	power(Field<? extends Number> exponent)	An alias for power(Field).
@NotNull Field<BigDecimal>	rad()	Deprecated. - 3.11 - [#7538] - Use DSL.rad(Field) instead.
@NotNull Field<T>	rem(Number value)	An alias for mod(Number).
@NotNull Field<T>	rem(Field<? extends Number> value)	An alias for mod(Field).
@NotNull Field<String>	repeat(Number count)	Deprecated. - 3.13 - [#9407] - Use DSL.repeat(Field, int) instead.
@NotNull Field<String>	repeat(Field<? extends Number> count)	Deprecated. - 3.13 - [#9407] - Use DSL.repeat(Field, Field) instead.
@NotNull Field<String>	replace(String search)	Deprecated. - 3.13 - [#9407] - Use DSL.replace(Field, String) instead.
@NotNull Field<String>	replace(String search, String replace)	Deprecated. - 3.13 - [#9407] - Use DSL.replace(Field, String, String) instead.
@NotNull Field<String>	replace(Field<String> search)	Deprecated. - 3.13 - [#9407] - Use DSL.replace(Field, Field) instead.
@NotNull Field<String>	replace(Field<String> search, Field<String> replace)	Deprecated. - 3.13 - [#9407] - Use DSL.replace(Field, Field, Field) instead.
void	reset(Record record)	The inverse operation of Record.reset(Field).
@NotNull Field<T>	round()	Deprecated. - 3.11 - [#7538] - Use DSL.round(Field) instead.
@NotNull Field<T>	round(int decimals)	Deprecated. - 3.11 - [#7538] - Use DSL.round(Field, int) instead.
@NotNull Field<String>	rpad(int length)	Deprecated. - 3.13 - [#9407] - Use DSL.rpad(Field, int) instead.
@NotNull Field<String>	rpad(int length, char character)	Deprecated. - 3.13 - [#9407] - Use DSL.rpad(Field, int, char) instead.
@NotNull Field<String>	rpad(Field<? extends Number> length)	Deprecated. - 3.13 - [#9407] - Use DSL.rpad(Field, Field) instead.
@NotNull Field<String>	rpad(Field<? extends Number> length, Field<String> character)	Deprecated. - 3.13 - [#9407] - Use DSL.rpad(Field, Field, Field) instead.
@NotNull Field<String>	rtrim()	Deprecated. - 3.13 - [#9407] - Use DSL.rtrim(Field) instead.
@NotNull Field<T>	shl(Number value)	The bitwise left shift operator.
@NotNull Field<T>	shl(Field<? extends Number> value)	The bitwise left shift operator.
@NotNull Field<T>	shr(Number value)	The bitwise right shift operator.
@NotNull Field<T>	shr(Field<? extends Number> value)	The bitwise right shift operator.
@NotNull Field<Integer>	sign()	Deprecated. - 3.11 - [#7538] - Use DSL.sign(Field) instead.
@NotNull LikeEscapeStep	similarTo(String value)	Create a condition to pattern-check this field against a value.
@NotNull Condition	similarTo(String value, char escape)	Create a condition to pattern-check this field against a value.
@NotNull LikeEscapeStep	similarTo(Field<String> value)	Create a condition to pattern-check this field against a value.
@NotNull Condition	similarTo(Field<String> value, char escape)	Create a condition to pattern-check this field against a value.
@NotNull Field<BigDecimal>	sin()	Deprecated. - 3.11 - [#7538] - Use DSL.sin(Field) instead.
@NotNull Field<BigDecimal>	sinh()	Deprecated. - 3.11 - [#7538] - Use DSL.sinh(Field) instead.
<Z> @NotNull SortField<Z>	sort(Map<T,Z> sortMap)	Create an indirected sort field.
@NotNull SortField<T>	sort(SortOrder order)	Create an ascending/descending sort field from this field.
@NotNull SortField<Integer>	sortAsc(Collection<T> sortList)	Create an indirected sort field.
@NotNull SortField<Integer>	sortAsc(T... sortList)	Create an indirected sort field.
@NotNull SortField<T>	sortDefault()	Create a default sorted (implicit ASC) from this field.
@NotNull SortField<Integer>	sortDesc(Collection<T> sortList)	Create an indirected sort field.
@NotNull SortField<Integer>	sortDesc(T... sortList)	Create an indirected sort field.
@NotNull Field<BigDecimal>	sqrt()	Deprecated. - 3.11 - [#7538] - Use DSL.sqrt(Field) instead.
@NotNull Condition	startsWith(Field<T> value)	Convenience method for like(String, char) including proper adding of wildcards and escaping.
@NotNull Condition	startsWith(T value)	Convenience method for like(String, char) including proper adding of wildcards and escaping.
@NotNull Condition	startsWithIgnoreCase(Field<T> value)	Convenience method for like(String, char) including proper adding of wildcards and escaping.
@NotNull Condition	startsWithIgnoreCase(T value)	Convenience method for like(String, char) including proper adding of wildcards and escaping.
@NotNull Field<BigDecimal>	stddevPop()	Deprecated. - 3.11 - [#7538] - Use DSL.stddevPop(Field) instead.
@NotNull WindowPartitionByStep<BigDecimal>	stddevPopOver()	Deprecated. - 3.11 - [#7538] - Use DSL.stddevPop(Field) instead.
@NotNull Field<BigDecimal>	stddevSamp()	Deprecated. - 3.11 - [#7538] - Use DSL.stddevSamp(Field) instead.
@NotNull WindowPartitionByStep<BigDecimal>	stddevSampOver()	Deprecated. - 3.11 - [#7538] - Use DSL.stddevSamp(Field) instead.
@NotNull Field<T>	sub(Number value)	An arithmetic expression subtracting value from this.
@NotNull Field<T>	sub(Field<?> value)	An arithmetic expression subtracting value from this.
@NotNull Field<String>	substring(int startingPosition)	Deprecated. - 3.13 - [#9407] - Use DSL.substring(Field, int) instead.
@NotNull Field<String>	substring(int startingPosition, int length)	Deprecated. - 3.13 - [#9407] - Use DSL.substring(Field, int, int) instead.
@NotNull Field<String>	substring(Field<? extends Number> startingPosition)	Deprecated. - 3.13 - [#9407] - Use DSL.substring(Field, Field) instead.
@NotNull Field<String>	substring(Field<? extends Number> startingPosition, Field<? extends Number> length)	Deprecated. - 3.13 - [#9407] - Use DSL.substring(Field, Field, Field) instead.
@NotNull Field<T>	subtract(Number value)	An alias for sub(Number).
@NotNull Field<T>	subtract(Field<?> value)	An alias for sub(Field).
@NotNull Field<BigDecimal>	sum()	Deprecated. - 3.11 - [#7538] - Use DSL.sum(Field) instead.
@NotNull WindowPartitionByStep<BigDecimal>	sumOver()	Deprecated. - 3.11 - [#7538] - Use DSL.sum(Field) instead.
@NotNull Field<BigDecimal>	tan()	Deprecated. - 3.11 - [#7538] - Use DSL.tan(Field) instead.
@NotNull Field<BigDecimal>	tanh()	Deprecated. - 3.11 - [#7538] - Use DSL.tanh(Field) instead.
@NotNull Field<T>	times(Number value)	An alias for mul(Number).
@NotNull Field<T>	times(Field<? extends Number> value)	An alias for mul(Field).
@NotNull Field<String>	trim()	Deprecated. - 3.13 - [#9407] - Use DSL.trim(Field) instead.
@NotNull Field<T>	unaryMinus()	Negate this field to get its negative value.
@NotNull Field<T>	unaryPlus()	Get this field as its positive value (no effect on SQL).
@NotNull Field<String>	upper()	Deprecated. - 3.13 - [#9407] - Use DSL.upper(Field) instead.
@NotNull Field<BigDecimal>	varPop()	Deprecated. - 3.11 - [#7538] - Use DSL.varPop(Field) instead.
@NotNull WindowPartitionByStep<BigDecimal>	varPopOver()	Deprecated. - 3.11 - [#7538] - Use DSL.varPop(Field) instead.
@NotNull Field<BigDecimal>	varSamp()	Deprecated. - 3.11 - [#7538] - Use DSL.varSamp(Field) instead.
@NotNull WindowPartitionByStep<BigDecimal>	varSampOver()	Deprecated. - 3.11 - [#7538] - Use DSL.varSamp(Field) instead.

Methods inherited from interface org.jooq.Named

getCommentPart, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart

hashCode, toString

Methods inherited from interface org.jooq.Typed

getBinding, getConverter, getDataType, getDataType, getType

Method Detail

getName

@NotNull
@NotNull String 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

Specified by:

getName in interface Named

getComment

@NotNull
@NotNull String 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, never null.

Specified by:

getComment in interface Named

as

@NotNull
@Support
@NotNull Field<T> as(String alias)

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!

Parameters:

alias - The alias name

Returns:

The field alias

as

@NotNull
@Support
@NotNull Field<T> as(Name alias)

Create an alias for this field.

Note that the case-sensitivity of the returned field depends on Settings.getRenderQuotedNames() and the Name. By default, field aliases are quoted, and thus case-sensitive in many SQL dialects - use DSL.unquotedName(String...) for case-insensitive aliases.

If the argument Name.getName() is qualified, then the Name.last() part will be used.

Parameters:

alias - The alias name

Returns:

The field alias

as

@NotNull
@Support
@NotNull Field<T> as(Field<?> otherField)

Create an alias for this field based on another field's name.

Parameters:

otherField - The other field whose name this field is aliased with.

Returns:

The field alias.

as

@Deprecated
@NotNull
@Support
@NotNull Field<T> as(Function<? super Field<T>,? extends String> aliasFunction)

Deprecated.

- 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 as(String), except that field aliases are provided by a function. This is useful, for instance, to prefix all columns with a common prefix (on Table.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

boolean equals(Object other)

Check whether this QueryPart can be considered equal to another QueryPart.

In general, QueryPart equality is defined in terms of QueryPart.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, as QueryPart.toString() is an expensive operation, if called many times.

Watch out! This is Object.equals(Object), not a jOOQ DSL feature!

Specified by:

equals in interface QueryPart

Overrides:

equals in class Object

Parameters:

other - The other QueryPart

Returns:

Whether the two query parts are equal

cast

@NotNull
@Support
<Z> @NotNull Field<Z> cast(Field<Z> field)

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

@NotNull
@Support
<Z> @NotNull Field<Z> cast(DataType<Z> type)

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

@NotNull
@Support
<Z> @NotNull Field<Z> cast(Class<Z> type)

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. Use cast(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

@NotNull
@Support
<Z> @NotNull Field<Z> coerce(Field<Z> field)

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

@NotNull
@Support
<Z> @NotNull Field<Z> coerce(DataType<Z> type)

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

@NotNull
@Support
<Z> @NotNull Field<Z> coerce(Class<Z> type)

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

@NotNull
@Support
@NotNull SortField<T> asc()

Create an ascending sort field from this field.

This is the same as calling sort(SortOrder) with SortOrder.ASC

Returns:

This field as an ascending sort field

desc

@NotNull
@Support
@NotNull SortField<T> desc()

Create a descending sort field from this field.

This is the same as calling sort(SortOrder) with SortOrder.DESC

Returns:

This field as a descending sort field

sortDefault

@NotNull
@Support
@NotNull SortField<T> sortDefault()

Create a default sorted (implicit ASC) from this field.

This is the same as calling sort(SortOrder) with SortOrder.DEFAULT

Returns:

This field as a default sorted sort field

sort

@NotNull
@Support
@NotNull SortField<T> sort(SortOrder order)

Create an ascending/descending sort field from this field.

Parameters:

order - The sort order

Returns:

This field as an ascending/descending sort field.

sortAsc

@NotNull
@Support
@NotNull SortField<Integer> sortAsc(Collection<T> sortList)

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() or SortField.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

@NotNull
@Support
@NotNull SortField<Integer> sortAsc(T... sortList)

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() or SortField.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

@NotNull
@Support
@NotNull SortField<Integer> sortDesc(Collection<T> sortList)

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() or SortField.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

@NotNull
@Support
@NotNull SortField<Integer> sortDesc(T... sortList)

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() or SortField.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

@NotNull
@Support
<Z> @NotNull SortField<Z> sort(Map<T,Z> sortMap)

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() or SortField.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

@NotNull
@Support
@NotNull Field<T> neg()

Negate this field to get its negative value.

This renders the same on all dialects:

-[this]

unaryMinus

@NotNull
@Support
@NotNull Field<T> 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

@NotNull
@Support
@NotNull Field<T> unaryPlus()

Get this field as its positive value (no effect on SQL).

This can be recognised by the Kotlin language for operator overloading.

add

@NotNull
@Support
@NotNull Field<T> add(Number value)

An arithmetic expression adding this to value.

See Also:

add(Field)

add

@NotNull
@Support
@NotNull Field<T> add(Field<?> value)

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

@NotNull
@Support
@NotNull Field<T> plus(Number value)

An alias for add(Number).

See Also:

add(Number)

plus

@NotNull
@Support
@NotNull Field<T> plus(Field<?> value)

An alias for add(Field).

See Also:

add(Field)

sub

@NotNull
@Support
@NotNull Field<T> sub(Number value)

An arithmetic expression subtracting value from this.

See Also:

sub(Field)

sub

@NotNull
@Support
@NotNull Field<T> sub(Field<?> value)

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:

• DSL.dateDiff(Field, Field)
• DSL.timestampDiff(Field, Field)

subtract

@NotNull
@Support
@NotNull Field<T> subtract(Number value)

An alias for sub(Number).

See Also:

sub(Number)

subtract

@NotNull
@Support
@NotNull Field<T> subtract(Field<?> value)

An alias for sub(Field).

See Also:

sub(Field)

minus

@NotNull
@Support
@NotNull Field<T> minus(Number value)

An alias for sub(Number).

See Also:

sub(Number)

minus

@NotNull
@Support
@NotNull Field<T> minus(Field<?> value)

An alias for sub(Field).

See Also:

sub(Field)

mul

@NotNull
@Support
@NotNull Field<T> mul(Number value)

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 an INTERVAL field (see Interval)

mul

@NotNull
@Support
@NotNull Field<T> mul(Field<? extends Number> value)

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 an INTERVAL field (see Interval)

multiply

@NotNull
@Support
@NotNull Field<T> multiply(Number value)

An alias for mul(Number).

See Also:

mul(Number)

multiply

@NotNull
@Support
@NotNull Field<T> multiply(Field<? extends Number> value)

An alias for mul(Field).

See Also:

mul(Field)

times

@NotNull
@Support
@NotNull Field<T> times(Number value)

An alias for mul(Number).

See Also:

mul(Number)

times

@NotNull
@Support
@NotNull Field<T> times(Field<? extends Number> value)

An alias for mul(Field).

See Also:

mul(Field)

div

@NotNull
@Support
@NotNull Field<T> div(Number value)

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 an INTERVAL field (see Interval)

div

@NotNull
@Support
@NotNull Field<T> div(Field<? extends Number> value)

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 an INTERVAL field (see Interval)

divide

@NotNull
@Support
@NotNull Field<T> divide(Number value)

An alias for div(Number).

See Also:

div(Number)

divide

@NotNull
@Support
@NotNull Field<T> divide(Field<? extends Number> value)

An alias for div(Field).

See Also:

div(Field)

mod

@NotNull
@Support
@NotNull Field<T> mod(Number value)

An arithmetic expression getting the modulo of this divided by value.

This renders the modulo operation where available:

[this] % [value]

... or the modulo function elsewhere:

mod([this], [value])

mod

@NotNull
@Support
@NotNull Field<T> mod(Field<? extends Number> value)

An arithmetic expression getting the modulo of this divided by value.

This renders the modulo operation where available:

[this] % [value]

... or the modulo function elsewhere:

mod([this], [value])

modulo

@NotNull
@Support
@NotNull Field<T> modulo(Number value)

An alias for mod(Number).

See Also:

mod(Number)

modulo

@NotNull
@Support
@NotNull Field<T> modulo(Field<? extends Number> value)

An alias for mod(Field).

See Also:

mod(Field)

rem

@NotNull
@Support
@NotNull Field<T> rem(Number value)

An alias for mod(Number).

See Also:

mod(Number)

rem

@NotNull
@Support
@NotNull Field<T> rem(Field<? extends Number> value)

An alias for mod(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 of exponent.

This renders the power operation where available:

[this] ^ [value]

... or the power function elsewhere:

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 of exponent.

This renders the power operation where available:

[this] ^ [value]

... or the power function elsewhere:

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 for power(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 for power(Field).

See Also:

power(Field)

bitNot

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,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

@NotNull
@Support(POSTGRES)
@NotNull Condition isDocument()

Create a condition to check if this field contains XML data.

isNotDocument

@NotNull
@Support(POSTGRES)
@NotNull Condition isNotDocument()

Create a condition to check if this field does not contain XML data.

isJson

@NotNull
@Support({MYSQL_5_7,ORACLE12C,SQLSERVER2016})
@NotNull Condition isJson()

Create a condition to check if this field contains JSON data.

isNotJson

@NotNull
@Support({MYSQL_5_7,ORACLE12C,SQLSERVER2016})
@NotNull Condition isNotJson()

Create a condition to check if this field does not contain JSON data.

isNull

@NotNull
@Support
@NotNull Condition isNull()

Create a condition to check this field against null.

SQL: this is null

isNotNull

@NotNull
@Support
@NotNull Condition isNotNull()

Create a condition to check this field against null.

SQL: this is not null

isDistinctFrom

@NotNull
@Support
@NotNull Condition isDistinctFrom(T value)

Create a condition to check if this field is DISTINCT from another value.

In SQLDialect.MYSQL and SQLDialect.MARIADB, this can be emulated through

not([this] <=> [value])

In SQLDialect.SQLITE, this can be emulated through

[this] IS NOT [value]

In databases that support INTERSECT (see Select.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:

 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
 

SQL: this is distinct from value

isDistinctFrom

@NotNull
@Support
@NotNull Condition isDistinctFrom(Field<T> field)

Create a condition to check if this field is DISTINCT from another field.

In SQLDialect.MYSQL and SQLDialect.MARIADB, this can be emulated through

not([this] <=> [value])

In SQLDialect.SQLITE, this can be emulated through

[this] IS NOT [value]

In databases that support INTERSECT (see Select.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:

 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
 

SQL: this is distinct from field

isDistinctFrom

@NotNull
@Support
@NotNull Condition isDistinctFrom(Select<? extends Record1<T>> select)

Create a condition to check if this field is DISTINCT from another field.

In SQLDialect.MYSQL and SQLDialect.MARIADB, this can be emulated through

not([this] <=> [value])

In SQLDialect.SQLITE, this can be emulated through

[this] IS NOT [value]

In databases that support INTERSECT (see Select.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:

 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
 

SQL: this is distinct from field

isNotDistinctFrom

@NotNull
@Support
@NotNull Condition isNotDistinctFrom(T value)

Create a condition to check if this field is NOT DISTINCT from another value.

In SQLDialect.MYSQL and SQLDialect.MARIADB, this can be emulated through

[this] <=> [value]

In SQLDialect.SQLITE, this can be emulated through

[this] IS [value]

In databases that support INTERSECT (see Select.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:

 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
 

SQL: this is not distinct from value

isNotDistinctFrom

@NotNull
@Support
@NotNull Condition isNotDistinctFrom(Field<T> field)

Create a condition to check if this field is NOT DISTINCT from another field.

In SQLDialect.MYSQL and SQLDialect.MARIADB, this can be emulated through

[this] <=> [value]

In SQLDialect.SQLITE, this can be emulated through

[this] IS [value]

In databases that support INTERSECT (see Select.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:

 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
 

SQL: this is not distinct from field

isNotDistinctFrom

@NotNull
@Support
@NotNull Condition isNotDistinctFrom(Select<? extends Record1<T>> select)

Create a condition to check if this field is NOT DISTINCT from another field.

In SQLDialect.MYSQL and SQLDialect.MARIADB, this can be emulated through

[this] <=> [value]

In SQLDialect.SQLITE, this can be emulated through

[this] IS [value]

In databases that support INTERSECT (see Select.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:

 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
 

SQL: 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:

SQL dialect	SQL syntax	Pattern syntax	Documentation
SQLDialect.ASE	-	-	-
SQLDialect.DB2	-	-	-
SQLDialect.DERBY	-	-	-
SQLDialect.H2	[search] REGEXP [pattern]	Java	http ://www.h2database.com/html/grammar.html#condition_right_hand_side
SQLDialect.HSQLDB	REGEXP_MATCHES([search], [pattern])	Java	http://hsqldb.org/doc/guide/builtinfunctions-chapt.html#N13577
SQLDialect.INGRES	-	-	-
SQLDialect.MYSQL	[search] REGEXP [pattern]	POSIX	http://dev .mysql.com/doc/refman/5.6/en/regexp.html
SQLDialect.ORACLE	REGEXP_LIKE([search], [pattern])	POSIX	http://docs.oracle.com/cd/E14072_01/server.112/e10592/conditions007.htm# sthref1994
SQLDialect.POSTGRES	[search] ~ [pattern]	POSIX	http://www.postgresql.org/docs/9.1/static/functions-matching.html# FUNCTIONS-POSIX-REGEXP
SQLDialect.SQLITE	[search] REGEXP [pattern]	? This module has to be loaded explicitly	http://www.sqlite.org/ lang_expr.html
SQLDialect.SQLSERVER	-	-	-
SQLDialect.SYBASE	[search] REGEXP [pattern]	Perl	http://infocenter.sybase.com/help/topic/com.sybase.help.sqlanywhere.12.0 .1/dbreference/like-regexp-similarto.html

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

@NotNull
@Support({COCKROACHDB,FIREBIRD,POSTGRES})
@NotNull LikeEscapeStep similarTo(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(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

@NotNull
@Support
@NotNull LikeEscapeStep like(Field<String> value)

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,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

@NotNull
@Support
@NotNull LikeEscapeStep like(String value)

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,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

@NotNull
@Support
@NotNull LikeEscapeStep like(QuantifiedSelect<Record1<String>> query)

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%').

See Also:

DSL.all(Field), DSL.all(Field...), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Field...), DSL.any(Select), DSL.any(Object...), LikeEscapeStep.escape(char)

likeIgnoreCase

@NotNull
@Support
@NotNull LikeEscapeStep likeIgnoreCase(Field<String> field)

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

This translates to this ilike field in SQLDialect.POSTGRES, or to lower(this) like lower(field) in all other dialects.

likeIgnoreCase

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,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 in SQLDialect.POSTGRES, or to lower(this) like lower(field) in all other dialects.

See Also:

LikeEscapeStep.escape(char)

likeIgnoreCase

@NotNull
@Support
@NotNull LikeEscapeStep likeIgnoreCase(String value)

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

This translates to this ilike value in SQLDialect.POSTGRES, or to lower(this) like lower(value) in all other dialects.

likeIgnoreCase

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,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 in SQLDialect.POSTGRES, or to lower(this) like lower(value) in all other dialects.

See Also:

LikeEscapeStep.escape(char)

notLike

@NotNull
@Support
@NotNull LikeEscapeStep notLike(Field<String> field)

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,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

@NotNull
@Support
@NotNull LikeEscapeStep notLike(String value)

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,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

@NotNull
@Support
@NotNull LikeEscapeStep notLike(QuantifiedSelect<Record1<String>> query)

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%').

See Also:

DSL.all(Field), DSL.all(Field...), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Field...), DSL.any(Select), DSL.any(Object...), LikeEscapeStep.escape(char)

notLikeIgnoreCase

@NotNull
@Support
@NotNull LikeEscapeStep notLikeIgnoreCase(Field<String> field)

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

This translates to this not ilike field in SQLDialect.POSTGRES, or to lower(this) not like lower(field) in all other dialects.

notLikeIgnoreCase

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,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 in SQLDialect.POSTGRES, or to lower(this) not like lower(field) in all other dialects.

See Also:

LikeEscapeStep.escape(char)

notLikeIgnoreCase

@NotNull
@Support
@NotNull LikeEscapeStep notLikeIgnoreCase(String value)

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

This translates to this not ilike value in SQLDialect.POSTGRES, or to lower(this) not like lower(value) in all other dialects.

notLikeIgnoreCase

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,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 in SQLDialect.POSTGRES, or to lower(this) not like lower(value) in all other dialects.

See Also:

LikeEscapeStep.escape(char)

contains

@NotNull
@Support
@NotNull Condition contains(T value)

Convenience method for like(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 to OracleDSL.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,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA})
@NotNull Condition contains(Field<T> value)

Convenience method for like(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 to OracleDSL.contains(Field, String) instead.

See Also:

DSL.escape(Field, char), like(Field, char)

notContains

@NotNull
@Support
@NotNull Condition notContains(T value)

Inverse of contains(Object).

notContains

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA})
@NotNull Condition notContains(Field<T> value)

Inverse of contains(Field).

containsIgnoreCase

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA})
@NotNull Condition containsIgnoreCase(T value)

Convenience method for likeIgnoreCase(String, char) including proper adding of wildcards and escaping.

This translates to this ilike ('%' || escape(value, '\') || '%') escape '\' in SQLDialect.POSTGRES, or to lower(this) not like lower(('%' || escape(value, '\') || '%') escape '\') in all other dialects.

See Also:

DSL.escape(Field, char), likeIgnoreCase(String, char), contains(Object)

containsIgnoreCase

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA})
@NotNull Condition containsIgnoreCase(Field<T> value)

Convenience method for likeIgnoreCase(String, char) including proper adding of wildcards and escaping.

This translates to this ilike ('%' || escape(value, '\') || '%') escape '\' in SQLDialect.POSTGRES, or to lower(this) like lower(('%' || escape(value, '\') || '%') escape '\') in all other dialects.

See Also:

DSL.escape(Field, char), likeIgnoreCase(Field, char), contains(Field)

notContainsIgnoreCase

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA})
@NotNull Condition notContainsIgnoreCase(T value)

Inverse of containsIgnoreCase(Object)

notContainsIgnoreCase

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA})
@NotNull Condition notContainsIgnoreCase(Field<T> value)

Inverse of containsIgnoreCase(Field)

startsWith

@NotNull
@Support
@NotNull Condition startsWith(T value)

Convenience method for like(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,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA})
@NotNull Condition startsWith(Field<T> value)

Convenience method for like(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

@NotNull
@Support
@NotNull Condition startsWithIgnoreCase(T value)

Convenience method for like(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,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA})
@NotNull Condition startsWithIgnoreCase(Field<T> value)

Convenience method for like(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

@NotNull
@Support
@NotNull Condition endsWith(T value)

Convenience method for like(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,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA})
@NotNull Condition endsWith(Field<T> value)

Convenience method for like(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

@NotNull
@Support
@NotNull Condition endsWithIgnoreCase(T value)

Convenience method for like(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,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA})
@NotNull Condition endsWithIgnoreCase(Field<T> value)

Convenience method for like(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

@NotNull
@Support
@NotNull Condition in(Collection<?> values)

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 use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• IN predicates on temporary tables
• IN predicates on unnested array bind variables

in

@NotNull
@Support
@NotNull Condition in(Result<? extends Record1<T>> result)

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 use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• IN predicates on temporary tables
• IN predicates on unnested array bind variables

in

@NotNull
@Support
@NotNull Condition in(T... values)

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 use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• IN predicates on temporary tables
• IN predicates on unnested array bind variables

in

@NotNull
@Support
@NotNull Condition in(Field<?>... values)

Create a condition to check this field against several values.

SQL: this in (values...)

in

@NotNull
@Support
@NotNull Condition in(Select<? extends Record1<T>> query)

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

@NotNull
@Support
@NotNull Condition notIn(Collection<?> values)

Create a condition to check this field against several values.

Note that if any of the passed values is NULL, then the condition will be NULL (or false, 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 use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• NOT IN predicates on temporary tables
• NOT IN predicates on unnested array bind variables

notIn

@NotNull
@Support
@NotNull Condition notIn(Result<? extends Record1<T>> result)

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 be NULL (or false, 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 use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• NOT IN predicates on temporary tables
• NOT IN predicates on unnested array bind variables

notIn

@NotNull
@Support
@NotNull Condition notIn(T... values)

Create a condition to check this field against several values.

Note that if any of the passed values is NULL, then the condition will be NULL (or false, 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 use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• NOT IN predicates on temporary tables
• NOT IN predicates on unnested array bind variables

notIn

@NotNull
@Support
@NotNull Condition notIn(Field<?>... values)

Create a condition to check this field against several values.

Note that if any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well. This is standard SQL behaviour.

SQL: this not in (values...)

notIn

@NotNull
@Support
@NotNull Condition notIn(Select<? extends Record1<T>> query)

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 be NULL (or false, depending on the dialect) as well. This is standard SQL behaviour.

SQL: this not in (select...)

between

@NotNull
@Support
@NotNull Condition between(T minValue,
                           T maxValue)

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

@NotNull
@Support
@NotNull Condition between(Field<T> minValue,
                           Field<T> maxValue)

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

@NotNull
@Support
@NotNull Condition betweenSymmetric(T minValue,
                                    T maxValue)

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

@NotNull
@Support
@NotNull Condition betweenSymmetric(Field<T> minValue,
                                    Field<T> maxValue)

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

@NotNull
@Support
@NotNull Condition notBetween(T minValue,
                              T maxValue)

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

@NotNull
@Support
@NotNull Condition notBetween(Field<T> minValue,
                              Field<T> maxValue)

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

@NotNull
@Support
@NotNull Condition notBetweenSymmetric(T minValue,
                                       T maxValue)

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

@NotNull
@Support
@NotNull Condition notBetweenSymmetric(Field<T> minValue,
                                       Field<T> maxValue)

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

@NotNull
@Support
@NotNull BetweenAndStep<T> between(T minValue)

Create a condition to check this field against some bounds.

SQL: this between minValue and maxValue

between

@NotNull
@Support
@NotNull BetweenAndStep<T> between(Field<T> minValue)

Create a condition to check this field against some bounds.

SQL: this between minValue and maxValue

betweenSymmetric

@NotNull
@Support
@NotNull BetweenAndStep<T> betweenSymmetric(T minValue)

Create a condition to check this field against some bounds.

SQL: this between symmetric minValue and maxValue

betweenSymmetric

@NotNull
@Support
@NotNull BetweenAndStep<T> betweenSymmetric(Field<T> minValue)

Create a condition to check this field against some bounds.

SQL: this between symmetric minValue and maxValue

notBetween

@NotNull
@Support
@NotNull BetweenAndStep<T> notBetween(T minValue)

Create a condition to check this field against some bounds.

SQL: this not between minValue and maxValue

notBetween

@NotNull
@Support
@NotNull BetweenAndStep<T> notBetween(Field<T> minValue)

Create a condition to check this field against some bounds.

SQL: this not between minValue and maxValue

notBetweenSymmetric

@NotNull
@Support
@NotNull BetweenAndStep<T> notBetweenSymmetric(T minValue)

Create a condition to check this field against some bounds.

SQL: this not between symmetric minValue and maxValue

notBetweenSymmetric

@NotNull
@Support
@NotNull BetweenAndStep<T> notBetweenSymmetric(Field<T> minValue)

Create a condition to check this field against some bounds.

SQL: this not between symmetric minValue and maxValue

compare

@NotNull
@Support
@NotNull Condition compare(Comparator comparator,
                           T value)

Compare this field with a value using a dynamic comparator.

Parameters:

comparator - The comparator to use for comparing this field with a value

value - The value to compare this field with

Returns:

A comparison predicate

compare

@NotNull
@Support
@NotNull Condition compare(Comparator comparator,
                           Field<T> field)

Compare this field with another field using a dynamic comparator.

Parameters:

comparator - The comparator to use for comparing this field with another field

field - 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 subselect

query - 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 subselect

query - The quantified subselect to compare this field with

Returns:

A comparison predicate

equal

@NotNull
@Support
@NotNull Condition equal(T value)

this = value.

equal

@NotNull
@Support
@NotNull Condition equal(Field<T> field)

this = field.

equal

@NotNull
@Support
@NotNull Condition equal(Select<? extends Record1<T>> query)

this = (Select<?> ...).

equal

@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 equal(QuantifiedSelect<? extends Record1<T>> query)

this = [quantifier] (Select<?> ...).

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

eq

@NotNull
@Support
@NotNull Condition eq(T value)

this = value.

See Also:

equal(Object)

eq

@NotNull
@Support
@NotNull Condition eq(Field<T> field)

this = field.

See Also:

equal(Field)

eq

@NotNull
@Support
@NotNull Condition eq(Select<? extends Record1<T>> query)

this = (Select<?> ...).

See Also:

equal(Select)

eq

@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 eq(QuantifiedSelect<? extends Record1<T>> query)

this = [quantifier] (Select<?> ...).

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

notEqual

@NotNull
@Support
@NotNull Condition notEqual(T value)

this != value.

notEqual

@NotNull
@Support
@NotNull Condition notEqual(Field<T> field)

this != field.

notEqual

@NotNull
@Support
@NotNull Condition notEqual(Select<? extends Record1<T>> query)

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<?> ...).

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

ne

@NotNull
@Support
@NotNull Condition ne(T value)

this != value.

See Also:

notEqual(Object)

ne

@NotNull
@Support
@NotNull Condition ne(Field<T> field)

this != field.

See Also:

notEqual(Field)

ne

@NotNull
@Support
@NotNull Condition ne(Select<? extends Record1<T>> query)

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<?> ...).

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

lessThan

@NotNull
@Support
@NotNull Condition lessThan(T value)

this < value.

lessThan

@NotNull
@Support
@NotNull Condition lessThan(Field<T> field)

this < field.

lessThan

@NotNull
@Support
@NotNull Condition lessThan(Select<? extends Record1<T>> query)

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<?> ...).

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

lt

@NotNull
@Support
@NotNull Condition lt(T value)

this < value.

See Also:

lessThan(Object)

lt

@NotNull
@Support
@NotNull Condition lt(Field<T> field)

this < field.

See Also:

lessThan(Field)

lt

@NotNull
@Support
@NotNull Condition lt(Select<? extends Record1<T>> query)

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<?> ...).

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

lessOrEqual

@NotNull
@Support
@NotNull Condition lessOrEqual(T value)

this <= value.

lessOrEqual

@NotNull
@Support
@NotNull Condition lessOrEqual(Field<T> field)

this <= field.

lessOrEqual

@NotNull
@Support
@NotNull Condition lessOrEqual(Select<? extends Record1<T>> query)

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<?> ...).

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

le

@NotNull
@Support
@NotNull Condition le(T value)

this <= value.

See Also:

lessOrEqual(Object)

le

@NotNull
@Support
@NotNull Condition le(Field<T> field)

this <= field.

See Also:

lessOrEqual(Field)

le

@NotNull
@Support
@NotNull Condition le(Select<? extends Record1<T>> query)

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<?> ...).

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

greaterThan

@NotNull
@Support
@NotNull Condition greaterThan(T value)

this > value.

greaterThan

@NotNull
@Support
@NotNull Condition greaterThan(Field<T> field)

this > field.

greaterThan

@NotNull
@Support
@NotNull Condition greaterThan(Select<? extends Record1<T>> query)

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<?> ...).

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

gt

@NotNull
@Support
@NotNull Condition gt(T value)

this > value.

See Also:

greaterThan(Object)

gt

@NotNull
@Support
@NotNull Condition gt(Field<T> field)

this > field.

See Also:

greaterThan(Field)

gt

@NotNull
@Support
@NotNull Condition gt(Select<? extends Record1<T>> query)

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<?> ...).

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

greaterOrEqual

@NotNull
@Support
@NotNull Condition greaterOrEqual(T value)

this >= value.

greaterOrEqual

@NotNull
@Support
@NotNull Condition greaterOrEqual(Field<T> field)

this >= field.

greaterOrEqual

@NotNull
@Support
@NotNull Condition greaterOrEqual(Select<? extends Record1<T>> query)

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<?> ...).

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

ge

@NotNull
@Support
@NotNull Condition ge(T value)

this >= value.

See Also:

greaterOrEqual(Object)

ge

@NotNull
@Support
@NotNull Condition ge(Field<T> field)

this >= field.

See Also:

greaterOrEqual(Field)

ge

@NotNull
@Support
@NotNull Condition ge(Select<? extends Record1<T>> query)

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<?> ...).

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

isTrue

@NotNull
@Support
@NotNull Condition isTrue()

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

SQL: lcase(this) in ("1", "y", "yes", "true", "on", "enabled")

isFalse

@NotNull
@Support
@NotNull Condition isFalse()

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

SQL: lcase(this) in ("0", "n", "no", "false", "off", "disabled")

equalIgnoreCase

@NotNull
@Support
@NotNull Condition equalIgnoreCase(String value)

lower(this) = lower(value).

equalIgnoreCase

@NotNull
@Support
@NotNull Condition equalIgnoreCase(Field<String> value)

lower(this) = lower(value).

notEqualIgnoreCase

@NotNull
@Support
@NotNull Condition notEqualIgnoreCase(String value)

lower(this) != lower(value).

notEqualIgnoreCase

@NotNull
@Support
@NotNull Condition notEqualIgnoreCase(Field<String> value)

lower(this) != lower(value).

sign

@Deprecated
@NotNull
@Support
@NotNull Field<Integer> sign()

Deprecated.

- 3.11 - [#7538] - Use DSL.sign(Field) instead.

See Also:

DSL.sign(Field)

abs

@Deprecated
@NotNull
@Support
@NotNull Field<T> abs()

Deprecated.

- 3.11 - [#7538] - Use DSL.abs(Field) instead.

See Also:

DSL.abs(Field)

round

@Deprecated
@NotNull
@Support
@NotNull Field<T> round()

Deprecated.

- 3.11 - [#7538] - Use DSL.round(Field) instead.

See Also:

DSL.round(Field)

round

@Deprecated
@NotNull
@Support
@NotNull Field<T> round(int decimals)

Deprecated.

- 3.11 - [#7538] - Use DSL.round(Field, int) instead.

See Also:

DSL.round(Field, int)

floor

@Deprecated
@NotNull
@Support
@NotNull Field<T> floor()

Deprecated.

- 3.11 - [#7538] - Use DSL.floor(Field) instead.

See Also:

DSL.floor(Field)

ceil

@Deprecated
@NotNull
@Support
@NotNull Field<T> ceil()

Deprecated.

- 3.11 - [#7538] - Use DSL.ceil(Field) instead.

See Also:

DSL.ceil(Field)

sqrt

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.sqrt(Field) instead.

See Also:

DSL.sqrt(Field)

exp

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.exp(Field) instead.

See Also:

DSL.exp(Field)

ln

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.ln(Field) instead.

See Also:

DSL.ln(Field)

log

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.log(Field, int) instead.

See Also:

DSL.log(Field, int)

acos

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.acos(Field) instead.

See Also:

DSL.acos(Field)

asin

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.asin(Field) instead.

See Also:

DSL.asin(Field)

atan

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.atan(Field) instead.

See Also:

DSL.atan(Field)

atan2

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.atan2(Field, Number) instead.

See Also:

DSL.atan2(Field, Number)

atan2

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.atan2(Field, Field) instead.

See Also:

DSL.atan2(Field, Field)

cos

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.cos(Field) instead.

See Also:

DSL.cos(Field)

sin

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.sin(Field) instead.

See Also:

DSL.sin(Field)

tan

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.tan(Field) instead.

See Also:

DSL.tan(Field)

cot

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.cot(Field) instead.

See Also:

DSL.cot(Field)

sinh

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.sinh(Field) instead.

See Also:

DSL.sinh(Field)

cosh

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.cosh(Field) instead.

See Also:

DSL.cosh(Field)

tanh

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.tanh(Field) instead.

See Also:

DSL.tanh(Field)

coth

@Deprecated
@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.

- 3.11 - [#7538] - Use DSL.coth(Field) instead.

See Also:

DSL.coth(Field)

deg

@Deprecated
@NotNull
@Support
@NotNull Field<BigDecimal> deg()

Deprecated.

- 3.11 - [#7538] - Use DSL.deg(Field) instead.

See Also:

DSL.deg(Field)

rad

@Deprecated
@NotNull
@Support
@NotNull Field<BigDecimal> rad()

Deprecated.

- 3.11 - [#7538] - Use DSL.rad(Field) instead.

See Also:

DSL.rad(Field)

count

@Deprecated
@NotNull
@Support
@NotNull Field<Integer> count()

Deprecated.

- 3.11 - [#7538] - Use DSL.count(Field) instead.

See Also:

DSL.count(Field)

countDistinct

@Deprecated
@NotNull
@Support
@NotNull Field<Integer> countDistinct()

Deprecated.

- 3.11 - [#7538] - Use DSL.countDistinct(Field) instead.

See Also:

DSL.countDistinct(Field)

max

@Deprecated
@NotNull
@Support
@NotNull Field<T> max()

Deprecated.

- 3.11 - [#7538] - Use DSL.max(Field) instead.

See Also:

DSL.max(Field)

min

@Deprecated
@NotNull
@Support
@NotNull Field<T> min()

Deprecated.

- 3.11 - [#7538] - Use DSL.min(Field) instead.

See Also:

DSL.min(Field)

sum

@Deprecated
@NotNull
@Support
@NotNull Field<BigDecimal> sum()

Deprecated.

- 3.11 - [#7538] - Use DSL.sum(Field) instead.

See Also:

DSL.sum(Field)

avg

@Deprecated
@NotNull
@Support
@NotNull Field<BigDecimal> avg()

Deprecated.

- 3.11 - [#7538] - Use DSL.avg(Field) instead.

See Also:

DSL.avg(Field)

median

@Deprecated
@NotNull
@Support({CUBRID,HSQLDB,ORACLE,SYBASE,TERADATA})
@NotNull Field<BigDecimal> median()

Deprecated.

- 3.11 - [#7538] - Use DSL.median(Field) instead.

See Also:

DSL.median(Field)

stddevPop

@Deprecated
@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull Field<BigDecimal> stddevPop()

Deprecated.

- 3.11 - [#7538] - Use DSL.stddevPop(Field) instead.

See Also:

DSL.stddevPop(Field)

stddevSamp

@Deprecated
@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull Field<BigDecimal> stddevSamp()

Deprecated.

- 3.11 - [#7538] - Use DSL.stddevSamp(Field) instead.

See Also:

DSL.stddevSamp(Field)

varPop

@Deprecated
@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull Field<BigDecimal> varPop()

Deprecated.

- 3.11 - [#7538] - Use DSL.varPop(Field) instead.

See Also:

DSL.varPop(Field)

varSamp

@Deprecated
@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull Field<BigDecimal> varSamp()

Deprecated.

- 3.11 - [#7538] - Use DSL.varSamp(Field) instead.

See Also:

DSL.varSamp(Field)

countOver

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull WindowPartitionByStep<Integer> countOver()

Deprecated.

- 3.11 - [#7538] - Use DSL.count(Field) instead.

See Also:

DSL.count(Field), WindowOverStep.over()

maxOver

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull WindowPartitionByStep<T> maxOver()

Deprecated.

- 3.11 - [#7538] - Use DSL.max(Field) instead.

See Also:

DSL.max(Field), WindowOverStep.over()

minOver

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull WindowPartitionByStep<T> minOver()

Deprecated.

- 3.11 - [#7538] - Use DSL.min(Field) instead.

See Also:

DSL.min(Field), WindowOverStep.over()

sumOver

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull WindowPartitionByStep<BigDecimal> sumOver()

Deprecated.

- 3.11 - [#7538] - Use DSL.sum(Field) instead.

See Also:

DSL.sum(Field), WindowOverStep.over()

avgOver

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull WindowPartitionByStep<BigDecimal> avgOver()

Deprecated.

- 3.11 - [#7538] - Use DSL.avg(Field) instead.

See Also:

DSL.avg(Field), WindowOverStep.over()

firstValue

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA})
@NotNull WindowIgnoreNullsStep<T> firstValue()

Deprecated.

- 3.11 - [#7538] - Use DSL.firstValue(Field) instead.

See Also:

DSL.firstValue(Field), WindowOverStep.over()

lastValue

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA})
@NotNull WindowIgnoreNullsStep<T> lastValue()

Deprecated.

- 3.11 - [#7538] - Use DSL.lastValue(Field) instead.

See Also:

DSL.lastValue(Field), WindowOverStep.over()

lead

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA})
@NotNull WindowIgnoreNullsStep<T> lead()

Deprecated.

- 3.11 - [#7538] - Use DSL.lead(Field) instead.

See Also:

DSL.lead(Field), WindowOverStep.over()

lead

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA})
@NotNull WindowIgnoreNullsStep<T> lead(int offset)

Deprecated.

- 3.11 - [#7538] - Use DSL.lead(Field, int) instead.

See Also:

DSL.lead(Field, int), WindowOverStep.over()

lead

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA})
@NotNull WindowIgnoreNullsStep<T> lead(int offset,
                                       T defaultValue)

Deprecated.

- 3.11 - [#7538] - Use DSL.lead(Field, int, Object) instead.

See Also:

DSL.lead(Field, int, Object), WindowOverStep.over()

lead

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA})
@NotNull WindowIgnoreNullsStep<T> lead(int offset,
                                       Field<T> defaultValue)

Deprecated.

- 3.11 - [#7538] - Use DSL.lead(Field, int, Field) instead.

See Also:

DSL.lead(Field, int, Field), WindowOverStep.over()

lag

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA})
@NotNull WindowIgnoreNullsStep<T> lag()

Deprecated.

- 3.11 - [#7538] - Use DSL.lag(Field) instead.

See Also:

DSL.lag(Field), WindowOverStep.over()

lag

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA})
@NotNull WindowIgnoreNullsStep<T> lag(int offset)

Deprecated.

- 3.11 - [#7538] - Use DSL.lag(Field, int) instead.

See Also:

DSL.lag(Field, int), WindowOverStep.over()

lag

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA})
@NotNull WindowIgnoreNullsStep<T> lag(int offset,
                                      T defaultValue)

Deprecated.

- 3.11 - [#7538] - Use DSL.lag(Field, int, Object) instead.

See Also:

DSL.lag(Field, int, Object), WindowOverStep.over()

lag

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA})
@NotNull WindowIgnoreNullsStep<T> lag(int offset,
                                      Field<T> defaultValue)

Deprecated.

- 3.11 - [#7538] - Use DSL.lag(Field, int, Field) instead.

See Also:

DSL.lag(Field, int, Field), WindowOverStep.over()

stddevPopOver

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,CUBRID,DB2,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull WindowPartitionByStep<BigDecimal> stddevPopOver()

Deprecated.

- 3.11 - [#7538] - Use DSL.stddevPop(Field) instead.

See Also:

DSL.stddevPop(Field), WindowOverStep.over()

stddevSampOver

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull WindowPartitionByStep<BigDecimal> stddevSampOver()

Deprecated.

- 3.11 - [#7538] - Use DSL.stddevSamp(Field) instead.

See Also:

DSL.stddevSamp(Field), WindowOverStep.over()

varPopOver

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,CUBRID,DB2,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull WindowPartitionByStep<BigDecimal> varPopOver()

Deprecated.

- 3.11 - [#7538] - Use DSL.varPop(Field) instead.

See Also:

DSL.varPop(Field), WindowOverStep.over()

varSampOver

@Deprecated
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull WindowPartitionByStep<BigDecimal> varSampOver()

Deprecated.

- 3.11 - [#7538] - Use DSL.varSamp(Field) instead.

See Also:

DSL.varSamp(Field), WindowOverStep.over()

upper

@Deprecated
@NotNull
@Support
@NotNull Field<String> upper()

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.upper(Field)

lower

@Deprecated
@NotNull
@Support
@NotNull Field<String> lower()

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.lower(Field)

trim

@Deprecated
@NotNull
@Support
@NotNull Field<String> trim()

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.trim(Field)

rtrim

@Deprecated
@NotNull
@Support
@NotNull Field<String> rtrim()

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.rtrim(Field)

ltrim

@Deprecated
@NotNull
@Support
@NotNull Field<String> ltrim()

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.ltrim(Field)

rpad

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.rpad(Field, Field)

rpad

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.rpad(Field, int)

rpad

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.rpad(Field, Field, Field)

rpad

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.rpad(Field, int, char)

lpad

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.lpad(Field, Field)

lpad

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.lpad(Field, int)

lpad

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.lpad(Field, Field, Field)

lpad

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.lpad(Field, int, char)

repeat

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.repeat(Field, int)

repeat

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.repeat(Field, Field)

replace

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.replace(Field, Field)

replace

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.replace(Field, String)

replace

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.replace(Field, Field, Field)

replace

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.replace(Field, String, String)

position

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.position(Field, String)

position

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.position(Field, Field)

ascii

@Deprecated
@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.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

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

@NotNull
@Support
@NotNull Field<String> concat(Field<?>... fields)

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 from DSLContext

See Also:

DSL.concat(Field...)

concat

@NotNull
@Support
@NotNull Field<String> concat(String... values)

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 from DSLContext

See Also:

DSL.concat(String...)

concat

@NotNull
@Support
@NotNull Field<String> concat(char... values)

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 from DSLContext

See Also:

DSL.concat(String...)

substring

@Deprecated
@NotNull
@Support
@NotNull Field<String> substring(int startingPosition)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.substring(Field, int)

substring

@Deprecated
@NotNull
@Support
@NotNull Field<String> substring(Field<? extends Number> startingPosition)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.substring(Field, Field)

substring

@Deprecated
@NotNull
@Support
@NotNull Field<String> substring(int startingPosition,
                                 int length)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.substring(Field, int, int)

substring

@Deprecated
@NotNull
@Support
@NotNull Field<String> substring(Field<? extends Number> startingPosition,
                                 Field<? extends Number> length)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.substring(Field, Field, Field)

length

@Deprecated
@NotNull
@Support
@NotNull Field<Integer> length()

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.length(Field)

charLength

@Deprecated
@NotNull
@Support
@NotNull Field<Integer> charLength()

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.charLength(Field)

bitLength

@Deprecated
@NotNull
@Support
@NotNull Field<Integer> bitLength()

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.bitLength(Field)

octetLength

@Deprecated
@NotNull
@Support
@NotNull Field<Integer> octetLength()

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.octetLength(Field)

extract

@Deprecated
@NotNull
@Support
@NotNull Field<Integer> extract(DatePart datePart)

Deprecated.

- 3.11 - [#7538] - Use DSL.extract(Field, DatePart) instead.

See Also:

DSL.extract(Field, DatePart)

greatest

@Deprecated
@NotNull
@Support
@NotNull Field<T> greatest(T... others)

Deprecated.

- 3.11 - [#7538] - Use DSL.greatest(Field, Field...) instead.

See Also:

DSL.greatest(Field, Field...)

greatest

@Deprecated
@NotNull
@Support
@NotNull Field<T> greatest(Field<?>... others)

Deprecated.

- 3.11 - [#7538] - Use DSL.greatest(Field, Field...) instead.

See Also:

DSL.greatest(Field, Field...)

least

@Deprecated
@NotNull
@Support
@NotNull Field<T> least(T... others)

Deprecated.

- 3.11 - [#7538] - Use DSL.least(Field, Field...) instead.

See Also:

DSL.least(Field, Field...)

least

@Deprecated
@NotNull
@Support
@NotNull Field<T> least(Field<?>... others)

Deprecated.

- 3.11 - [#7538] - Use DSL.least(Field, Field...) instead.

See Also:

DSL.least(Field, Field...)

nvl

@Deprecated
@NotNull
@Support
@NotNull Field<T> nvl(T defaultValue)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.nvl(Field, Object)

nvl

@Deprecated
@NotNull
@Support
@NotNull Field<T> nvl(Field<T> defaultValue)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.nvl(Field, Field)

nvl2

@Deprecated
@NotNull
@Support
<Z> @NotNull Field<Z> nvl2(Z valueIfNotNull,
                           Z valueIfNull)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.nvl2(Field, Object, Object)

nvl2

@Deprecated
@NotNull
@Support
<Z> @NotNull Field<Z> nvl2(Field<Z> valueIfNotNull,
                           Field<Z> valueIfNull)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.nvl2(Field, Field, Field)

nullif

@Deprecated
@NotNull
@Support
@NotNull Field<T> nullif(T other)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.nullif(Field, Object)

nullif

@Deprecated
@NotNull
@Support
@NotNull Field<T> nullif(Field<T> other)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.nullif(Field, Field)

decode

@Deprecated
@NotNull
@Support
<Z> @NotNull Field<Z> decode(T search,
                             Z result)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.decode(Object, Object, Object)

decode

@Deprecated
@NotNull
@Support
<Z> @NotNull Field<Z> decode(T search,
                             Z result,
                             Object... more)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.decode(Object, Object, Object, Object...)

decode

@Deprecated
@NotNull
@Support
<Z> @NotNull Field<Z> decode(Field<T> search,
                             Field<Z> result)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.decode(Field, Field, Field)

decode

@Deprecated
@NotNull
@Support
<Z> @NotNull Field<Z> decode(Field<T> search,
                             Field<Z> result,
                             Field<?>... more)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.decode(Field, Field, Field, Field...)

coalesce

@Deprecated
@NotNull
@Support
@NotNull Field<T> coalesce(T option,
                           T... options)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.coalesce(Object, Object...)

coalesce

@Deprecated
@NotNull
@Support
@NotNull Field<T> coalesce(Field<T> option,
                           Field<?>... options)

Deprecated.

- 3.13 - [#9407] - Use DSL.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 from DSLContext

See Also:

DSL.coalesce(Field, Field...)

plus

@NotNull
@Support
@Pro
@NotNull Field<T> plus()

Turn this field into an Oracle-specific field for use in outer-join predicates. It can be emulated using Settings.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

@Nullable
@Nullable Field<T> field(Record record)

The inverse operation of Record.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

@Nullable
T get(Record record)

The inverse operation of Record.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

@Nullable
T getValue(Record record)

The inverse operation of Record.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

@Nullable
T original(Record record)

The inverse operation of Record.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

boolean changed(Record record)

The inverse operation of Record.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

void reset(Record record)

The inverse operation of Record.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

@Nullable
@Nullable Record1<T> from(Record record)

The inverse operation of Record.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);