Module org.jooq

Package org.jooq.impl

Class CustomField<T>

java.lang.Object

org.jooq.impl.CustomField<T>

All Implemented Interfaces:

Serializable, Field<T>, FieldOrConstraint, FieldOrRow, GroupField, Named, OrderField<T>, QueryPart, QueryPartInternal, SelectField<T>, SelectFieldOrAsterisk, Typed<T>

public abstract class CustomField<T>
extends Object

A base class for custom Field implementations in client code.

Client code may provide proper Condition implementations extending this useful base class. All necessary parts of the Condition interface are already implemented. Only this method needs further implementation: accept(Context).

Refer to that methods' Javadoc for further details about their expected behaviour.

Author:

Lukas Eder

See Also:

Serialized Form

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	CustomField(String name, DataType<T> type)
protected	CustomField(Name name, DataType<T> type)

Method Summary

Modifier and Type	Method	Description
Field<T>	abs()	Deprecated.
abstract void	accept(Context<?> ctx)	Subclasses must implement this method.
Field<BigDecimal>	acos()	Deprecated.
Field<T>	add(Number value)	An arithmetic expression adding this to value.
Field<T>	add(Field<?> value)	An arithmetic expression to add value to this.
Field<T>	as(String alias)	Create an alias for this field.
Field<T>	as(Function<? super Field<T>,? extends String> aliasFunction)	Create an alias for this field.
Field<T>	as(Field<?> otherField)	Create an alias for this field based on another field's name.
Field<T>	as(Name alias)	Create an alias for this field.
SortField<T>	asc()	Create an ascending sort field from this field.
Field<Integer>	ascii()	Deprecated.
Field<BigDecimal>	asin()	Deprecated.
Field<BigDecimal>	atan()	Deprecated.
Field<BigDecimal>	atan2(Number y)	Deprecated.
Field<BigDecimal>	atan2(Field<? extends Number> y)	Deprecated.
Field<BigDecimal>	avg()	Deprecated.
WindowPartitionByStep<BigDecimal>	avgOver()	Deprecated.
BetweenAndStep<T>	between(Field<T> minValue)	Create a condition to check this field against some bounds.
Condition	between(Field<T> minValue, Field<T> maxValue)	Create a condition to check this field against some bounds.
BetweenAndStep<T>	between(T minValue)	Create a condition to check this field against some bounds.
Condition	between(T minValue, T maxValue)	Create a condition to check this field against some bounds.
BetweenAndStep<T>	betweenSymmetric(Field<T> minValue)	Create a condition to check this field against some bounds.
Condition	betweenSymmetric(Field<T> minValue, Field<T> maxValue)	Create a condition to check this field against some bounds.
BetweenAndStep<T>	betweenSymmetric(T minValue)	Create a condition to check this field against some bounds.
Condition	betweenSymmetric(T minValue, T maxValue)	Create a condition to check this field against some bounds.
Field<T>	bitAnd(Field<T> value)	The bitwise and operator.
Field<T>	bitAnd(T value)	The bitwise and operator.
Field<Integer>	bitLength()	Deprecated.
Field<T>	bitNand(Field<T> value)	The bitwise not and operator.
Field<T>	bitNand(T value)	The bitwise not and operator.
Field<T>	bitNor(Field<T> value)	The bitwise not or operator.
Field<T>	bitNor(T value)	The bitwise not or operator.
Field<T>	bitNot()	The bitwise not operator.
Field<T>	bitOr(Field<T> value)	The bitwise or operator.
Field<T>	bitOr(T value)	The bitwise or operator.
Field<T>	bitXNor(Field<T> value)	The bitwise not xor operator.
Field<T>	bitXNor(T value)	The bitwise not xor operator.
Field<T>	bitXor(Field<T> value)	The bitwise xor operator.
Field<T>	bitXor(T value)	The bitwise xor operator.
<Z> Field<Z>	cast(Class<Z> type)	Cast this field to another type.
<Z> Field<Z>	cast(DataType<Z> type)	Cast this field to a dialect-specific data type.
<Z> Field<Z>	cast(Field<Z> field)	Cast this field to the type of another field.
Field<T>	ceil()	Deprecated.
boolean	changed(Record record)	The inverse operation of Record.changed(Field).
Field<Integer>	charLength()	Deprecated.
Clause[]	clauses(Context<?> ctx)	The Clauses that are represented by this query part.
Field<T>	coalesce(Field<T> option, Field<?>... options)	Deprecated.
Field<T>	coalesce(T option, T... options)	Deprecated.
<Z> Field<Z>	coerce(Class<Z> type)	Coerce this field to another type.
<Z> Field<Z>	coerce(DataType<Z> type)	Coerce this field to a dialect-specific data type.
<Z> Field<Z>	coerce(Field<Z> field)	Coerce this field to the type of another field.
Field<String>	collate(String collation)	Apply a collation operator to this column expression.
Field<String>	collate(Collation collation)	Apply a collation operator to this column expression.
Field<String>	collate(Name collation)	Apply a collation operator to this column expression.
Condition	compare(Comparator comparator, Field<T> field)	Compare this field with another field using a dynamic comparator.
Condition	compare(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query)	Compare this field with a quantified subselect using a dynamic comparator.
Condition	compare(Comparator comparator, Select<? extends Record1<T>> query)	Compare this field with a subselect using a dynamic comparator.
Condition	compare(Comparator comparator, T value)	Compare this field with a value using a dynamic comparator.
Field<String>	concat(char... values)	This method is part of the pre-2.0 API.
Field<String>	concat(String... values)	Deprecated.
Field<String>	concat(Field<?>... fields)	Deprecated.
Condition	contains(Field<T> value)	Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
Condition	contains(T value)	Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
Condition	containsIgnoreCase(Field<T> value)	Convenience method for Field.likeIgnoreCase(String, char) including proper adding of wildcards and escaping.
Condition	containsIgnoreCase(T value)	Convenience method for Field.likeIgnoreCase(String, char) including proper adding of wildcards and escaping.
<U> Field<U>	convert(Class<U> toType, Function<? super T,? extends U> from, Function<? super U,? extends T> to)	Apply an ad-hoc data type Converter to this field expression.
<U> Field<U>	convert(Binding<T,U> binding)	Apply an ad-hoc data type Binding to this field expression.
<U> Field<U>	convert(Converter<T,U> converter)	Apply an ad-hoc data type Converter to this field expression.
<U> Field<U>	convertFrom(Class<U> toType, Function<? super T,? extends U> from)	Apply an ad-hoc read-only data type Converter to this field expression.
<U> Field<U>	convertFrom(Function<? super T,? extends U> from)	Apply an ad-hoc read-only data type Converter to this field expression.
<U> Field<U>	convertTo(Class<U> toType, Function<? super U,? extends T> to)	Apply an ad-hoc write-only data type Converter to this field expression.
<U> Field<U>	convertTo(Function<? super U,? extends T> to)	Apply an ad-hoc write-only data type Converter to this field expression.
Field<BigDecimal>	cos()	Deprecated.
Field<BigDecimal>	cosh()	Deprecated.
Field<BigDecimal>	cot()	Deprecated.
Field<BigDecimal>	coth()	Deprecated.
Field<Integer>	count()	Deprecated.
Field<Integer>	countDistinct()	Deprecated.
WindowPartitionByStep<Integer>	countOver()	Deprecated.
protected DSLContext	create()	Deprecated. - 3.11.0 - [#6722] - Use Attachable.configuration() and Configuration.dsl() instead.
protected DSLContext	create(Configuration configuration)	Deprecated. - 3.11.0 - [#6722] - Use Attachable.configuration() and Configuration.dsl() instead.
protected DSLContext	create(Context<?> ctx)	Deprecated. - 3.11.0 - [#6722] - Use Attachable.configuration() and Configuration.dsl() instead.
boolean	declaresCTE()	Subclasses may override this
boolean	declaresFields()	Subclasses may override this
boolean	declaresParameters()	Subclasses may override this
boolean	declaresTables()	Subclasses may override this
boolean	declaresWindows()	Subclasses may override this
<Z> Field<Z>	decode(Field<T> search, Field<Z> result)	Deprecated.
<Z> Field<Z>	decode(Field<T> search, Field<Z> result, Field<?>... more)	Deprecated.
<Z> Field<Z>	decode(T search, Z result)	Deprecated.
<Z> Field<Z>	decode(T search, Z result, Object... more)	Deprecated.
Field<BigDecimal>	deg()	Deprecated.
SortField<T>	desc()	Create a descending sort field from this field.
Field<T>	div(Number value)	An arithmetic expression dividing this by value.
Field<T>	div(Field<? extends Number> value)	An arithmetic expression dividing this by value.
Field<T>	divide(Number value)	An alias for Field.div(Number).
Field<T>	divide(Field<? extends Number> value)	An alias for Field.div(Field).
Condition	endsWith(Field<T> value)	Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
Condition	endsWith(T value)	Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
Condition	endsWithIgnoreCase(Field<T> value)	Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
Condition	endsWithIgnoreCase(T value)	Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
Condition	eq(Field<T> field)	this = field.
Condition	eq(QuantifiedSelect<? extends Record1<T>> query)	this = [quantifier] (Select<?> ...).
Condition	eq(Select<? extends Record1<T>> query)	this = (Select<?> ...).
Condition	eq(T value)	this = value.
Condition	equal(Field<T> field)	this = field.
Condition	equal(QuantifiedSelect<? extends Record1<T>> query)	this = [quantifier] (Select<?> ...).
Condition	equal(Select<? extends Record1<T>> query)	this = (Select<?> ...).
Condition	equal(T value)	this = value.
Condition	equalIgnoreCase(String value)	lower(this) = lower(value).
Condition	equalIgnoreCase(Field<String> value)	lower(this) = lower(value).
boolean	equals(Object that)	Check whether this QueryPart can be considered equal to another QueryPart.
Field<BigDecimal>	exp()	Deprecated.
Field<Integer>	extract(DatePart datePart)	Deprecated.
Field<T>	field(Record record)	The inverse operation of Fields.field(Field).
WindowIgnoreNullsStep<T>	firstValue()	Deprecated.
Field<T>	floor()	Deprecated.
Record1<T>	from(Record record)	The inverse operation of Record.into(Field).
Condition	ge(Field<T> field)	this >= field.
Condition	ge(QuantifiedSelect<? extends Record1<T>> query)	this >= [quantifier] (Select<?> ...).
Condition	ge(Select<? extends Record1<T>> query)	this >= (Select<?> ...).
Condition	ge(T value)	this >= value.
boolean	generatesCast()	Subclasses may override this
T	get(Record record)	The inverse operation of Record.get(Field).
Binding<?,T>	getBinding()	The object's underlying Binding.
String	getComment()	The comment on this object.
Comment	getCommentPart()	The comment on this object as a QueryPart.
Converter<?,T>	getConverter()	The object's underlying Converter.
DataType<T>	getDataType()	The type of this object (might not be dialect-specific).
DataType<T>	getDataType(Configuration configuration)	The dialect-specific type of this object.
String	getName()	The unqualified name of this object.
Name	getQualifiedName()	The qualified name of this object.
Class<T>	getType()	The Java type of the object.
Name	getUnqualifiedName()	The unqualified name of this object.
T	getValue(Record record)	The inverse operation of Record.getValue(Field).
Condition	greaterOrEqual(Field<T> field)	this >= field.
Condition	greaterOrEqual(QuantifiedSelect<? extends Record1<T>> query)	this >= [quantifier] (Select<?> ...).
Condition	greaterOrEqual(Select<? extends Record1<T>> query)	this >= (Select<?> ...).
Condition	greaterOrEqual(T value)	this >= value.
Condition	greaterThan(Field<T> field)	this > field.
Condition	greaterThan(QuantifiedSelect<? extends Record1<T>> query)	this > [quantifier] (Select<?> ...).
Condition	greaterThan(Select<? extends Record1<T>> query)	this > (Select<?> ...).
Condition	greaterThan(T value)	this > value.
Field<T>	greatest(Field<?>... others)	Deprecated.
Field<T>	greatest(T... others)	Deprecated.
Condition	gt(Field<T> field)	this > field.
Condition	gt(QuantifiedSelect<? extends Record1<T>> query)	this > [quantifier] (Select<?> ...).
Condition	gt(Select<? extends Record1<T>> query)	this > (Select<?> ...).
Condition	gt(T value)	this > value.
int	hashCode()	Generate a hash code from this QueryPart.
Condition	in(Collection<?> values)	Create a condition to check this field against several values.
Condition	in(Field<?>... values)	Create a condition to check this field against several values.
Condition	in(Result<? extends Record1<T>> result)	Create a condition to check this field against several values from a previous query.
Condition	in(Select<? extends Record1<T>> query)	Create a condition to check this field against a subquery.
Condition	in(T... values)	Create a condition to check this field against several values.
Condition	isDistinctFrom(Field<T> field)	Create a condition to check if this field is DISTINCT from another field.
Condition	isDistinctFrom(Select<? extends Record1<T>> select)	Create a condition to check if this field is DISTINCT from another field.
Condition	isDistinctFrom(T value)	Create a condition to check if this field is DISTINCT from another value.
Condition	isDocument()	Create a condition to check if this field contains XML data.
Condition	isFalse()	Create a condition to check this field against known string literals for false.
Condition	isJson()	Create a condition to check if this field contains JSON data.
Condition	isNotDistinctFrom(Field<T> field)	Create a condition to check if this field is NOT DISTINCT from another field.
Condition	isNotDistinctFrom(Select<? extends Record1<T>> select)	Create a condition to check if this field is NOT DISTINCT from another field.
Condition	isNotDistinctFrom(T value)	Create a condition to check if this field is NOT DISTINCT from another value.
Condition	isNotDocument()	Create a condition to check if this field does not contain XML data.
Condition	isNotJson()	Create a condition to check if this field does not contain JSON data.
Condition	isNotNull()	Create a condition to check this field against null.
Condition	isNull()	Create a condition to check this field against null.
Condition	isTrue()	Create a condition to check this field against known string literals for true.
WindowIgnoreNullsStep<T>	lag()	Deprecated.
WindowIgnoreNullsStep<T>	lag(int offset)	Deprecated.
WindowIgnoreNullsStep<T>	lag(int offset, Field<T> defaultValue)	Deprecated.
WindowIgnoreNullsStep<T>	lag(int offset, T defaultValue)	Deprecated.
WindowIgnoreNullsStep<T>	lastValue()	Deprecated.
Condition	le(Field<T> field)	this <= field.
Condition	le(QuantifiedSelect<? extends Record1<T>> query)	this <= [quantifier] (Select<?> ...).
Condition	le(Select<? extends Record1<T>> query)	this <= (Select<?> ...).
Condition	le(T value)	this <= value.
WindowIgnoreNullsStep<T>	lead()	Deprecated.
WindowIgnoreNullsStep<T>	lead(int offset)	Deprecated.
WindowIgnoreNullsStep<T>	lead(int offset, Field<T> defaultValue)	Deprecated.
WindowIgnoreNullsStep<T>	lead(int offset, T defaultValue)	Deprecated.
Field<T>	least(Field<?>... others)	Deprecated.
Field<T>	least(T... others)	Deprecated.
Field<Integer>	length()	Deprecated.
Condition	lessOrEqual(Field<T> field)	this <= field.
Condition	lessOrEqual(QuantifiedSelect<? extends Record1<T>> query)	this <= [quantifier] (Select<?> ...).
Condition	lessOrEqual(Select<? extends Record1<T>> query)	this <= (Select<?> ...).
Condition	lessOrEqual(T value)	this <= value.
Condition	lessThan(Field<T> field)	this < field.
Condition	lessThan(QuantifiedSelect<? extends Record1<T>> query)	this < [quantifier] (Select<?> ...).
Condition	lessThan(Select<? extends Record1<T>> query)	this < (Select<?> ...).
Condition	lessThan(T value)	this < value.
LikeEscapeStep	like(String value)	Create a condition to pattern-check this field against a value.
Condition	like(String value, char escape)	Create a condition to pattern-check this field against a value.
LikeEscapeStep	like(Field<String> field)	Create a condition to pattern-check this field against a value.
Condition	like(Field<String> field, char escape)	Create a condition to pattern-check this field against a value.
LikeEscapeStep	like(QuantifiedSelect<Record1<String>> query)	Create a condition to pattern-check this field against a quantified select.
LikeEscapeStep	likeIgnoreCase(String value)	Create a condition to case-insensitively pattern-check this field against a value.
Condition	likeIgnoreCase(String value, char escape)	Create a condition to case-insensitively pattern-check this field against a value.
LikeEscapeStep	likeIgnoreCase(Field<String> field)	Create a condition to case-insensitively pattern-check this field against a field.
Condition	likeIgnoreCase(Field<String> field, char escape)	Create a condition to case-insensitively pattern-check this field against a field.
Condition	likeRegex(String pattern)	Create a condition to regex-pattern-check this field against a pattern.
Condition	likeRegex(Field<String> pattern)	Create a condition to regex-pattern-check this field against a pattern.
Field<BigDecimal>	ln()	Deprecated.
Field<BigDecimal>	log(int base)	Deprecated.
Field<String>	lower()	Deprecated.
Field<String>	lpad(int length)	Deprecated.
Field<String>	lpad(int length, char character)	Deprecated.
Field<String>	lpad(Field<? extends Number> length)	Deprecated.
Field<String>	lpad(Field<? extends Number> length, Field<String> character)	Deprecated.
Condition	lt(Field<T> field)	this < field.
Condition	lt(QuantifiedSelect<? extends Record1<T>> query)	this < [quantifier] (Select<?> ...).
Condition	lt(Select<? extends Record1<T>> query)	this < (Select<?> ...).
Condition	lt(T value)	this < value.
Field<String>	ltrim()	Deprecated.
Field<T>	max()	Deprecated.
WindowPartitionByStep<T>	maxOver()	Deprecated.
Field<BigDecimal>	median()	Deprecated.
Field<T>	min()	Deprecated.
WindowPartitionByStep<T>	minOver()	Deprecated.
Field<T>	minus(Number value)	An alias for Field.sub(Number).
Field<T>	minus(Field<?> value)	An alias for Field.sub(Field).
Field<T>	mod(Number value)	An arithmetic expression getting the modulo of this divided by value.
Field<T>	mod(Field<? extends Number> value)	An arithmetic expression getting the modulo of this divided by value.
Field<T>	modulo(Number value)	An alias for Field.mod(Number).
Field<T>	modulo(Field<? extends Number> value)	An alias for Field.mod(Field).
Field<T>	mul(Number value)	An arithmetic expression multiplying this with value.
Field<T>	mul(Field<? extends Number> value)	An arithmetic expression multiplying this with value.
Field<T>	multiply(Number value)	An alias for Field.mul(Number).
Field<T>	multiply(Field<? extends Number> value)	An alias for Field.mul(Field).
Condition	ne(Field<T> field)	this != field.
Condition	ne(QuantifiedSelect<? extends Record1<T>> query)	this != [quantifier] (Select<?> ...).
Condition	ne(Select<? extends Record1<T>> query)	this != (Select<?> ...).
Condition	ne(T value)	this != value.
Field<T>	neg()	Negate this field to get its negative value.
BetweenAndStep<T>	notBetween(Field<T> minValue)	Create a condition to check this field against some bounds.
Condition	notBetween(Field<T> minValue, Field<T> maxValue)	Create a condition to check this field against some bounds.
BetweenAndStep<T>	notBetween(T minValue)	Create a condition to check this field against some bounds.
Condition	notBetween(T minValue, T maxValue)	Create a condition to check this field against some bounds.
BetweenAndStep<T>	notBetweenSymmetric(Field<T> minValue)	Create a condition to check this field against some bounds.
Condition	notBetweenSymmetric(Field<T> minValue, Field<T> maxValue)	Create a condition to check this field against some bounds.
BetweenAndStep<T>	notBetweenSymmetric(T minValue)	Create a condition to check this field against some bounds.
Condition	notBetweenSymmetric(T minValue, T maxValue)	Create a condition to check this field against some bounds.
Condition	notContains(Field<T> value)	Inverse of Field.contains(Field).
Condition	notContains(T value)	Inverse of Field.contains(Object).
Condition	notContainsIgnoreCase(Field<T> value)	Inverse of Field.containsIgnoreCase(Field)
Condition	notContainsIgnoreCase(T value)	Inverse of Field.containsIgnoreCase(Object)
Condition	notEqual(Field<T> field)	this != field.
Condition	notEqual(QuantifiedSelect<? extends Record1<T>> query)	this != [quantifier] (Select<?> ...).
Condition	notEqual(Select<? extends Record1<T>> query)	this != (Select<?> ...).
Condition	notEqual(T value)	this != value.
Condition	notEqualIgnoreCase(String value)	lower(this) != lower(value).
Condition	notEqualIgnoreCase(Field<String> value)	lower(this) != lower(value).
Condition	notIn(Collection<?> values)	Create a condition to check this field against several values.
Condition	notIn(Field<?>... values)	Create a condition to check this field against several values.
Condition	notIn(Result<? extends Record1<T>> result)	Create a condition to check this field against several values from a previous query.
Condition	notIn(Select<? extends Record1<T>> query)	Create a condition to check this field against a subquery.
Condition	notIn(T... values)	Create a condition to check this field against several values.
LikeEscapeStep	notLike(String value)	Create a condition to pattern-check this field against a value.
Condition	notLike(String value, char escape)	Create a condition to pattern-check this field against a value.
LikeEscapeStep	notLike(Field<String> field)	Create a condition to pattern-check this field against a field.
Condition	notLike(Field<String> field, char escape)	Create a condition to pattern-check this field against a field.
LikeEscapeStep	notLike(QuantifiedSelect<Record1<String>> query)	Create a condition to pattern-check this field against a quantified select.
LikeEscapeStep	notLikeIgnoreCase(String value)	Create a condition to case-insensitively pattern-check this field against a value.
Condition	notLikeIgnoreCase(String value, char escape)	Create a condition to case-insensitively pattern-check this field against a value.
LikeEscapeStep	notLikeIgnoreCase(Field<String> field)	Create a condition to case-insensitively pattern-check this field against a field.
Condition	notLikeIgnoreCase(Field<String> field, char escape)	Create a condition to case-insensitively pattern-check this field against a field.
Condition	notLikeRegex(String pattern)	Create a condition to regex-pattern-check this field against a pattern.
Condition	notLikeRegex(Field<String> pattern)	Create a condition to regex-pattern-check this field against a pattern.
LikeEscapeStep	notSimilarTo(String value)	Create a condition to pattern-check this field against a value.
Condition	notSimilarTo(String value, char escape)	Create a condition to pattern-check this field against a value.
LikeEscapeStep	notSimilarTo(Field<String> field)	Create a condition to pattern-check this field against a field.
Condition	notSimilarTo(Field<String> field, char escape)	Create a condition to pattern-check this field against a field.
Field<T>	nullif(Field<T> other)	Deprecated.
Field<T>	nullif(T other)	Deprecated.
Field<T>	nvl(Field<T> defaultValue)	Deprecated.
Field<T>	nvl(T defaultValue)	Deprecated.
<Z> Field<Z>	nvl2(Field<Z> valueIfNotNull, Field<Z> valueIfNull)	Deprecated.
<Z> Field<Z>	nvl2(Z valueIfNotNull, Z valueIfNull)	Deprecated.
Field<Integer>	octetLength()	Deprecated.
static <T> CustomField<T>	of(String name, DataType<T> type, Consumer<? super Context<?>> consumer)	Create a CustomField from a lambda expression.
static <T> CustomField<T>	of(Name name, DataType<T> type, Consumer<? super Context<?>> consumer)	Create a CustomField from a lambda expression.
T	original(Record record)	The inverse operation of Record.original(Field).
Field<T>	plus()	Turn this field into an Oracle-specific field for use in outer-join predicates.
Field<T>	plus(Number value)	An alias for Field.add(Number).
Field<T>	plus(Field<?> value)	An alias for Field.add(Field).
Field<Integer>	position(String search)	Deprecated.
Field<Integer>	position(Field<String> search)	Deprecated.
Field<BigDecimal>	pow(Number exponent)	An arithmetic expression getting this value raised to the power of exponent.
Field<BigDecimal>	pow(Field<? extends Number> exponent)	An arithmetic expression getting this value raised to the power of exponent.
Field<BigDecimal>	power(Number exponent)	An alias for Field.power(Number).
Field<BigDecimal>	power(Field<? extends Number> exponent)	An alias for Field.power(Field).
Field<BigDecimal>	rad()	Deprecated.
Field<T>	rem(Number value)	An alias for Field.mod(Number).
Field<T>	rem(Field<? extends Number> value)	An alias for Field.mod(Field).
boolean	rendersContent(Context<?> ctx)	Subclasses may override this
Field<String>	repeat(Number count)	Deprecated.
Field<String>	repeat(Field<? extends Number> count)	Deprecated.
Field<String>	replace(String search)	Deprecated.
Field<String>	replace(String search, String replace)	Deprecated.
Field<String>	replace(Field<String> search)	Deprecated.
Field<String>	replace(Field<String> search, Field<String> replace)	Deprecated.
void	reset(Record record)	The inverse operation of Record.reset(Field).
Field<T>	round()	Deprecated.
Field<T>	round(int decimals)	Deprecated.
Field<String>	rpad(int length)	Deprecated.
Field<String>	rpad(int length, char character)	Deprecated.
Field<String>	rpad(Field<? extends Number> length)	Deprecated.
Field<String>	rpad(Field<? extends Number> length, Field<String> character)	Deprecated.
Field<String>	rtrim()	Deprecated.
Field<T>	shl(Number value)	The bitwise left shift operator.
Field<T>	shl(Field<? extends Number> value)	The bitwise left shift operator.
Field<T>	shr(Number value)	The bitwise right shift operator.
Field<T>	shr(Field<? extends Number> value)	The bitwise right shift operator.
Field<Integer>	sign()	Deprecated.
LikeEscapeStep	similarTo(String value)	Create a condition to pattern-check this field against a value.
Condition	similarTo(String value, char escape)	Create a condition to pattern-check this field against a value.
LikeEscapeStep	similarTo(Field<String> field)	Create a condition to pattern-check this field against a value.
Condition	similarTo(Field<String> field, char escape)	Create a condition to pattern-check this field against a value.
Field<BigDecimal>	sin()	Deprecated.
Field<BigDecimal>	sinh()	Deprecated.
<Z> SortField<Z>	sort(Map<T,Z> sortMap)	Create an indirected sort field.
SortField<T>	sort(SortOrder order)	Create an ascending/descending sort field from this field.
SortField<Integer>	sortAsc(Collection<T> sortList)	Create an indirected sort field.
SortField<Integer>	sortAsc(T... sortList)	Create an indirected sort field.
SortField<T>	sortDefault()	Create a default sorted (implicit ASC) from this field.
SortField<Integer>	sortDesc(Collection<T> sortList)	Create an indirected sort field.
SortField<Integer>	sortDesc(T... sortList)	Create an indirected sort field.
Field<BigDecimal>	sqrt()	Deprecated.
Condition	startsWith(Field<T> value)	Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
Condition	startsWith(T value)	Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
Condition	startsWithIgnoreCase(Field<T> value)	Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
Condition	startsWithIgnoreCase(T value)	Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
Field<BigDecimal>	stddevPop()	Deprecated.
WindowPartitionByStep<BigDecimal>	stddevPopOver()	Deprecated.
Field<BigDecimal>	stddevSamp()	Deprecated.
WindowPartitionByStep<BigDecimal>	stddevSampOver()	Deprecated.
Field<T>	sub(Number value)	An arithmetic expression subtracting value from this.
Field<T>	sub(Field<?> value)	An arithmetic expression subtracting value from this.
Field<String>	substring(int startingPosition)	Deprecated.
Field<String>	substring(int startingPosition, int length)	Deprecated.
Field<String>	substring(Field<? extends Number> startingPosition)	Deprecated.
Field<String>	substring(Field<? extends Number> startingPosition, Field<? extends Number> length)	Deprecated.
Field<T>	subtract(Number value)	An alias for Field.sub(Number).
Field<T>	subtract(Field<?> value)	An alias for Field.sub(Field).
Field<BigDecimal>	sum()	Deprecated.
WindowPartitionByStep<BigDecimal>	sumOver()	Deprecated.
Field<BigDecimal>	tan()	Deprecated.
Field<BigDecimal>	tanh()	Deprecated.
Field<T>	times(Number value)	An alias for Field.mul(Number).
Field<T>	times(Field<? extends Number> value)	An alias for Field.mul(Field).
String	toString()	Render a SQL string representation of this QueryPart.
protected DataAccessException	translate(String sql, SQLException e)	Internal convenience method
Field<String>	trim()	Deprecated.
Field<T>	unaryMinus()	Negate this field to get its negative value.
Field<T>	unaryPlus()	Get this field as its positive value (no effect on SQL).
Field<String>	upper()	Deprecated.
Field<BigDecimal>	varPop()	Deprecated.
WindowPartitionByStep<BigDecimal>	varPopOver()	Deprecated.
Field<BigDecimal>	varSamp()	Deprecated.
WindowPartitionByStep<BigDecimal>	varSampOver()	Deprecated.

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.jooq.Field

equals, getComment, getName

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.QueryPartInternal

declaresCTE, declaresParameters, declaresWindows, generatesCast, rendersContent

Methods inherited from interface org.jooq.Typed

getBinding, getConverter, getDataType, getDataType, getType

Constructor Details

CustomField

protected CustomField(String name,
 DataType<T> type)

CustomField

protected CustomField(Name name,
 DataType<T> type)

Method Details

of

public static final <T> CustomField<T> of(String name,
 DataType<T> type,
 Consumer<? super Context<?>> consumer)

Create a CustomField from a lambda expression.

of

public static final <T> CustomField<T> of(Name name,
 DataType<T> type,
 Consumer<? super Context<?>> consumer)

Create a CustomField from a lambda expression.

accept

public abstract void accept(Context<?> ctx)

Subclasses must implement this method. This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.

Specified by:

accept in interface QueryPartInternal

clauses

public final Clause[] clauses(Context<?> ctx)

Description copied from interface: QueryPartInternal

The Clauses that are represented by this query part.

QueryParts can specify several Clauses for which an event will be emitted before (in forward order) and after (in reverse order) visiting the the query part through Context.visit(QueryPart)

This method is for JOOQ INTERNAL USE only. Do not reference directly

Specified by:

clauses in interface QueryPartInternal

Returns:

The Clauses represented by this query part or null or an empty array if this query part does not represent a clause.

as

public final Field<T> as(Name alias)

Description copied from interface: SelectField

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.

Specified by:

as in interface SelectField<T>

Parameters:

alias - The alias name

Returns:

The field alias

declaresFields

public final boolean declaresFields()

Subclasses may override this

Specified by:

declaresFields in interface QueryPartInternal

declaresTables

public final boolean declaresTables()

Subclasses may override this

Specified by:

declaresTables in interface QueryPartInternal

field

public final Field<T> field(Record record)

Description copied from interface: Field

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

Specified by:

field in interface Field<T>

get

public final T get(Record record)

Description copied from interface: Field

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);
 

Specified by:

get in interface Field<T>

getValue

public final T getValue(Record record)

Description copied from interface: Field

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);
 

Specified by:

getValue in interface Field<T>

original

public final T original(Record record)

Description copied from interface: Field

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);
 

Specified by:

original in interface Field<T>

changed

public final boolean changed(Record record)

Description copied from interface: Field

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);
 

Specified by:

changed in interface Field<T>

reset

public final void reset(Record record)

Description copied from interface: Field

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);
 

Specified by:

reset in interface Field<T>

from

public final Record1<T> from(Record record)

Description copied from interface: Field

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);
 

Specified by:

from in interface Field<T>

convert

public final <U> Field<U> convert(Binding<T,U> binding)

Description copied from interface: Field

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

Rather than attaching data type bindings at code generation time, or creating cumbersome expressions using DataType.asConvertedDataType(Binding), this method allows for creating a derived field expression with an ad-hoc data type binding for single query usage.

Specified by:

convert in interface Field<T>

Type Parameters:

U - The user type.

Parameters:

binding - The binding to be applied on any operations using this field.

Returns:

A derived field expression using a new binding.

convert

public final <U> Field<U> convert(Converter<T,U> converter)

Description copied from interface: Field

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

Rather than attaching data type converters at code generation time, or creating cumbersome expressions using DataType.asConvertedDataType(Converter), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.

Specified by:

convert in interface Field<T>

Type Parameters:

U - The user type.

Parameters:

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

Returns:

A derived field expression using a new converter.

convert

public final <U> Field<U> convert(Class<U> toType,
 Function<? super T,? extends U> from,
 Function<? super U,? extends T> to)

Description copied from interface: Field

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

Rather than attaching data type converters at code generation time, or creating cumbersome expressions using DataType.asConvertedDataType(Class, Function, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.

Specified by:

convert in interface Field<T>

Type Parameters:

U - The user type.

Returns:

A derived field expression using a new converter.

convertFrom

public final <U> Field<U> convertFrom(Class<U> toType,
 Function<? super T,? extends U> from)

Description copied from interface: Field

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

Rather than attaching data type converters at code generation time, or creating cumbersome expressions using DataType.asConvertedDataTypeFrom(Class, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.

Specified by:

convertFrom in interface Field<T>

Type Parameters:

U - The user type.

Returns:

A derived field expression using a new converter.

convertFrom

public final <U> Field<U> convertFrom(Function<? super T,? extends U> from)

Description copied from interface: Field

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

Rather than attaching data type converters at code generation time, or creating cumbersome expressions using DataType.asConvertedDataTypeFrom(Class, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.

EXPERIMENTAL. Unlike Field.convertFrom(Class, Function), this method attempts to work without an explicit Class reference for the underlying Converter.toType(). There may be some edge cases where this doesn't work. Please report any bugs here: https://github.com/jOOQ/jOOQ/issues/new/choose

Specified by:

convertFrom in interface Field<T>

Type Parameters:

U - The user type.

Returns:

A derived field expression using a new converter.

convertTo

public final <U> Field<U> convertTo(Class<U> toType,
 Function<? super U,? extends T> to)

Description copied from interface: Field

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

Rather than attaching data type converters at code generation time, or creating cumbersome expressions using DataType.asConvertedDataTypeTo(Class, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.

Specified by:

convertTo in interface Field<T>

Type Parameters:

U - The user type.

Returns:

A derived field expression using a new converter.

convertTo

public final <U> Field<U> convertTo(Function<? super U,? extends T> to)

Description copied from interface: Field

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

Rather than attaching data type converters at code generation time, or creating cumbersome expressions using DataType.asConvertedDataTypeTo(Class, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.

EXPERIMENTAL. Unlike Field.convertTo(Class, Function), this method attempts to work without an explicit Class reference for the underlying Converter.toType(). There may be some edge cases where this doesn't work. Please report any bugs here: https://github.com/jOOQ/jOOQ/issues/new/choose

Specified by:

convertTo in interface Field<T>

Type Parameters:

U - The user type.

Returns:

A derived field expression using a new converter.

as

public final Field<T> as(String alias)

Description copied from interface: SelectField

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!

Specified by:

as in interface SelectField<T>

Parameters:

alias - The alias name

Returns:

The field alias

as

public final Field<T> as(Field<?> otherField)

Description copied from interface: SelectField

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

Specified by:

as in interface SelectField<T>

Parameters:

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

Returns:

The field alias.

as

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

Description copied from interface: Field

Create an alias for this field.

Note that the case-sensitivity of the returned field depends on Settings.getRenderQuotedNames(). By default, field aliases are quoted, and thus case-sensitive in many SQL dialects!

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

Specified by:

as in interface Field<T>

cast

public final <Z> Field<Z> cast(Field<Z> field)

Description copied from interface: Field

Cast this field to the type of another field.

This results in the same as casting this field to DataType.getCastTypeName()

Specified by:

cast in interface Field<T>

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:

Field.cast(DataType)

cast

public final <Z> Field<Z> cast(DataType<Z> type)

Description copied from interface: Field

Cast this field to a dialect-specific data type.

Specified by:

cast in interface Field<T>

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

public final <Z> Field<Z> cast(Class<Z> type)

Description copied from interface: Field

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 Field.cast(DataType) for more accurate casts.

Specified by:

cast in interface Field<T>

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:

Field.cast(DataType)

coerce

public final <Z> Field<Z> coerce(Field<Z> field)

Description copied from interface: 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);
 

Specified by:

coerce in interface Field<T>

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:

Field.coerce(DataType), Field.cast(Field)

coerce

public final <Z> Field<Z> coerce(DataType<Z> type)

Description copied from interface: Field

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);
 

Specified by:

coerce in interface Field<T>

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:

Field.cast(DataType)

coerce

public final <Z> Field<Z> coerce(Class<Z> type)

Description copied from interface: Field

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);
 

Specified by:

coerce in interface Field<T>

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:

Field.coerce(DataType), Field.cast(Class)

asc

public final SortField<T> asc()

Description copied from interface: Field

Create an ascending sort field from this field.

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

Specified by:

asc in interface Field<T>

Returns:

This field as an ascending sort field

desc

public final SortField<T> desc()

Description copied from interface: Field

Create a descending sort field from this field.

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

Specified by:

desc in interface Field<T>

Returns:

This field as a descending sort field

sortDefault

public final SortField<T> sortDefault()

Description copied from interface: Field

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

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

Specified by:

sortDefault in interface Field<T>

Returns:

This field as a default sorted sort field

sort

public final SortField<T> sort(SortOrder order)

Description copied from interface: Field

Create an ascending/descending sort field from this field.

Specified by:

sort in interface Field<T>

Parameters:

order - The sort order

Returns:

This field as an ascending/descending sort field.

sortAsc

public final SortField<Integer> sortAsc(Collection<T> sortList)

Description copied from interface: Field

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.

Specified by:

sortAsc in interface Field<T>

Parameters:

sortList - The list containing sort value preferences

Returns:

The sort field

sortAsc

@SafeVarargs
public final SortField<Integer> sortAsc(T... sortList)

Description copied from interface: Field

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.

Specified by:

sortAsc in interface Field<T>

Parameters:

sortList - The list containing sort value preferences

Returns:

The sort field

sortDesc

public final SortField<Integer> sortDesc(Collection<T> sortList)

Description copied from interface: Field

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.

Specified by:

sortDesc in interface Field<T>

Parameters:

sortList - The list containing sort value preferences

Returns:

The sort field

sortDesc

@SafeVarargs
public final SortField<Integer> sortDesc(T... sortList)

Description copied from interface: Field

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.

Specified by:

sortDesc in interface Field<T>

Parameters:

sortList - The list containing sort value preferences

Returns:

The sort field

sort

public final <Z> SortField<Z> sort(Map<T,Z> sortMap)

Description copied from interface: Field

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.

Specified by:

sort in interface Field<T>

Parameters:

sortMap - The list containing sort value preferences

Returns:

The sort field

neg

public final Field<T> neg()

Description copied from interface: Field

Negate this field to get its negative value.

This renders the same on all dialects:

-[this]

Specified by:

neg in interface Field<T>

unaryMinus

public final Field<T> unaryMinus()

Description copied from interface: Field

Negate this field to get its negative value.

This is an alias for Field.neg(), which can be recognised by the Kotlin language for operator overloading.

Specified by:

unaryMinus in interface Field<T>

unaryPlus

public final Field<T> unaryPlus()

Description copied from interface: Field

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

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

Specified by:

unaryPlus in interface Field<T>

add

public final Field<T> add(Number value)

Description copied from interface: Field

An arithmetic expression adding this to value.

Specified by:

add in interface Field<T>

See Also:

Field.add(Field)

add

public final Field<T> add(Field<?> value)

Description copied from interface: Field

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

Specified by:

add in interface Field<T>

sub

public final Field<T> sub(Number value)

Description copied from interface: Field

An arithmetic expression subtracting value from this.

Specified by:

sub in interface Field<T>

See Also:

Field.sub(Field)

sub

public final Field<T> sub(Field<?> value)

Description copied from interface: Field

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)

Specified by:

sub in interface Field<T>

mul

public final Field<T> mul(Number value)

Description copied from interface: Field

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)

Specified by:

mul in interface Field<T>

mul

public final Field<T> mul(Field<? extends Number> value)

Description copied from interface: Field

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)

Specified by:

mul in interface Field<T>

div

public final Field<T> div(Number value)

Description copied from interface: Field

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)

Specified by:

div in interface Field<T>

div

public final Field<T> div(Field<? extends Number> value)

Description copied from interface: Field

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)

Specified by:

div in interface Field<T>

mod

public final Field<T> mod(Number value)

Description copied from interface: Field

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])

Specified by:

mod in interface Field<T>

mod

public final Field<T> mod(Field<? extends Number> value)

Description copied from interface: Field

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])

Specified by:

mod in interface Field<T>

plus

public final Field<T> plus(Number value)

Description copied from interface: Field

An alias for Field.add(Number).

Specified by:

plus in interface Field<T>

See Also:

Field.add(Number)

plus

public final Field<T> plus(Field<?> value)

Description copied from interface: Field

An alias for Field.add(Field).

Specified by:

plus in interface Field<T>

See Also:

Field.add(Field)

subtract

public final Field<T> subtract(Number value)

Description copied from interface: Field

An alias for Field.sub(Number).

Specified by:

subtract in interface Field<T>

See Also:

Field.sub(Number)

subtract

public final Field<T> subtract(Field<?> value)

Description copied from interface: Field

An alias for Field.sub(Field).

Specified by:

subtract in interface Field<T>

See Also:

Field.sub(Field)

minus

public final Field<T> minus(Number value)

Description copied from interface: Field

An alias for Field.sub(Number).

Specified by:

minus in interface Field<T>

See Also:

Field.sub(Number)

minus

public final Field<T> minus(Field<?> value)

Description copied from interface: Field

An alias for Field.sub(Field).

Specified by:

minus in interface Field<T>

See Also:

Field.sub(Field)

multiply

public final Field<T> multiply(Number value)

Description copied from interface: Field

An alias for Field.mul(Number).

Specified by:

multiply in interface Field<T>

See Also:

Field.mul(Number)

multiply

public final Field<T> multiply(Field<? extends Number> value)

Description copied from interface: Field

An alias for Field.mul(Field).

Specified by:

multiply in interface Field<T>

See Also:

Field.mul(Field)

times

public final Field<T> times(Number value)

Description copied from interface: Field

An alias for Field.mul(Number).

Specified by:

times in interface Field<T>

See Also:

Field.mul(Number)

times

public final Field<T> times(Field<? extends Number> value)

Description copied from interface: Field

An alias for Field.mul(Field).

Specified by:

times in interface Field<T>

See Also:

Field.mul(Field)

divide

public final Field<T> divide(Number value)

Description copied from interface: Field

An alias for Field.div(Number).

Specified by:

divide in interface Field<T>

See Also:

Field.div(Number)

divide

public final Field<T> divide(Field<? extends Number> value)

Description copied from interface: Field

An alias for Field.div(Field).

Specified by:

divide in interface Field<T>

See Also:

Field.div(Field)

modulo

public final Field<T> modulo(Number value)

Description copied from interface: Field

An alias for Field.mod(Number).

Specified by:

modulo in interface Field<T>

See Also:

Field.mod(Number)

modulo

public final Field<T> modulo(Field<? extends Number> value)

Description copied from interface: Field

An alias for Field.mod(Field).

Specified by:

modulo in interface Field<T>

See Also:

Field.mod(Field)

rem

public final Field<T> rem(Number value)

Description copied from interface: Field

An alias for Field.mod(Number).

Specified by:

rem in interface Field<T>

See Also:

Field.mod(Number)

rem

public final Field<T> rem(Field<? extends Number> value)

Description copied from interface: Field

An alias for Field.mod(Field).

Specified by:

rem in interface Field<T>

See Also:

Field.mod(Field)

bitNot

public final Field<T> bitNot()

Description copied from interface: Field

The bitwise not operator.

Specified by:

bitNot in interface Field<T>

See Also:

DSL.bitNot(Field)

bitAnd

public final Field<T> bitAnd(T value)

Description copied from interface: Field

The bitwise and operator.

Specified by:

bitAnd in interface Field<T>

See Also:

DSL.bitAnd(Field, Field)

bitAnd

public final Field<T> bitAnd(Field<T> value)

Description copied from interface: Field

The bitwise and operator.

Specified by:

bitAnd in interface Field<T>

See Also:

DSL.bitAnd(Field, Field)

bitNand

public final Field<T> bitNand(T value)

Description copied from interface: Field

The bitwise not and operator.

Specified by:

bitNand in interface Field<T>

See Also:

DSL.bitNand(Field, Field), DSL.bitNot(Field)

bitNand

public final Field<T> bitNand(Field<T> value)

Description copied from interface: Field

The bitwise not and operator.

Specified by:

bitNand in interface Field<T>

See Also:

DSL.bitNand(Field, Field), DSL.bitNot(Field)

bitOr

public final Field<T> bitOr(T value)

Description copied from interface: Field

The bitwise or operator.

Specified by:

bitOr in interface Field<T>

See Also:

DSL.bitOr(Field, Field)

bitOr

public final Field<T> bitOr(Field<T> value)

Description copied from interface: Field

The bitwise or operator.

Specified by:

bitOr in interface Field<T>

See Also:

DSL.bitOr(Field, Field)

bitNor

public final Field<T> bitNor(T value)

Description copied from interface: Field

The bitwise not or operator.

Specified by:

bitNor in interface Field<T>

See Also:

DSL.bitNor(Field, Field), DSL.bitNot(Field)

bitNor

public final Field<T> bitNor(Field<T> value)

Description copied from interface: Field

The bitwise not or operator.

Specified by:

bitNor in interface Field<T>

See Also:

DSL.bitNor(Field, Field), DSL.bitNot(Field)

bitXor

public final Field<T> bitXor(T value)

Description copied from interface: Field

The bitwise xor operator.

Specified by:

bitXor in interface Field<T>

See Also:

DSL.bitXor(Field, Field)

bitXor

public final Field<T> bitXor(Field<T> value)

Description copied from interface: Field

The bitwise xor operator.

Specified by:

bitXor in interface Field<T>

See Also:

DSL.bitXor(Field, Field)

bitXNor

public final Field<T> bitXNor(T value)

Description copied from interface: Field

The bitwise not xor operator.

Specified by:

bitXNor in interface Field<T>

See Also:

DSL.bitXNor(Field, Field), DSL.bitNot(Field)

bitXNor

public final Field<T> bitXNor(Field<T> value)

Description copied from interface: Field

The bitwise not xor operator.

Specified by:

bitXNor in interface Field<T>

See Also:

DSL.bitXNor(Field, Field), DSL.bitNot(Field)

shl

public final Field<T> shl(Number value)

Description copied from interface: Field

The bitwise left shift operator.

Specified by:

shl in interface Field<T>

See Also:

DSL.shl(Field, Field), DSL.power(Field, Number)

shl

public final Field<T> shl(Field<? extends Number> value)

Description copied from interface: Field

The bitwise left shift operator.

Specified by:

shl in interface Field<T>

See Also:

DSL.shl(Field, Field), DSL.power(Field, Number)

shr

public final Field<T> shr(Number value)

Description copied from interface: Field

The bitwise right shift operator.

Specified by:

shr in interface Field<T>

See Also:

DSL.shr(Field, Field), DSL.power(Field, Number)

shr

public final Field<T> shr(Field<? extends Number> value)

Description copied from interface: Field

The bitwise right shift operator.

Specified by:

shr in interface Field<T>

See Also:

DSL.shr(Field, Field), DSL.power(Field, Number)

isDocument

public final Condition isDocument()

Description copied from interface: Field

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

Specified by:

isDocument in interface Field<T>

isNotDocument

public final Condition isNotDocument()

Description copied from interface: Field

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

Specified by:

isNotDocument in interface Field<T>

isJson

public final Condition isJson()

Description copied from interface: Field

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

Specified by:

isJson in interface Field<T>

isNotJson

public final Condition isNotJson()

Description copied from interface: Field

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

Specified by:

isNotJson in interface Field<T>

isNull

public final Condition isNull()

Description copied from interface: Field

Create a condition to check this field against null.

SQL: this is null

Specified by:

isNull in interface Field<T>

isNotNull

public final Condition isNotNull()

Description copied from interface: Field

Create a condition to check this field against null.

SQL: this is not null

Specified by:

isNotNull in interface Field<T>

isDistinctFrom

public final Condition isDistinctFrom(T value)

Description copied from interface: Field

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

Specified by:

isDistinctFrom in interface Field<T>

isDistinctFrom

public final Condition isDistinctFrom(Field<T> field)

Description copied from interface: 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

Specified by:

isDistinctFrom in interface Field<T>

isDistinctFrom

public final Condition isDistinctFrom(Select<? extends Record1<T>> select)

Description copied from interface: 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

Specified by:

isDistinctFrom in interface Field<T>

isNotDistinctFrom

public final Condition isNotDistinctFrom(T value)

Description copied from interface: Field

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

Specified by:

isNotDistinctFrom in interface Field<T>

isNotDistinctFrom

public final Condition isNotDistinctFrom(Field<T> field)

Description copied from interface: 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

Specified by:

isNotDistinctFrom in interface Field<T>

isNotDistinctFrom

public final Condition isNotDistinctFrom(Select<? extends Record1<T>> select)

Description copied from interface: 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

Specified by:

isNotDistinctFrom in interface Field<T>

isTrue

public final Condition isTrue()

Description copied from interface: Field

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

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

Specified by:

isTrue in interface Field<T>

isFalse

public final Condition isFalse()

Description copied from interface: Field

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

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

Specified by:

isFalse in interface Field<T>

similarTo

public final LikeEscapeStep similarTo(String value)

Description copied from interface: Field

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

SQL: this similar to value

Specified by:

similarTo in interface Field<T>

similarTo

public final Condition similarTo(String value,
 char escape)

Description copied from interface: Field

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

SQL: this similar to value escape 'e'

Specified by:

similarTo in interface Field<T>

See Also:

LikeEscapeStep.escape(char)

similarTo

public final LikeEscapeStep similarTo(Field<String> field)

Description copied from interface: Field

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

SQL: this similar to value

Specified by:

similarTo in interface Field<T>

similarTo

public final Condition similarTo(Field<String> field,
 char escape)

Description copied from interface: Field

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

SQL: this similar to value escape 'e'

Specified by:

similarTo in interface Field<T>

See Also:

LikeEscapeStep.escape(char)

notSimilarTo

public final LikeEscapeStep notSimilarTo(String value)

Description copied from interface: Field

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

SQL: this not similar to value

Specified by:

notSimilarTo in interface Field<T>

notSimilarTo

public final Condition notSimilarTo(String value,
 char escape)

Description copied from interface: Field

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

SQL: this not similar to value escape 'e'

Specified by:

notSimilarTo in interface Field<T>

See Also:

LikeEscapeStep.escape(char)

notSimilarTo

public final LikeEscapeStep notSimilarTo(Field<String> field)

Description copied from interface: Field

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

SQL: this not similar to field

Specified by:

notSimilarTo in interface Field<T>

notSimilarTo

public final Condition notSimilarTo(Field<String> field,
 char escape)

Description copied from interface: Field

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

SQL: this not similar to field escape 'e'

Specified by:

notSimilarTo in interface Field<T>

See Also:

LikeEscapeStep.escape(char)

like

public final LikeEscapeStep like(String value)

Description copied from interface: Field

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

SQL: this like value

Specified by:

like in interface Field<T>

like

public final Condition like(String value,
 char escape)

Description copied from interface: Field

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

SQL: this like value escape 'e'

Specified by:

like in interface Field<T>

See Also:

LikeEscapeStep.escape(char)

like

public final LikeEscapeStep like(Field<String> field)

Description copied from interface: Field

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

SQL: this like value

Specified by:

like in interface Field<T>

like

public final Condition like(Field<String> field,
 char escape)

Description copied from interface: Field

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

SQL: this like value escape 'e'

Specified by:

like in interface Field<T>

See Also:

LikeEscapeStep.escape(char)

like

public final LikeEscapeStep like(QuantifiedSelect<Record1<String>> query)

Description copied from interface: Field

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

Specified by:

like in interface Field<T>

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

public final LikeEscapeStep likeIgnoreCase(String value)

Description copied from interface: Field

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.

Specified by:

likeIgnoreCase in interface Field<T>

likeIgnoreCase

public final Condition likeIgnoreCase(String value,
 char escape)

Description copied from interface: Field

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.

Specified by:

likeIgnoreCase in interface Field<T>

See Also:

LikeEscapeStep.escape(char)

likeIgnoreCase

public final LikeEscapeStep likeIgnoreCase(Field<String> field)

Description copied from interface: 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.

Specified by:

likeIgnoreCase in interface Field<T>

likeIgnoreCase

public final Condition likeIgnoreCase(Field<String> field,
 char escape)

Description copied from interface: 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.

Specified by:

likeIgnoreCase in interface Field<T>

See Also:

LikeEscapeStep.escape(char)

likeRegex

public final Condition likeRegex(String pattern)

Description copied from interface: Field

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	https ://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

Specified by:

likeRegex in interface Field<T>

See Also:

Field.likeRegex(String)

likeRegex

public final Condition likeRegex(Field<String> pattern)

Description copied from interface: Field

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

See Field.likeRegex(String) for more details

Specified by:

likeRegex in interface Field<T>

See Also:

Field.likeRegex(String)

notLike

public final LikeEscapeStep notLike(String value)

Description copied from interface: Field

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

SQL: this not like value

Specified by:

notLike in interface Field<T>

notLike

public final Condition notLike(String value,
 char escape)

Description copied from interface: Field

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

SQL: this not like value escape 'e'

Specified by:

notLike in interface Field<T>

See Also:

LikeEscapeStep.escape(char)

notLike

public final LikeEscapeStep notLike(Field<String> field)

Description copied from interface: Field

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

SQL: this not like field

Specified by:

notLike in interface Field<T>

notLike

public final Condition notLike(Field<String> field,
 char escape)

Description copied from interface: Field

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

SQL: this not like field escape 'e'

Specified by:

notLike in interface Field<T>

See Also:

LikeEscapeStep.escape(char)

notLike

public final LikeEscapeStep notLike(QuantifiedSelect<Record1<String>> query)

Description copied from interface: Field

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

Specified by:

notLike in interface Field<T>

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

public final LikeEscapeStep notLikeIgnoreCase(String value)

Description copied from interface: Field

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.

Specified by:

notLikeIgnoreCase in interface Field<T>

notLikeIgnoreCase

public final Condition notLikeIgnoreCase(String value,
 char escape)

Description copied from interface: Field

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.

Specified by:

notLikeIgnoreCase in interface Field<T>

See Also:

LikeEscapeStep.escape(char)

notLikeIgnoreCase

public final LikeEscapeStep notLikeIgnoreCase(Field<String> field)

Description copied from interface: 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.

Specified by:

notLikeIgnoreCase in interface Field<T>

notLikeIgnoreCase

public final Condition notLikeIgnoreCase(Field<String> field,
 char escape)

Description copied from interface: 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.

Specified by:

notLikeIgnoreCase in interface Field<T>

See Also:

LikeEscapeStep.escape(char)

notLikeRegex

public final Condition notLikeRegex(String pattern)

Description copied from interface: Field

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

See Field.likeRegex(String) for more details

Specified by:

notLikeRegex in interface Field<T>

See Also:

Field.likeRegex(String)

notLikeRegex

public final Condition notLikeRegex(Field<String> pattern)

Description copied from interface: Field

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

See Field.likeRegex(String) for more details

Specified by:

notLikeRegex in interface Field<T>

See Also:

Field.likeRegex(Field)

contains

public final Condition contains(T value)

Description copied from interface: Field

Convenience method for Field.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.

Specified by:

contains in interface Field<T>

See Also:

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

contains

public final Condition contains(Field<T> value)

Description copied from interface: Field

Convenience method for Field.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.

Specified by:

contains in interface Field<T>

See Also:

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

notContains

public final Condition notContains(T value)

Description copied from interface: Field

Inverse of Field.contains(Object).

Specified by:

notContains in interface Field<T>

notContains

public final Condition notContains(Field<T> value)

Description copied from interface: Field

Inverse of Field.contains(Field).

Specified by:

notContains in interface Field<T>

containsIgnoreCase

public final Condition containsIgnoreCase(T value)

Description copied from interface: Field

Convenience method for Field.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.

Specified by:

containsIgnoreCase in interface Field<T>

See Also:

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

containsIgnoreCase

public final Condition containsIgnoreCase(Field<T> value)

Description copied from interface: Field

Convenience method for Field.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.

Specified by:

containsIgnoreCase in interface Field<T>

See Also:

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

notContainsIgnoreCase

public final Condition notContainsIgnoreCase(T value)

Description copied from interface: Field

Inverse of Field.containsIgnoreCase(Object)

Specified by:

notContainsIgnoreCase in interface Field<T>

notContainsIgnoreCase

public final Condition notContainsIgnoreCase(Field<T> value)

Description copied from interface: Field

Inverse of Field.containsIgnoreCase(Field)

Specified by:

notContainsIgnoreCase in interface Field<T>

startsWith

public final Condition startsWith(T value)

Description copied from interface: Field

Convenience method for Field.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)

Specified by:

startsWith in interface Field<T>

See Also:

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

startsWith

public final Condition startsWith(Field<T> value)

Description copied from interface: Field

Convenience method for Field.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)

Specified by:

startsWith in interface Field<T>

See Also:

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

startsWithIgnoreCase

public final Condition startsWithIgnoreCase(T value)

Description copied from interface: Field

Convenience method for Field.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)

Specified by:

startsWithIgnoreCase in interface Field<T>

See Also:

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

startsWithIgnoreCase

public final Condition startsWithIgnoreCase(Field<T> value)

Description copied from interface: Field

Convenience method for Field.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)

Specified by:

startsWithIgnoreCase in interface Field<T>

See Also:

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

endsWith

public final Condition endsWith(T value)

Description copied from interface: Field

Convenience method for Field.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)

Specified by:

endsWith in interface Field<T>

See Also:

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

endsWith

public final Condition endsWith(Field<T> value)

Description copied from interface: Field

Convenience method for Field.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)

Specified by:

endsWith in interface Field<T>

See Also:

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

endsWithIgnoreCase

public final Condition endsWithIgnoreCase(T value)

Description copied from interface: Field

Convenience method for Field.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)

Specified by:

endsWithIgnoreCase in interface Field<T>

See Also:

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

endsWithIgnoreCase

public final Condition endsWithIgnoreCase(Field<T> value)

Description copied from interface: Field

Convenience method for Field.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)

Specified by:

endsWithIgnoreCase in interface Field<T>

See Also:

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

in

public final Condition in(T... values)

Description copied from interface: Field

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

Specified by:

in in interface Field<T>

in

public final Condition in(Field<?>... values)

Description copied from interface: Field

Create a condition to check this field against several values.

SQL: this in (values...)

Specified by:

in in interface Field<T>

in

public final Condition in(Collection<?> values)

Description copied from interface: Field

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

Specified by:

in in interface Field<T>

in

public final Condition in(Result<? extends Record1<T>> result)

Description copied from interface: Field

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

Specified by:

in in interface Field<T>

in

public final Condition in(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

in in interface Field<T>

notIn

public final Condition notIn(T... values)

Description copied from interface: Field

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

Specified by:

notIn in interface Field<T>

notIn

public final Condition notIn(Field<?>... values)

Description copied from interface: Field

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

Specified by:

notIn in interface Field<T>

notIn

public final Condition notIn(Collection<?> values)

Description copied from interface: Field

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

Specified by:

notIn in interface Field<T>

notIn

public final Condition notIn(Result<? extends Record1<T>> result)

Description copied from interface: Field

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

Specified by:

notIn in interface Field<T>

notIn

public final Condition notIn(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

notIn in interface Field<T>

between

public final Condition between(T minValue,
 T maxValue)

Description copied from interface: Field

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

Specified by:

between in interface Field<T>

between

public final Condition between(Field<T> minValue,
 Field<T> maxValue)

Description copied from interface: Field

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

Specified by:

between in interface Field<T>

betweenSymmetric

public final Condition betweenSymmetric(T minValue,
 T maxValue)

Description copied from interface: Field

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

Specified by:

betweenSymmetric in interface Field<T>

betweenSymmetric

public final Condition betweenSymmetric(Field<T> minValue,
 Field<T> maxValue)

Description copied from interface: Field

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

Specified by:

betweenSymmetric in interface Field<T>

notBetween

public final Condition notBetween(T minValue,
 T maxValue)

Description copied from interface: Field

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

Specified by:

notBetween in interface Field<T>

notBetween

public final Condition notBetween(Field<T> minValue,
 Field<T> maxValue)

Description copied from interface: Field

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

Specified by:

notBetween in interface Field<T>

notBetweenSymmetric

public final Condition notBetweenSymmetric(T minValue,
 T maxValue)

Description copied from interface: Field

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

Specified by:

notBetweenSymmetric in interface Field<T>

notBetweenSymmetric

public final Condition notBetweenSymmetric(Field<T> minValue,
 Field<T> maxValue)

Description copied from interface: Field

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

Specified by:

notBetweenSymmetric in interface Field<T>

between

public final BetweenAndStep<T> between(T minValue)

Description copied from interface: Field

Create a condition to check this field against some bounds.

SQL: this between minValue and maxValue

Specified by:

between in interface Field<T>

between

public final BetweenAndStep<T> between(Field<T> minValue)

Description copied from interface: Field

Create a condition to check this field against some bounds.

SQL: this between minValue and maxValue

Specified by:

between in interface Field<T>

betweenSymmetric

public final BetweenAndStep<T> betweenSymmetric(T minValue)

Description copied from interface: Field

Create a condition to check this field against some bounds.

SQL: this between symmetric minValue and maxValue

Specified by:

betweenSymmetric in interface Field<T>

betweenSymmetric

public final BetweenAndStep<T> betweenSymmetric(Field<T> minValue)

Description copied from interface: Field

Create a condition to check this field against some bounds.

SQL: this between symmetric minValue and maxValue

Specified by:

betweenSymmetric in interface Field<T>

notBetween

public final BetweenAndStep<T> notBetween(T minValue)

Description copied from interface: Field

Create a condition to check this field against some bounds.

SQL: this not between minValue and maxValue

Specified by:

notBetween in interface Field<T>

notBetween

public final BetweenAndStep<T> notBetween(Field<T> minValue)

Description copied from interface: Field

Create a condition to check this field against some bounds.

SQL: this not between minValue and maxValue

Specified by:

notBetween in interface Field<T>

notBetweenSymmetric

public final BetweenAndStep<T> notBetweenSymmetric(T minValue)

Description copied from interface: Field

Create a condition to check this field against some bounds.

SQL: this not between symmetric minValue and maxValue

Specified by:

notBetweenSymmetric in interface Field<T>

notBetweenSymmetric

public final BetweenAndStep<T> notBetweenSymmetric(Field<T> minValue)

Description copied from interface: Field

Create a condition to check this field against some bounds.

SQL: this not between symmetric minValue and maxValue

Specified by:

notBetweenSymmetric in interface Field<T>

eq

public final Condition eq(T value)

Description copied from interface: Field

this = value.

Specified by:

eq in interface Field<T>

See Also:

Field.equal(Object)

eq

public final Condition eq(Field<T> field)

Description copied from interface: Field

this = field.

Specified by:

eq in interface Field<T>

See Also:

Field.equal(Field)

eq

public final Condition eq(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

eq in interface Field<T>

See Also:

Field.equal(Select)

eq

public final Condition eq(QuantifiedSelect<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

eq in interface Field<T>

See Also:

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

ne

public final Condition ne(T value)

Description copied from interface: Field

this != value.

Specified by:

ne in interface Field<T>

See Also:

Field.notEqual(Object)

ne

public final Condition ne(Field<T> field)

Description copied from interface: Field

this != field.

Specified by:

ne in interface Field<T>

See Also:

Field.notEqual(Field)

ne

public final Condition ne(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

ne in interface Field<T>

See Also:

Field.notEqual(Select)

ne

public final Condition ne(QuantifiedSelect<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

ne in interface Field<T>

See Also:

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

lt

public final Condition lt(T value)

Description copied from interface: Field

this < value.

Specified by:

lt in interface Field<T>

See Also:

Field.lessThan(Object)

lt

public final Condition lt(Field<T> field)

Description copied from interface: Field

this < field.

Specified by:

lt in interface Field<T>

See Also:

Field.lessThan(Field)

lt

public final Condition lt(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

lt in interface Field<T>

See Also:

Field.lessThan(Select)

lt

public final Condition lt(QuantifiedSelect<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

lt in interface Field<T>

See Also:

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

le

public final Condition le(T value)

Description copied from interface: Field

this <= value.

Specified by:

le in interface Field<T>

See Also:

Field.lessOrEqual(Object)

le

public final Condition le(Field<T> field)

Description copied from interface: Field

this <= field.

Specified by:

le in interface Field<T>

See Also:

Field.lessOrEqual(Field)

le

public final Condition le(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

le in interface Field<T>

See Also:

Field.lessOrEqual(Select)

le

public final Condition le(QuantifiedSelect<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

le in interface Field<T>

See Also:

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

gt

public final Condition gt(T value)

Description copied from interface: Field

this > value.

Specified by:

gt in interface Field<T>

See Also:

Field.greaterThan(Object)

gt

public final Condition gt(Field<T> field)

Description copied from interface: Field

this > field.

Specified by:

gt in interface Field<T>

See Also:

Field.greaterThan(Field)

gt

public final Condition gt(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

gt in interface Field<T>

See Also:

Field.greaterThan(Select)

gt

public final Condition gt(QuantifiedSelect<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

gt in interface Field<T>

See Also:

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

ge

public final Condition ge(T value)

Description copied from interface: Field

this >= value.

Specified by:

ge in interface Field<T>

See Also:

Field.greaterOrEqual(Object)

ge

public final Condition ge(Field<T> field)

Description copied from interface: Field

this >= field.

Specified by:

ge in interface Field<T>

See Also:

Field.greaterOrEqual(Field)

ge

public final Condition ge(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

ge in interface Field<T>

See Also:

Field.greaterOrEqual(Select)

ge

public final Condition ge(QuantifiedSelect<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

ge in interface Field<T>

See Also:

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

equal

public final Condition equal(T value)

Description copied from interface: Field

this = value.

Specified by:

equal in interface Field<T>

equal

public final Condition equal(Field<T> field)

Description copied from interface: Field

this = field.

Specified by:

equal in interface Field<T>

equalIgnoreCase

public final Condition equalIgnoreCase(String value)

Description copied from interface: Field

lower(this) = lower(value).

Specified by:

equalIgnoreCase in interface Field<T>

equalIgnoreCase

public final Condition equalIgnoreCase(Field<String> value)

Description copied from interface: Field

lower(this) = lower(value).

Specified by:

equalIgnoreCase in interface Field<T>

equal

public final Condition equal(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

equal in interface Field<T>

equal

public final Condition equal(QuantifiedSelect<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

equal in interface Field<T>

See Also:

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

notEqual

public final Condition notEqual(T value)

Description copied from interface: Field

this != value.

Specified by:

notEqual in interface Field<T>

notEqual

public final Condition notEqual(Field<T> field)

Description copied from interface: Field

this != field.

Specified by:

notEqual in interface Field<T>

notEqualIgnoreCase

public final Condition notEqualIgnoreCase(String value)

Description copied from interface: Field

lower(this) != lower(value).

Specified by:

notEqualIgnoreCase in interface Field<T>

notEqualIgnoreCase

public final Condition notEqualIgnoreCase(Field<String> value)

Description copied from interface: Field

lower(this) != lower(value).

Specified by:

notEqualIgnoreCase in interface Field<T>

notEqual

public final Condition notEqual(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

notEqual in interface Field<T>

notEqual

public final Condition notEqual(QuantifiedSelect<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

notEqual in interface Field<T>

See Also:

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

lessThan

public final Condition lessThan(T value)

Description copied from interface: Field

this < value.

Specified by:

lessThan in interface Field<T>

lessThan

public final Condition lessThan(Field<T> field)

Description copied from interface: Field

this < field.

Specified by:

lessThan in interface Field<T>

lessThan

public final Condition lessThan(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

lessThan in interface Field<T>

lessThan

public final Condition lessThan(QuantifiedSelect<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

lessThan in interface Field<T>

See Also:

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

lessOrEqual

public final Condition lessOrEqual(T value)

Description copied from interface: Field

this <= value.

Specified by:

lessOrEqual in interface Field<T>

lessOrEqual

public final Condition lessOrEqual(Field<T> field)

Description copied from interface: Field

this <= field.

Specified by:

lessOrEqual in interface Field<T>

lessOrEqual

public final Condition lessOrEqual(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

lessOrEqual in interface Field<T>

lessOrEqual

public final Condition lessOrEqual(QuantifiedSelect<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

lessOrEqual in interface Field<T>

See Also:

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

greaterThan

public final Condition greaterThan(T value)

Description copied from interface: Field

this > value.

Specified by:

greaterThan in interface Field<T>

greaterThan

public final Condition greaterThan(Field<T> field)

Description copied from interface: Field

this > field.

Specified by:

greaterThan in interface Field<T>

greaterThan

public final Condition greaterThan(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

greaterThan in interface Field<T>

greaterThan

public final Condition greaterThan(QuantifiedSelect<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

greaterThan in interface Field<T>

See Also:

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

greaterOrEqual

public final Condition greaterOrEqual(T value)

Description copied from interface: Field

this >= value.

Specified by:

greaterOrEqual in interface Field<T>

greaterOrEqual

public final Condition greaterOrEqual(Field<T> field)

Description copied from interface: Field

this >= field.

Specified by:

greaterOrEqual in interface Field<T>

greaterOrEqual

public final Condition greaterOrEqual(Select<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

greaterOrEqual in interface Field<T>

greaterOrEqual

public final Condition greaterOrEqual(QuantifiedSelect<? extends Record1<T>> query)

Description copied from interface: Field

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

Specified by:

greaterOrEqual in interface Field<T>

See Also:

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

compare

public final Condition compare(Comparator comparator,
 T value)

Description copied from interface: Field

Compare this field with a value using a dynamic comparator.

Specified by:

compare in interface Field<T>

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

public final Condition compare(Comparator comparator,
 Field<T> field)

Description copied from interface: Field

Compare this field with another field using a dynamic comparator.

Specified by:

compare in interface Field<T>

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

public final Condition compare(Comparator comparator,
 Select<? extends Record1<T>> query)

Description copied from interface: Field

Compare this field with a subselect using a dynamic comparator.

Consider Comparator.supportsSubselect() to assess whether a comparator can be used with this method.

Specified by:

compare in interface Field<T>

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

public final Condition compare(Comparator comparator,
 QuantifiedSelect<? extends Record1<T>> query)

Description copied from interface: Field

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.

Specified by:

compare in interface Field<T>

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

plus

@Pro
public final Field<T> plus()

Description copied from interface: Field

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(+)
 

Specified by:

plus in interface Field<T>

sign

@Deprecated
public final Field<Integer> sign()

Deprecated.

Specified by:

sign in interface Field<T>

See Also:

DSL.sign(Field)

abs

@Deprecated
public final Field<T> abs()

Deprecated.

Specified by:

abs in interface Field<T>

See Also:

DSL.abs(Field)

round

@Deprecated
public final Field<T> round()

Deprecated.

Specified by:

round in interface Field<T>

See Also:

DSL.round(Field)

round

@Deprecated
public final Field<T> round(int decimals)

Deprecated.

Specified by:

round in interface Field<T>

See Also:

DSL.round(Field, int)

floor

@Deprecated
public final Field<T> floor()

Deprecated.

Specified by:

floor in interface Field<T>

See Also:

DSL.floor(Field)

ceil

@Deprecated
public final Field<T> ceil()

Deprecated.

Specified by:

ceil in interface Field<T>

See Also:

DSL.ceil(Field)

sqrt

@Deprecated
public final Field<BigDecimal> sqrt()

Deprecated.

Specified by:

sqrt in interface Field<T>

See Also:

DSL.sqrt(Field)

exp

@Deprecated
public final Field<BigDecimal> exp()

Deprecated.

Specified by:

exp in interface Field<T>

See Also:

DSL.exp(Field)

ln

@Deprecated
public final Field<BigDecimal> ln()

Deprecated.

Specified by:

ln in interface Field<T>

See Also:

DSL.ln(Field)

log

@Deprecated
public final Field<BigDecimal> log(int base)

Deprecated.

Specified by:

log in interface Field<T>

See Also:

DSL.log(Field, int)

pow

public final Field<BigDecimal> pow(Number exponent)

Description copied from interface: Field

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])

Specified by:

pow in interface Field<T>

See Also:

DSL.power(Field, Number)

power

public final Field<BigDecimal> power(Number exponent)

Description copied from interface: Field

An alias for Field.power(Number).

Specified by:

power in interface Field<T>

See Also:

Field.power(Number)

pow

public final Field<BigDecimal> pow(Field<? extends Number> exponent)

Description copied from interface: Field

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])

Specified by:

pow in interface Field<T>

See Also:

DSL.power(Field, Field)

power

public final Field<BigDecimal> power(Field<? extends Number> exponent)

Description copied from interface: Field

An alias for Field.power(Field).

Specified by:

power in interface Field<T>

See Also:

Field.power(Field)

acos

@Deprecated
public final Field<BigDecimal> acos()

Deprecated.

Specified by:

acos in interface Field<T>

See Also:

DSL.acos(Field)

asin

@Deprecated
public final Field<BigDecimal> asin()

Deprecated.

Specified by:

asin in interface Field<T>

See Also:

DSL.asin(Field)

atan

@Deprecated
public final Field<BigDecimal> atan()

Deprecated.

Specified by:

atan in interface Field<T>

See Also:

DSL.atan(Field)

atan2

@Deprecated
public final Field<BigDecimal> atan2(Number y)

Deprecated.

Specified by:

atan2 in interface Field<T>

See Also:

DSL.atan2(Field, Number)

atan2

@Deprecated
public final Field<BigDecimal> atan2(Field<? extends Number> y)

Deprecated.

Specified by:

atan2 in interface Field<T>

See Also:

DSL.atan2(Field, Field)

cos

@Deprecated
public final Field<BigDecimal> cos()

Deprecated.

Specified by:

cos in interface Field<T>

See Also:

DSL.cos(Field)

sin

@Deprecated
public final Field<BigDecimal> sin()

Deprecated.

Specified by:

sin in interface Field<T>

See Also:

DSL.sin(Field)

tan

@Deprecated
public final Field<BigDecimal> tan()

Deprecated.

Specified by:

tan in interface Field<T>

See Also:

DSL.tan(Field)

cot

@Deprecated
public final Field<BigDecimal> cot()

Deprecated.

Specified by:

cot in interface Field<T>

See Also:

DSL.cot(Field)

sinh

@Deprecated
public final Field<BigDecimal> sinh()

Deprecated.

Specified by:

sinh in interface Field<T>

See Also:

DSL.sinh(Field)

cosh

@Deprecated
public final Field<BigDecimal> cosh()

Deprecated.

Specified by:

cosh in interface Field<T>

See Also:

DSL.cosh(Field)

tanh

@Deprecated
public final Field<BigDecimal> tanh()

Deprecated.

Specified by:

tanh in interface Field<T>

See Also:

DSL.tanh(Field)

coth

@Deprecated
public final Field<BigDecimal> coth()

Deprecated.

Specified by:

coth in interface Field<T>

See Also:

DSL.coth(Field)

deg

@Deprecated
public final Field<BigDecimal> deg()

Deprecated.

Specified by:

deg in interface Field<T>

See Also:

DSL.deg(Field)

rad

@Deprecated
public final Field<BigDecimal> rad()

Deprecated.

Specified by:

rad in interface Field<T>

See Also:

DSL.rad(Field)

count

@Deprecated
public final Field<Integer> count()

Deprecated.

Specified by:

count in interface Field<T>

See Also:

DSL.count(Field)

countDistinct

@Deprecated
public final Field<Integer> countDistinct()

Deprecated.

Specified by:

countDistinct in interface Field<T>

See Also:

DSL.countDistinct(Field)

max

@Deprecated
public final Field<T> max()

Deprecated.

Specified by:

max in interface Field<T>

See Also:

DSL.max(Field)

min

@Deprecated
public final Field<T> min()

Deprecated.

Specified by:

min in interface Field<T>

See Also:

DSL.min(Field)

sum

@Deprecated
public final Field<BigDecimal> sum()

Deprecated.

Specified by:

sum in interface Field<T>

See Also:

DSL.sum(Field)

avg

@Deprecated
public final Field<BigDecimal> avg()

Deprecated.

Specified by:

avg in interface Field<T>

See Also:

DSL.avg(Field)

median

@Deprecated
public final Field<BigDecimal> median()

Deprecated.

Specified by:

median in interface Field<T>

See Also:

DSL.median(Field)

stddevPop

@Deprecated
public final Field<BigDecimal> stddevPop()

Deprecated.

Specified by:

stddevPop in interface Field<T>

See Also:

DSL.stddevPop(Field)

stddevSamp

@Deprecated
public final Field<BigDecimal> stddevSamp()

Deprecated.

Specified by:

stddevSamp in interface Field<T>

See Also:

DSL.stddevSamp(Field)

varPop

@Deprecated
public final Field<BigDecimal> varPop()

Deprecated.

Specified by:

varPop in interface Field<T>

See Also:

DSL.varPop(Field)

varSamp

@Deprecated
public final Field<BigDecimal> varSamp()

Deprecated.

Specified by:

varSamp in interface Field<T>

See Also:

DSL.varSamp(Field)

countOver

@Deprecated
public final WindowPartitionByStep<Integer> countOver()

Deprecated.

Specified by:

countOver in interface Field<T>

See Also:

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

maxOver

@Deprecated
public final WindowPartitionByStep<T> maxOver()

Deprecated.

Specified by:

maxOver in interface Field<T>

See Also:

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

minOver

@Deprecated
public final WindowPartitionByStep<T> minOver()

Deprecated.

Specified by:

minOver in interface Field<T>

See Also:

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

sumOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> sumOver()

Deprecated.

Specified by:

sumOver in interface Field<T>

See Also:

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

avgOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> avgOver()

Deprecated.

Specified by:

avgOver in interface Field<T>

See Also:

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

firstValue

@Deprecated
public final WindowIgnoreNullsStep<T> firstValue()

Deprecated.

Specified by:

firstValue in interface Field<T>

See Also:

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

lastValue

@Deprecated
public final WindowIgnoreNullsStep<T> lastValue()

Deprecated.

Specified by:

lastValue in interface Field<T>

See Also:

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

lead

@Deprecated
public final WindowIgnoreNullsStep<T> lead()

Deprecated.

Specified by:

lead in interface Field<T>

See Also:

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

lead

@Deprecated
public final WindowIgnoreNullsStep<T> lead(int offset)

Deprecated.

Specified by:

lead in interface Field<T>

See Also:

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

lead

@Deprecated
public final WindowIgnoreNullsStep<T> lead(int offset,
 T defaultValue)

Deprecated.

Specified by:

lead in interface Field<T>

See Also:

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

lead

@Deprecated
public final WindowIgnoreNullsStep<T> lead(int offset,
 Field<T> defaultValue)

Deprecated.

Specified by:

lead in interface Field<T>

See Also:

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

lag

@Deprecated
public final WindowIgnoreNullsStep<T> lag()

Deprecated.

Specified by:

lag in interface Field<T>

See Also:

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

lag

@Deprecated
public final WindowIgnoreNullsStep<T> lag(int offset)

Deprecated.

Specified by:

lag in interface Field<T>

See Also:

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

lag

@Deprecated
public final WindowIgnoreNullsStep<T> lag(int offset,
 T defaultValue)

Deprecated.

Specified by:

lag in interface Field<T>

See Also:

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

lag

@Deprecated
public final WindowIgnoreNullsStep<T> lag(int offset,
 Field<T> defaultValue)

Deprecated.

Specified by:

lag in interface Field<T>

See Also:

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

stddevPopOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> stddevPopOver()

Deprecated.

Specified by:

stddevPopOver in interface Field<T>

See Also:

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

stddevSampOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> stddevSampOver()

Deprecated.

Specified by:

stddevSampOver in interface Field<T>

See Also:

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

varPopOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> varPopOver()

Deprecated.

Specified by:

varPopOver in interface Field<T>

See Also:

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

varSampOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> varSampOver()

Deprecated.

Specified by:

varSampOver in interface Field<T>

See Also:

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

upper

@Deprecated
public final Field<String> upper()

Deprecated.

Description copied from interface: Field

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

Specified by:

upper in interface Field<T>

See Also:

DSL.upper(Field)

lower

@Deprecated
public final Field<String> lower()

Deprecated.

Description copied from interface: Field

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

Specified by:

lower in interface Field<T>

See Also:

DSL.lower(Field)

trim

@Deprecated
public final Field<String> trim()

Deprecated.

Description copied from interface: Field

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

Specified by:

trim in interface Field<T>

See Also:

DSL.trim(Field)

rtrim

@Deprecated
public final Field<String> rtrim()

Deprecated.

Description copied from interface: Field

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

Specified by:

rtrim in interface Field<T>

See Also:

DSL.rtrim(Field)

ltrim

@Deprecated
public final Field<String> ltrim()

Deprecated.

Description copied from interface: Field

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

Specified by:

ltrim in interface Field<T>

See Also:

DSL.ltrim(Field)

rpad

@Deprecated
public final Field<String> rpad(Field<? extends Number> length)

Deprecated.

Description copied from interface: Field

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

Specified by:

rpad in interface Field<T>

See Also:

DSL.rpad(Field, Field)

rpad

@Deprecated
public final Field<String> rpad(int length)

Deprecated.

Description copied from interface: Field

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

Specified by:

rpad in interface Field<T>

See Also:

DSL.rpad(Field, int)

rpad

@Deprecated
public final Field<String> rpad(Field<? extends Number> length,
 Field<String> character)

Deprecated.

Description copied from interface: Field

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

Specified by:

rpad in interface Field<T>

See Also:

DSL.rpad(Field, Field, Field)

rpad

@Deprecated
public final Field<String> rpad(int length,
 char character)

Deprecated.

Description copied from interface: Field

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

Specified by:

rpad in interface Field<T>

See Also:

DSL.rpad(Field, int, char)

lpad

@Deprecated
public final Field<String> lpad(Field<? extends Number> length)

Deprecated.

Description copied from interface: Field

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

Specified by:

lpad in interface Field<T>

See Also:

DSL.lpad(Field, Field)

lpad

@Deprecated
public final Field<String> lpad(int length)

Deprecated.

Description copied from interface: Field

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

Specified by:

lpad in interface Field<T>

See Also:

DSL.lpad(Field, int)

lpad

@Deprecated
public final Field<String> lpad(Field<? extends Number> length,
 Field<String> character)

Deprecated.

Description copied from interface: Field

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

Specified by:

lpad in interface Field<T>

See Also:

DSL.lpad(Field, Field, Field)

lpad

@Deprecated
public final Field<String> lpad(int length,
 char character)

Deprecated.

Description copied from interface: Field

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

Specified by:

lpad in interface Field<T>

See Also:

DSL.lpad(Field, int, char)

repeat

@Deprecated
public final Field<String> repeat(Number count)

Deprecated.

Description copied from interface: Field

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

Specified by:

repeat in interface Field<T>

See Also:

DSL.repeat(Field, int)

repeat

@Deprecated
public final Field<String> repeat(Field<? extends Number> count)

Deprecated.

Description copied from interface: Field

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

Specified by:

repeat in interface Field<T>

See Also:

DSL.repeat(Field, Field)

replace

@Deprecated
public final Field<String> replace(Field<String> search)

Deprecated.

Description copied from interface: Field

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

Specified by:

replace in interface Field<T>

See Also:

DSL.replace(Field, Field)

replace

@Deprecated
public final Field<String> replace(String search)

Deprecated.

Description copied from interface: Field

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

Specified by:

replace in interface Field<T>

See Also:

DSL.replace(Field, String)

replace

@Deprecated
public final Field<String> replace(Field<String> search,
 Field<String> replace)

Deprecated.

Description copied from interface: Field

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

Specified by:

replace in interface Field<T>

See Also:

DSL.replace(Field, Field, Field)

replace

@Deprecated
public final Field<String> replace(String search,
 String replace)

Deprecated.

Description copied from interface: Field

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

Specified by:

replace in interface Field<T>

See Also:

DSL.replace(Field, String, String)

position

@Deprecated
public final Field<Integer> position(String search)

Deprecated.

Description copied from interface: Field

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

Specified by:

position in interface Field<T>

See Also:

DSL.position(Field, String)

position

@Deprecated
public final Field<Integer> position(Field<String> search)

Deprecated.

Description copied from interface: Field

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

Specified by:

position in interface Field<T>

See Also:

DSL.position(Field, Field)

ascii

@Deprecated
public final Field<Integer> ascii()

Deprecated.

Description copied from interface: Field

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

Specified by:

ascii in interface Field<T>

See Also:

DSL.ascii(Field)

collate

public final Field<String> collate(String collation)

Description copied from interface: Field

Apply a collation operator to this column expression.

Specified by:

collate in interface Field<T>

See Also:

DSL.collation(String)

collate

public final Field<String> collate(Name collation)

Description copied from interface: Field

Apply a collation operator to this column expression.

Specified by:

collate in interface Field<T>

See Also:

DSL.collation(Name)

collate

public final Field<String> collate(Collation collation)

Description copied from interface: Field

Apply a collation operator to this column expression.

Specified by:

collate in interface Field<T>

concat

@Deprecated
public final Field<String> concat(Field<?>... fields)

Deprecated.

Description copied from interface: Field

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

Specified by:

concat in interface Field<T>

See Also:

DSL.concat(Field...)

concat

@Deprecated
public final Field<String> concat(String... values)

Deprecated.

Description copied from interface: Field

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

Specified by:

concat in interface Field<T>

See Also:

DSL.concat(String...)

concat

public final Field<String> concat(char... values)

Description copied from interface: Field

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

Specified by:

concat in interface Field<T>

See Also:

DSL.concat(String...)

substring

@Deprecated
public final Field<String> substring(int startingPosition)

Deprecated.

Description copied from interface: Field

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

Specified by:

substring in interface Field<T>

See Also:

DSL.substring(Field, int)

substring

@Deprecated
public final Field<String> substring(Field<? extends Number> startingPosition)

Deprecated.

Description copied from interface: Field

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

Specified by:

substring in interface Field<T>

See Also:

DSL.substring(Field, Field)

substring

@Deprecated
public final Field<String> substring(int startingPosition,
 int length)

Deprecated.

Description copied from interface: Field

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

Specified by:

substring in interface Field<T>

See Also:

DSL.substring(Field, int, int)

substring

@Deprecated
public final Field<String> substring(Field<? extends Number> startingPosition,
 Field<? extends Number> length)

Deprecated.

Description copied from interface: Field

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

Specified by:

substring in interface Field<T>

See Also:

DSL.substring(Field, Field, Field)

length

@Deprecated
public final Field<Integer> length()

Deprecated.

Description copied from interface: Field

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

Specified by:

length in interface Field<T>

See Also:

DSL.length(Field)

charLength

@Deprecated
public final Field<Integer> charLength()

Deprecated.

Description copied from interface: Field

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

Specified by:

charLength in interface Field<T>

See Also:

DSL.charLength(Field)

bitLength

@Deprecated
public final Field<Integer> bitLength()

Deprecated.

Description copied from interface: Field

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

Specified by:

bitLength in interface Field<T>

See Also:

DSL.bitLength(Field)

octetLength

@Deprecated
public final Field<Integer> octetLength()

Deprecated.

Description copied from interface: Field

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

Specified by:

octetLength in interface Field<T>

See Also:

DSL.octetLength(Field)

extract

@Deprecated
public final Field<Integer> extract(DatePart datePart)

Deprecated.

Specified by:

extract in interface Field<T>

See Also:

DSL.extract(Field, DatePart)

greatest

@Deprecated
@SafeVarargs
public final Field<T> greatest(T... others)

Deprecated.

Specified by:

greatest in interface Field<T>

See Also:

DSL.greatest(Field, Field...)

greatest

@Deprecated
public final Field<T> greatest(Field<?>... others)

Deprecated.

Specified by:

greatest in interface Field<T>

See Also:

DSL.greatest(Field, Field...)

least

@Deprecated
@SafeVarargs
public final Field<T> least(T... others)

Deprecated.

Specified by:

least in interface Field<T>

See Also:

DSL.least(Field, Field...)

least

@Deprecated
public final Field<T> least(Field<?>... others)

Deprecated.

Specified by:

least in interface Field<T>

See Also:

DSL.least(Field, Field...)

nvl

@Deprecated
public final Field<T> nvl(T defaultValue)

Deprecated.

Description copied from interface: Field

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

Specified by:

nvl in interface Field<T>

See Also:

DSL.nvl(Field, Object)

nvl

@Deprecated
public final Field<T> nvl(Field<T> defaultValue)

Deprecated.

Description copied from interface: Field

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

Specified by:

nvl in interface Field<T>

See Also:

DSL.nvl(Field, Field)

nvl2

@Deprecated
public final <Z> Field<Z> nvl2(Z valueIfNotNull,
 Z valueIfNull)

Deprecated.

Description copied from interface: Field

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

Specified by:

nvl2 in interface Field<T>

See Also:

DSL.nvl2(Field, Object, Object)

nvl2

@Deprecated
public final <Z> Field<Z> nvl2(Field<Z> valueIfNotNull,
 Field<Z> valueIfNull)

Deprecated.

Description copied from interface: Field

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

Specified by:

nvl2 in interface Field<T>

See Also:

DSL.nvl2(Field, Field, Field)

nullif

@Deprecated
public final Field<T> nullif(T other)

Deprecated.

Description copied from interface: Field

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

Specified by:

nullif in interface Field<T>

See Also:

DSL.nullif(Field, Object)

nullif

@Deprecated
public final Field<T> nullif(Field<T> other)

Deprecated.

Description copied from interface: Field

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

Specified by:

nullif in interface Field<T>

See Also:

DSL.nullif(Field, Field)

decode

@Deprecated
public final <Z> Field<Z> decode(T search,
 Z result)

Deprecated.

Description copied from interface: Field

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

Specified by:

decode in interface Field<T>

See Also:

DSL.decode(Object, Object, Object)

decode

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

Deprecated.

Description copied from interface: Field

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

Specified by:

decode in interface Field<T>

See Also:

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

decode

@Deprecated
public final <Z> Field<Z> decode(Field<T> search,
 Field<Z> result)

Deprecated.

Description copied from interface: Field

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

Specified by:

decode in interface Field<T>

See Also:

DSL.decode(Field, Field, Field)

decode

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

Deprecated.

Description copied from interface: Field

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

Specified by:

decode in interface Field<T>

See Also:

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

coalesce

@Deprecated
@SafeVarargs
public final Field<T> coalesce(T option,
 T... options)

Deprecated.

Description copied from interface: Field

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

Specified by:

coalesce in interface Field<T>

See Also:

DSL.coalesce(Object, Object...)

coalesce

@Deprecated
public final Field<T> coalesce(Field<T> option,
 Field<?>... options)

Deprecated.

Description copied from interface: Field

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

Specified by:

coalesce in interface Field<T>

See Also:

DSL.coalesce(Field, Field...)

getConverter

public final Converter<?,T> getConverter()

Description copied from interface: Typed

The object's underlying Converter.

By default, all typed objects reference an identity-converter Converter<T, T>. If an implementation is generated, custom data types may be obtained by a custom Converter placed on the generated object.

Specified by:

getConverter in interface Typed<T>

getBinding

public final Binding<?,T> getBinding()

Description copied from interface: Typed

The object's underlying Binding.

Specified by:

getBinding in interface Typed<T>

getType

public final Class<T> getType()

Description copied from interface: Typed

The Java type of the object.

Specified by:

getType in interface Typed<T>

getDataType

public final DataType<T> getDataType()

Description copied from interface: Typed

The type of this object (might not be dialect-specific).

Specified by:

getDataType in interface Typed<T>

getDataType

public final DataType<T> getDataType(Configuration configuration)

Description copied from interface: Typed

The dialect-specific type of this object.

Specified by:

getDataType in interface Typed<T>

getName

public final String getName()

Description copied from interface: Named

The unqualified name of this object.

Specified by:

getName in interface Named

getQualifiedName

public Name getQualifiedName()

Description copied from interface: Named

The qualified name of this object.

Specified by:

getQualifiedName in interface Named

getUnqualifiedName

public final Name getUnqualifiedName()

Description copied from interface: Named

The unqualified name of this object.

Specified by:

getUnqualifiedName in interface Named

getComment

public final String getComment()

Description copied from interface: Named

The comment on this object.

This is the same as calling Named.getCommentPart() and then Comment.getComment().

Specified by:

getComment in interface Named

getCommentPart

public final Comment getCommentPart()

Description copied from interface: Named

The comment on this object as a QueryPart.

Specified by:

getCommentPart in interface Named

hashCode

public int hashCode()

Description copied from interface: QueryPart

Generate a hash code from this QueryPart.

In general, QueryPart hash codes are the same as the hash codes generated from QueryPart.toString(). This guarantees consistent behaviour with QueryPart.equals(Object)

Some QueryPart implementations may choose to override this behaviour for improved performance, as QueryPart.toString() is an expensive operation, if called many times.

Specified by:

hashCode in interface QueryPart

Returns:

The QueryPart hash code

equals

public boolean equals(Object that)

Description copied from interface: QueryPart

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.

Specified by:

equals in interface QueryPart

Parameters:

that - The other QueryPart

Returns:

Whether the two query parts are equal

rendersContent

public boolean rendersContent(Context<?> ctx)

Subclasses may override this

Specified by:

rendersContent in interface QueryPartInternal

declaresWindows

public boolean declaresWindows()

Subclasses may override this

Specified by:

declaresWindows in interface QueryPartInternal

declaresCTE

public boolean declaresCTE()

Subclasses may override this

Specified by:

declaresCTE in interface QueryPartInternal

declaresParameters

@Pro
public boolean declaresParameters()

Subclasses may override this

Specified by:

declaresParameters in interface QueryPartInternal

generatesCast

public boolean generatesCast()

Subclasses may override this

Specified by:

generatesCast in interface QueryPartInternal

toString

public String toString()

Description copied from interface: QueryPart

Render a SQL string representation of this QueryPart.

For improved debugging, this renders a SQL string of this QueryPart with inlined bind variables. If this QueryPart is Attachable, then the attached Configuration may be used for rendering the SQL string, including SQLDialect and Settings. Do note that most QueryPart instances are not attached to a Configuration, and thus there is no guarantee that the SQL string will make sense in the context of a specific database.

Specified by:

toString in interface QueryPart

Overrides:

toString in class Object

Returns:

A SQL string representation of this QueryPart

create

@Deprecated
protected final DSLContext create()

Deprecated.

- 3.11.0 - [#6722] - Use Attachable.configuration() and Configuration.dsl() instead.

Internal convenience method

create

@Deprecated
protected final DSLContext create(Configuration configuration)

Deprecated.

- 3.11.0 - [#6722] - Use Attachable.configuration() and Configuration.dsl() instead.

Internal convenience method

create

@Deprecated
protected final DSLContext create(Context<?> ctx)

Deprecated.

- 3.11.0 - [#6722] - Use Attachable.configuration() and Configuration.dsl() instead.

Internal convenience method

translate

protected final DataAccessException translate(String sql,
 SQLException e)

Internal convenience method