org.jooq.impl
Class CustomField<T>

java.lang.Object
  org.jooq.impl.CustomField<T>

All Implemented Interfaces:

Serializable, Comparable<NamedQueryPart>, Adapter, AliasProvider<Field<T>>, Attachable, AttachableInternal, Field<T>, NamedQueryPart, NamedTypeProviderQueryPart<T>, QueryPart, QueryPartInternal

public abstract class CustomField<T>
extends Object

A base class for custom Field implementations in client code.

Client code may provide proper Field implementations extending this useful base class. All necessary parts of the Field interface are already implemented. Only these two methods need further implementation:

• toSQL(org.jooq.RenderContext)
• bind(org.jooq.BindContext)

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

Author:

Lukas Eder

See Also:

Serialized Form

Constructor Summary

protected

CustomField(String name, DataType<T> type)

Method Summary

Field<T>	abs() Deprecated.
Field<BigDecimal>	acos() Deprecated.
Field<T>	add(Field<?> value) This default implementation is known to be overridden by Expression to generate neater expressions
Field<T>	add(Number value) An arithmetic expression adding this to value.
Field<T>	as(String 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(Field<? extends Number> y) Deprecated.
Field<BigDecimal>	atan2(Number y) Deprecated.
void	attach(Configuration configuration) Subclasses may further override this method By default, nothing is done on an attachment event.
Field<BigDecimal>	avg() Deprecated.
WindowPartitionByStep<BigDecimal>	avgOver() Deprecated.
Condition	between(Field<T> minValue, Field<T> maxValue) Create a condition to check this field against some bounds SQL: this between minValue and maxValue
Condition	between(T minValue, T maxValue) Create a condition to check this field against some bounds SQL: this between minValue and maxValue
abstract void	bind(BindContext context) Subclasses must implement this method Bind all parameters of this QueryPart to a PreparedStatement This method is for JOOQ INTERNAL USE only.
Field<Integer>	bitLength() Deprecated.
<Z> Field<Z>	cast(Class<? extends Z> type) Cast this field to another type The actual cast may not be accurate as the DataType has to be "guessed" from the jOOQ-configured data types.
<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.
Field<Integer>	charLength() Deprecated.
Field<T>	coalesce(Field<T> option, Field<?>... options) Deprecated.
Field<T>	coalesce(T option, T... options) Deprecated.
int	compareTo(NamedQueryPart that)
Field<String>	concat(Field<?>... fields) Deprecated.
Field<String>	concat(String... values) Deprecated.
Condition	contains(Field<T> value) 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.
Condition	contains(T value) 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.
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 Factory	create() Internal convenience method
protected Factory	create(Configuration configuration) Internal convenience method
boolean	declaresFields() Subclasses may override this
boolean	declaresTables() 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(Field<? extends Number> value) An arithmetic expression dividing this by value If this is a numeric field, then the result is a number of the same type as this field.
Field<T>	div(Number value) An arithmetic expression dividing this by value If this is a numeric field, then the result is a number of the same type as this field.
Condition	endsWith(Field<T> value) 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)
Condition	endsWith(T value) 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)
Condition	equal(Field<T> field) this = field
Condition	equal(Select<?> query) this = (Select
Condition	equal(T value) this = value If value == null, then this will return a condition equivalent to Field.isNull() for convenience.
Condition	equalAll(Field<T[]> array) this = all (array) This is natively supported by SQLDialect.POSTGRES.
Condition	equalAll(Select<?> query) this = all (Select
Condition	equalAll(T... array) this = all (array) This is natively supported by SQLDialect.POSTGRES.
Condition	equalAny(Field<T[]> array) this = any (array) This is natively supported by SQLDialect.POSTGRES.
Condition	equalAny(Select<?> query) this = any (Select
Condition	equalAny(T... array) this = any (array) This is natively supported by SQLDialect.POSTGRES.
Condition	equalIgnoreCase(Field<String> value) lower(this) = lower(value)
Condition	equalIgnoreCase(String value) lower(this) = lower(value)
boolean	equals(Object that)
Condition	equalSome(Select<?> query) Deprecated.
Field<BigDecimal>	exp() Deprecated.
Field<Integer>	extract(DatePart datePart) Deprecated.
WindowIgnoreNullsStep<T>	firstValue() Deprecated.
Field<T>	floor() Deprecated.
List<Attachable>	getAttachables() Subclasses may further override this method Get the list of dependent Attachables This method is for JOOQ INTERNAL USE only.
protected List<Attachable>	getAttachables(Collection<? extends QueryPart> list) Internal convenience method
protected List<Attachable>	getAttachables(QueryPart... list) Internal convenience method
protected List<Attachable>	getAttachables(Store<?> store) Internal convenience method
List<Object>	getBindValues() This method is also declared as Query.getBindValues() Retrieve the bind values that will be bound by this QueryPart This method is exposed publicly in Query.getBindValues()
Configuration	getConfiguration() Get the underlying configuration
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
SQLDialect	getDialect() Deprecated.
String	getName() The name of this query part
Param<?>	getParam(String name) This method is also declared as Query.getParam(String) Retrieve a named parameter that will be bound by this QueryPart This method is exposed publicly in Query.getParam(String)
Map<String,Param<?>>	getParams() This method is also declared as Query.getParams() Retrieve the named parameters that will be bound by this QueryPart This method is exposed publicly in Query.getParams()
String	getSQL() This method is also declared as Query.getSQL() Retrieve the SQL that will be rendered by this QueryPart This method is exposed publicly in Query.getSQL()
String	getSQL(boolean inline) This method is also declared as Query.getSQL(boolean) Retrieve the SQL that will be rendered by this QueryPart This method is exposed publicly in Query.getSQL(boolean)
protected SQLDataType<T>	getSQLDataType()
Class<? extends T>	getType() The type of this object
Condition	greaterOrEqual(Field<T> field) this >= field
Condition	greaterOrEqual(Select<?> query) this >= (Select
Condition	greaterOrEqual(T value) this >= value
Condition	greaterOrEqualAll(Field<T[]> array) this >= all (array) This is natively supported by SQLDialect.POSTGRES.
Condition	greaterOrEqualAll(Select<?> query) this >= all (Select
Condition	greaterOrEqualAll(T... array) this >= all (array) This is natively supported by SQLDialect.POSTGRES.
Condition	greaterOrEqualAny(Field<T[]> array) this >= any (array) This is natively supported by SQLDialect.POSTGRES.
Condition	greaterOrEqualAny(Select<?> query) this >= any (Select
Condition	greaterOrEqualAny(T... array) this >= any (array) This is natively supported by SQLDialect.POSTGRES.
Condition	greaterOrEqualSome(Select<?> query) Deprecated.
Condition	greaterThan(Field<T> field) this > field
Condition	greaterThan(Select<?> query) this > (Select
Condition	greaterThan(T value) this > value
Condition	greaterThanAll(Field<T[]> array) this > all (array) This is natively supported by SQLDialect.POSTGRES.
Condition	greaterThanAll(Select<?> query) this > all (Select
Condition	greaterThanAll(T... array) this > all (array) This is natively supported by SQLDialect.POSTGRES.
Condition	greaterThanAny(Field<T[]> array) this > any (array) This is natively supported by SQLDialect.POSTGRES.
Condition	greaterThanAny(Select<?> query) this > any (Select
Condition	greaterThanAny(T... array) this > any (array) This is natively supported by SQLDialect.POSTGRES.
Condition	greaterThanSome(Select<?> query) Deprecated.
Field<T>	greatest(Field<?>... others) Deprecated.
Field<T>	greatest(T... others) Deprecated.
int	hashCode()
Condition	in(Collection<T> values) Create a condition to check this field against several values SQL: this in (values...)
Condition	in(Field<?>... values) Create a condition to check this field against several values SQL: this in (values...)
Condition	in(Select<?> query) Create a condition to check this field against a subquery Note that the subquery must return exactly one field.
Condition	in(T... values) Create a condition to check this field against several values SQL: this in (values...)
<I> I	internalAPI(Class<I> internalType) Adapt to an internal type assuming its functionality This is for JOOQ INTERNAL USE only.
Condition	isFalse() Create a condition to check this field against known string literals for false SQL: lcase(this) in ("0", "n", "no", "false", "off", "disabled")
Condition	isNotNull() Create a condition to check this field against null.
Condition	isNull() Create a condition to check this field against null.
boolean	isNullLiteral() Subclasses may further override this method Whether this field represents a null literal.
Condition	isTrue() Create a condition to check this field against known string literals for true SQL: lcase(this) in ("1", "y", "yes", "true", "on", "enabled")
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.
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(Select<?> query) this <= (Select
Condition	lessOrEqual(T value) this <= value
Condition	lessOrEqualAll(Field<T[]> array) this <= all (array) This is natively supported by SQLDialect.POSTGRES.
Condition	lessOrEqualAll(Select<?> query) this <= all (Select
Condition	lessOrEqualAll(T... array) this <= all (array) This is natively supported by SQLDialect.POSTGRES.
Condition	lessOrEqualAny(Field<T[]> array) this <= any (array) This is natively supported by SQLDialect.POSTGRES.
Condition	lessOrEqualAny(Select<?> query) this <= any (Select
Condition	lessOrEqualAny(T... array) this <= any (array) This is natively supported by SQLDialect.POSTGRES.
Condition	lessOrEqualSome(Select<?> query) Deprecated.
Condition	lessThan(Field<T> field) this < field
Condition	lessThan(Select<?> query) this < (Select
Condition	lessThan(T value) this < value
Condition	lessThanAll(Field<T[]> array) this < all (array) This is natively supported by SQLDialect.POSTGRES.
Condition	lessThanAll(Select<?> query) this < all (Select
Condition	lessThanAll(T... array) this < all (array) This is natively supported by SQLDialect.POSTGRES.
Condition	lessThanAny(Field<T[]> array) this < any (array) This is natively supported by SQLDialect.POSTGRES.
Condition	lessThanAny(Select<?> query) this < any (Select
Condition	lessThanAny(T... array) this < any (array) This is natively supported by SQLDialect.POSTGRES.
Condition	lessThanSome(Select<?> query) Deprecated.
Condition	like(Field<String> value) Create a condition to pattern-check this field against a value SQL: this like value
Condition	like(Field<String> value, char escape) Create a condition to pattern-check this field against a value SQL: this like value escape 'e'
Condition	like(String value) Create a condition to pattern-check this field against a value SQL: this like value
Condition	like(String value, char escape) Create a condition to pattern-check this field against a value SQL: this like value escape 'e'
Field<BigDecimal>	ln() Deprecated.
Field<BigDecimal>	log(int base) Deprecated.
Field<String>	lower() Deprecated.
Field<String>	lpad(Field<? extends Number> length) Deprecated.
Field<String>	lpad(Field<? extends Number> length, Field<String> character) Deprecated.
Field<String>	lpad(int length) Deprecated.
Field<String>	lpad(int length, char character) Deprecated.
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>	mod(Field<? extends Number> value) An arithmetic expression getting the modulo of this divided by value This renders the modulo operation where available: [this] % [value] ... or the modulo function elsewhere: mod([this], [value])
Field<T>	mod(Number value) An arithmetic expression getting the modulo of this divided by value This renders the modulo operation where available: [this] % [value] ... or the modulo function elsewhere: mod([this], [value])
Field<T>	mul(Field<? extends Number> value) This default implementation is known to be overridden by Expression to generate neater expressions
Field<T>	mul(Number value) An arithmetic expression multiplying this with value If this is a numeric field, then the result is a number of the same type as this field.
Field<T>	neg() Negate this field to get its negative value.
Condition	notBetween(Field<T> minValue, Field<T> maxValue) Create a condition to check this field against some bounds SQL: this not between minValue and maxValue
Condition	notBetween(T minValue, T maxValue) Create a condition to check this field against some bounds SQL: this not between minValue and maxValue
Condition	notEqual(Field<T> field) this !
Condition	notEqual(Select<?> query) this !
Condition	notEqual(T value) this !
Condition	notEqualAll(Field<T[]> array) this !
Condition	notEqualAll(Select<?> query) this !
Condition	notEqualAll(T... array) this !
Condition	notEqualAny(Field<T[]> array) this !
Condition	notEqualAny(Select<?> query) this !
Condition	notEqualAny(T... array) this !
Condition	notEqualIgnoreCase(Field<String> value) lower(this) !
Condition	notEqualIgnoreCase(String value) lower(this) !
Condition	notEqualSome(Select<?> query) Deprecated.
Condition	notIn(Collection<T> values) Create a condition to check this field against several values Note that if any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well.
Condition	notIn(Field<?>... values) Create a condition to check this field against several values Note that if any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well.
Condition	notIn(Select<?> query) Create a condition to check this field against a subquery Note that the subquery must return exactly one field.
Condition	notIn(T... values) Create a condition to check this field against several values Note that if any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well.
Condition	notLike(Field<String> value) Create a condition to pattern-check this field against a value SQL: this not like value
Condition	notLike(Field<String> value, char escape) Create a condition to pattern-check this field against a value SQL: this not like value escape 'e'
Condition	notLike(String value) Create a condition to pattern-check this field against a value SQL: this not like value
Condition	notLike(String value, char escape) Create a condition to pattern-check this field against a value SQL: this not like value escape 'e'
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.
Field<Integer>	position(Field<String> search) Deprecated.
Field<Integer>	position(String search) Deprecated.
Field<BigDecimal>	power(Number exponent) Deprecated.
Field<BigDecimal>	rad() Deprecated.
Field<String>	repeat(Field<? extends Number> count) Deprecated.
Field<String>	repeat(Number count) Deprecated.
Field<String>	replace(Field<String> search) Deprecated.
Field<String>	replace(Field<String> search, Field<String> replace) Deprecated.
Field<String>	replace(String search) Deprecated.
Field<String>	replace(String search, String replace) Deprecated.
Field<T>	round() Deprecated.
Field<T>	round(int decimals) Deprecated.
Field<String>	rpad(Field<? extends Number> length) Deprecated.
Field<String>	rpad(Field<? extends Number> length, Field<String> character) Deprecated.
Field<String>	rpad(int length) Deprecated.
Field<String>	rpad(int length, char character) Deprecated.
Field<String>	rtrim() Deprecated.
Field<Integer>	sign() Deprecated.
Field<BigDecimal>	sin() Deprecated.
Field<BigDecimal>	sinh() Deprecated.
<Z> SortField<Z>	sort(Map<T,Z> sortMap) 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) ...
SortField<Integer>	sortAsc(Collection<T> sortList) Create a sort field of the form CASE [this] WHEN [sortList.get(0)] THEN 0 WHEN [sortList.get(1)] THEN 1 ...
SortField<Integer>	sortAsc(T... sortList) Create a sort field of the form CASE [this] WHEN [sortList[0]] THEN 0 WHEN [sortList[1]] THEN 1 ...
SortField<Integer>	sortDesc(Collection<T> sortList) Create a sort field of the form CASE [this] WHEN [sortList.get(0)] THEN 0 WHEN [sortList.get(1)] THEN 1 ...
SortField<Integer>	sortDesc(T... sortList) Create a sort field of the form CASE [this] WHEN [sortList[0]] THEN 0 WHEN [sortList[1]] THEN 1 ...
Field<BigDecimal>	sqrt() Deprecated.
Condition	startsWith(Field<T> value) 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)
Condition	startsWith(T value) 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)
Field<BigDecimal>	stddevPop() Deprecated.
WindowPartitionByStep<BigDecimal>	stddevPopOver() Deprecated.
Field<BigDecimal>	stddevSamp() Deprecated.
WindowPartitionByStep<BigDecimal>	stddevSampOver() Deprecated.
Field<T>	sub(Field<?> value) An arithmetic expression subtracting value from this.
Field<T>	sub(Number value) An arithmetic expression subtracting value from this.
Field<String>	substring(Field<? extends Number> startingPosition) Deprecated.
Field<String>	substring(Field<? extends Number> startingPosition, Field<? extends Number> length) Deprecated.
Field<String>	substring(int startingPosition) Deprecated.
Field<String>	substring(int startingPosition, int length) Deprecated.
Field<BigDecimal>	sum() Deprecated.
WindowPartitionByStep<BigDecimal>	sumOver() Deprecated.
Field<BigDecimal>	tan() Deprecated.
Field<BigDecimal>	tanh() Deprecated.
abstract void	toSQL(RenderContext context) Subclasses must implement this method Render this QueryPart to a SQL string contained in context.sql().
String	toString()
protected DataAccessException	translate(String task, String sql, SQLException e) Internal convenience method
Field<String>	trim() Deprecated.
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, equals, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.jooq.Field

equals, getName, getType

Methods inherited from interface org.jooq.NamedTypeProviderQueryPart

getDataType, getDataType

Methods inherited from interface org.jooq.Adapter

internalAPI

Methods inherited from interface java.lang.Comparable

compareTo

Constructor Detail

CustomField

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

Method Detail

toSQL

public abstract void toSQL(RenderContext context)

Subclasses must implement this method Render this QueryPart to a SQL string contained in context.sql(). The context will contain additional information about how to render this QueryPart, e.g. whether this QueryPart should be rendered as a declaration or reference, whether this QueryPart's contained bind variables should be inlined or replaced by '?', etc.

Specified by:

toSQL in interface QueryPartInternal

bind

public abstract void bind(BindContext context)
                   throws DataAccessException

Subclasses must implement this method Bind all parameters of this QueryPart to a PreparedStatement

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

Specified by:

bind in interface QueryPartInternal

Parameters:

context - The context holding the next bind index and other information for variable binding

Throws:

DataAccessException - If something went wrong while binding a variable

isNullLiteral

public boolean isNullLiteral()

Subclasses may further override this method Whether this field represents a null literal.

This method is for JOOQ INTERNAL USE only!

This method was added to be able to recognise null literals within jOOQ and handle them specially, as some SQL dialects have a rather un-intuitive way of handling null values.

Specified by:

isNullLiteral in interface Field<T>

getAttachables

public List<Attachable> getAttachables()

Subclasses may further override this method Get the list of dependent Attachables

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

attach

public void attach(Configuration configuration)

Subclasses may further override this method By default, nothing is done on an attachment event. Subclasses may override this, however, in order to receive a connection when needed

Specified by:

attach in interface Attachable

as

public final Field<T> as(String alias)

Description copied from interface: Field

Create an alias for this field

Specified by:

as in interface AliasProvider<Field<T>>

Specified by:

as in interface Field<T>

Parameters:

alias - The alias name

Returns:

The field alias

add

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

This default implementation is known to be overridden by Expression to generate neater expressions

Specified by:

add in interface Field<T>

mul

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

This default implementation is known to be overridden by Expression to generate neater expressions

Specified by:

mul in interface Field<T>

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

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

cast

public final <Z> Field<Z> cast(Class<? extends 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)

asc

public final SortField<T> asc()

Description copied from interface: Field

Create an ascending sort field from this field

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

Specified by:

desc in interface Field<T>

Returns:

This field as a descending sort field

sortAsc

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

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

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

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

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

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

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)

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:

• Factory.dateDiff(Field, Field)
• Factory.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>

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>

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>

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>

like

public final Condition 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>

like

public final Condition like(Field<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(Field<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>

notLike

public final Condition 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>

notLike

public final Condition notLike(Field<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(Field<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>

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]
 

Specified by:

contains in interface Field<T>

See Also:

Factory.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]
 

Specified by:

contains in interface Field<T>

See Also:

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

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:

Factory.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:

Factory.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:

Factory.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:

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

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<T> 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(Select<?> 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 on 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...)

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

Specified by:

notIn in interface Field<T>

notIn

public final Condition notIn(Select<?> 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 on 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

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

SQL: this between minValue and maxValue

Specified by:

between 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

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

SQL: this not between minValue and maxValue

Specified by:

notBetween in interface Field<T>

equal

public final Condition equal(T value)

Description copied from interface: Field

this = value

If value == null, then this will return a condition equivalent to Field.isNull() for convenience. SQL's ternary NULL logic is rarely of use for Java programmers.

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

Description copied from interface: Field

this = (Select ...)

Specified by:

equal in interface Field<T>

equalAny

public final Condition equalAny(Select<?> query)

Description copied from interface: Field

this = any (Select ...)

Specified by:

equalAny in interface Field<T>

equalAny

public final Condition equalAny(T... array)

Description copied from interface: Field

this = any (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

equalAny in interface Field<T>

equalAny

public final Condition equalAny(Field<T[]> array)

Description copied from interface: Field

this = any (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

equalAny in interface Field<T>

equalSome

@Deprecated
public final Condition equalSome(Select<?> query)

Deprecated.

Description copied from interface: Field

this = some (Select ...)

Specified by:

equalSome in interface Field<T>

equalAll

public final Condition equalAll(Select<?> query)

Description copied from interface: Field

this = all (Select ...)

Specified by:

equalAll in interface Field<T>

equalAll

public final Condition equalAll(T... array)

Description copied from interface: Field

this = all (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

equalAll in interface Field<T>

equalAll

public final Condition equalAll(Field<T[]> array)

Description copied from interface: Field

this = all (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

equalAll in interface Field<T>

notEqual

public final Condition notEqual(T value)

Description copied from interface: Field

this != value

If value == null, then this will return a condition equivalent to Field.isNotNull() for convenience. SQL's ternary NULL logic is rarely of use for Java programmers.

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

Description copied from interface: Field

this != (Select ...)

Specified by:

notEqual in interface Field<T>

notEqualAny

public final Condition notEqualAny(Select<?> query)

Description copied from interface: Field

this != any (Select ...)

Specified by:

notEqualAny in interface Field<T>

notEqualAny

public final Condition notEqualAny(T... array)

Description copied from interface: Field

this != any (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

notEqualAny in interface Field<T>

notEqualAny

public final Condition notEqualAny(Field<T[]> array)

Description copied from interface: Field

this != any (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

notEqualAny in interface Field<T>

notEqualSome

@Deprecated
public final Condition notEqualSome(Select<?> query)

Deprecated.

Description copied from interface: Field

this != some (Select ...)

Specified by:

notEqualSome in interface Field<T>

notEqualAll

public final Condition notEqualAll(Select<?> query)

Description copied from interface: Field

this != all (Select ...)

Specified by:

notEqualAll in interface Field<T>

notEqualAll

public final Condition notEqualAll(T... array)

Description copied from interface: Field

this != all (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

notEqualAll in interface Field<T>

notEqualAll

public final Condition notEqualAll(Field<T[]> array)

Description copied from interface: Field

this != all (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

notEqualAll in interface Field<T>

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

Description copied from interface: Field

this < (Select ...)

Specified by:

lessThan in interface Field<T>

lessThanAny

public final Condition lessThanAny(Select<?> query)

Description copied from interface: Field

this < any (Select ...)

Specified by:

lessThanAny in interface Field<T>

lessThanAny

public final Condition lessThanAny(T... array)

Description copied from interface: Field

this < any (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

lessThanAny in interface Field<T>

lessThanAny

public final Condition lessThanAny(Field<T[]> array)

Description copied from interface: Field

this < any (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

lessThanAny in interface Field<T>

lessThanSome

@Deprecated
public final Condition lessThanSome(Select<?> query)

Deprecated.

Description copied from interface: Field

this < some (Select ...)

Specified by:

lessThanSome in interface Field<T>

lessThanAll

public final Condition lessThanAll(Select<?> query)

Description copied from interface: Field

this < all (Select ...)

Specified by:

lessThanAll in interface Field<T>

lessThanAll

public final Condition lessThanAll(T... array)

Description copied from interface: Field

this < all (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

lessThanAll in interface Field<T>

lessThanAll

public final Condition lessThanAll(Field<T[]> array)

Description copied from interface: Field

this < all (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

lessThanAll in interface Field<T>

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

Description copied from interface: Field

this <= (Select ...)

Specified by:

lessOrEqual in interface Field<T>

lessOrEqualAny

public final Condition lessOrEqualAny(Select<?> query)

Description copied from interface: Field

this <= any (Select ...)

Specified by:

lessOrEqualAny in interface Field<T>

lessOrEqualAny

public final Condition lessOrEqualAny(T... array)

Description copied from interface: Field

this <= any (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

lessOrEqualAny in interface Field<T>

lessOrEqualAny

public final Condition lessOrEqualAny(Field<T[]> array)

Description copied from interface: Field

this <= any (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

lessOrEqualAny in interface Field<T>

lessOrEqualSome

@Deprecated
public final Condition lessOrEqualSome(Select<?> query)

Deprecated.

Description copied from interface: Field

this <= some (Select ...)

Specified by:

lessOrEqualSome in interface Field<T>

lessOrEqualAll

public final Condition lessOrEqualAll(Select<?> query)

Description copied from interface: Field

this <= all (Select ...)

Specified by:

lessOrEqualAll in interface Field<T>

lessOrEqualAll

public final Condition lessOrEqualAll(T... array)

Description copied from interface: Field

this <= all (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

lessOrEqualAll in interface Field<T>

lessOrEqualAll

public final Condition lessOrEqualAll(Field<T[]> array)

Description copied from interface: Field

this <= all (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

lessOrEqualAll in interface Field<T>

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

Description copied from interface: Field

this > (Select ...)

Specified by:

greaterThan in interface Field<T>

greaterThanAny

public final Condition greaterThanAny(Select<?> query)

Description copied from interface: Field

this > any (Select ...)

Specified by:

greaterThanAny in interface Field<T>

greaterThanAny

public final Condition greaterThanAny(T... array)

Description copied from interface: Field

this > any (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

greaterThanAny in interface Field<T>

greaterThanAny

public final Condition greaterThanAny(Field<T[]> array)

Description copied from interface: Field

this > any (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

greaterThanAny in interface Field<T>

greaterThanSome

@Deprecated
public final Condition greaterThanSome(Select<?> query)

Deprecated.

Description copied from interface: Field

this > some (Select ...)

Specified by:

greaterThanSome in interface Field<T>

greaterThanAll

public final Condition greaterThanAll(Select<?> query)

Description copied from interface: Field

this > all (Select ...)

Specified by:

greaterThanAll in interface Field<T>

greaterThanAll

public final Condition greaterThanAll(T... array)

Description copied from interface: Field

this > all (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

greaterThanAll in interface Field<T>

greaterThanAll

public final Condition greaterThanAll(Field<T[]> array)

Description copied from interface: Field

this > all (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

greaterThanAll in interface Field<T>

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

Description copied from interface: Field

this >= (Select ...)

Specified by:

greaterOrEqual in interface Field<T>

greaterOrEqualAny

public final Condition greaterOrEqualAny(Select<?> query)

Description copied from interface: Field

this >= any (Select ...)

Specified by:

greaterOrEqualAny in interface Field<T>

greaterOrEqualAny

public final Condition greaterOrEqualAny(T... array)

Description copied from interface: Field

this >= any (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

greaterOrEqualAny in interface Field<T>

greaterOrEqualAny

public final Condition greaterOrEqualAny(Field<T[]> array)

Description copied from interface: Field

this >= any (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

greaterOrEqualAny in interface Field<T>

greaterOrEqualSome

@Deprecated
public final Condition greaterOrEqualSome(Select<?> query)

Deprecated.

Description copied from interface: Field

this >= some (Select ...)

Specified by:

greaterOrEqualSome in interface Field<T>

greaterOrEqualAll

public final Condition greaterOrEqualAll(Select<?> query)

Description copied from interface: Field

this >= all (Select ...)

Specified by:

greaterOrEqualAll in interface Field<T>

greaterOrEqualAll

public final Condition greaterOrEqualAll(T... array)

Description copied from interface: Field

this >= all (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

greaterOrEqualAll in interface Field<T>

greaterOrEqualAll

public final Condition greaterOrEqualAll(Field<T[]> array)

Description copied from interface: Field

this >= all (array)

This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array.

Specified by:

greaterOrEqualAll in interface Field<T>

sign

@Deprecated
public final Field<Integer> sign()

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 Factory

Specified by:

sign in interface Field<T>

See Also:

Factory.sign(Field)

abs

@Deprecated
public final Field<T> abs()

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 Factory

Specified by:

abs in interface Field<T>

See Also:

Factory.abs(Field)

round

@Deprecated
public final Field<T> round()

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 Factory

Specified by:

round in interface Field<T>

See Also:

Factory.round(Field)

round

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

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 Factory

Specified by:

round in interface Field<T>

See Also:

Factory.round(Field, int)

floor

@Deprecated
public final Field<T> floor()

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 Factory

Specified by:

floor in interface Field<T>

See Also:

Factory.floor(Field)

ceil

@Deprecated
public final Field<T> ceil()

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 Factory

Specified by:

ceil in interface Field<T>

See Also:

Factory.ceil(Field)

sqrt

@Deprecated
public final Field<BigDecimal> sqrt()

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 Factory

Specified by:

sqrt in interface Field<T>

See Also:

Factory.sqrt(Field)

exp

@Deprecated
public final Field<BigDecimal> exp()

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 Factory

Specified by:

exp in interface Field<T>

See Also:

Factory.exp(Field)

ln

@Deprecated
public final Field<BigDecimal> ln()

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 Factory

Specified by:

ln in interface Field<T>

See Also:

Factory.ln(Field)

log

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

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 Factory

Specified by:

log in interface Field<T>

See Also:

Factory.log(Field, int)

power

@Deprecated
public final Field<BigDecimal> power(Number exponent)

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 Factory

Specified by:

power in interface Field<T>

See Also:

Factory.power(Field, Number)

acos

@Deprecated
public final Field<BigDecimal> acos()

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 Factory

Specified by:

acos in interface Field<T>

See Also:

Factory.acos(Field)

asin

@Deprecated
public final Field<BigDecimal> asin()

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 Factory

Specified by:

asin in interface Field<T>

See Also:

Factory.asin(Field)

atan

@Deprecated
public final Field<BigDecimal> atan()

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 Factory

Specified by:

atan in interface Field<T>

See Also:

Factory.atan(Field)

atan2

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

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 Factory

Specified by:

atan2 in interface Field<T>

See Also:

Factory.atan2(Field, Number)

atan2

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

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 Factory

Specified by:

atan2 in interface Field<T>

See Also:

Factory.atan2(Field, Field)

cos

@Deprecated
public final Field<BigDecimal> cos()

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 Factory

Specified by:

cos in interface Field<T>

See Also:

Factory.cos(Field)

sin

@Deprecated
public final Field<BigDecimal> sin()

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 Factory

Specified by:

sin in interface Field<T>

See Also:

Factory.sin(Field)

tan

@Deprecated
public final Field<BigDecimal> tan()

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 Factory

Specified by:

tan in interface Field<T>

See Also:

Factory.tan(Field)

cot

@Deprecated
public final Field<BigDecimal> cot()

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 Factory

Specified by:

cot in interface Field<T>

See Also:

Factory.cot(Field)

sinh

@Deprecated
public final Field<BigDecimal> sinh()

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 Factory

Specified by:

sinh in interface Field<T>

See Also:

Factory.sinh(Field)

cosh

@Deprecated
public final Field<BigDecimal> cosh()

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 Factory

Specified by:

cosh in interface Field<T>

See Also:

Factory.cosh(Field)

tanh

@Deprecated
public final Field<BigDecimal> tanh()

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 Factory

Specified by:

tanh in interface Field<T>

See Also:

Factory.tanh(Field)

coth

@Deprecated
public final Field<BigDecimal> coth()

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 Factory

Specified by:

coth in interface Field<T>

See Also:

Factory.coth(Field)

deg

@Deprecated
public final Field<BigDecimal> deg()

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 Factory

Specified by:

deg in interface Field<T>

See Also:

Factory.deg(Field)

rad

@Deprecated
public final Field<BigDecimal> rad()

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 Factory

Specified by:

rad in interface Field<T>

See Also:

Factory.rad(Field)

count

@Deprecated
public final Field<Integer> 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 Factory

Specified by:

count in interface Field<T>

See Also:

Factory.count(Field)

countDistinct

@Deprecated
public final Field<Integer> countDistinct()

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 Factory

Specified by:

countDistinct in interface Field<T>

See Also:

Factory.countDistinct(Field)

max

@Deprecated
public final Field<T> max()

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 Factory

Specified by:

max in interface Field<T>

See Also:

Factory.max(Field)

min

@Deprecated
public final Field<T> min()

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 Factory

Specified by:

min in interface Field<T>

See Also:

Factory.min(Field)

sum

@Deprecated
public final Field<BigDecimal> sum()

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 Factory

Specified by:

sum in interface Field<T>

See Also:

Factory.sum(Field)

avg

@Deprecated
public final Field<BigDecimal> avg()

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 Factory

Specified by:

avg in interface Field<T>

See Also:

Factory.avg(Field)

median

@Deprecated
public final Field<BigDecimal> median()

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 Factory

Specified by:

median in interface Field<T>

See Also:

Factory.median(Field)

stddevPop

@Deprecated
public final Field<BigDecimal> stddevPop()

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 Factory

Specified by:

stddevPop in interface Field<T>

See Also:

Factory.stddevPop(Field)

stddevSamp

@Deprecated
public final Field<BigDecimal> stddevSamp()

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 Factory

Specified by:

stddevSamp in interface Field<T>

See Also:

Factory.stddevSamp(Field)

varPop

@Deprecated
public final Field<BigDecimal> varPop()

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 Factory

Specified by:

varPop in interface Field<T>

See Also:

Factory.varPop(Field)

varSamp

@Deprecated
public final Field<BigDecimal> varSamp()

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 Factory

Specified by:

varSamp in interface Field<T>

See Also:

Factory.varSamp(Field)

countOver

@Deprecated
public final WindowPartitionByStep<Integer> countOver()

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 Factory

Specified by:

countOver in interface Field<T>

See Also:

Factory.count(Field), AggregateFunction.over()

maxOver

@Deprecated
public final WindowPartitionByStep<T> maxOver()

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 Factory

Specified by:

maxOver in interface Field<T>

See Also:

Factory.max(Field), AggregateFunction.over()

minOver

@Deprecated
public final WindowPartitionByStep<T> minOver()

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 Factory

Specified by:

minOver in interface Field<T>

See Also:

Factory.min(Field), AggregateFunction.over()

sumOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> sumOver()

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 Factory

Specified by:

sumOver in interface Field<T>

See Also:

Factory.sum(Field), AggregateFunction.over()

avgOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> avgOver()

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 Factory

Specified by:

avgOver in interface Field<T>

See Also:

Factory.avg(Field), AggregateFunction.over()

firstValue

@Deprecated
public final WindowIgnoreNullsStep<T> firstValue()

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 Factory

Specified by:

firstValue in interface Field<T>

See Also:

Factory.firstValue(Field), AggregateFunction.over()

lastValue

@Deprecated
public final WindowIgnoreNullsStep<T> lastValue()

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 Factory

Specified by:

lastValue in interface Field<T>

See Also:

Factory.lastValue(Field), AggregateFunction.over()

lead

@Deprecated
public final WindowIgnoreNullsStep<T> lead()

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 Factory

Specified by:

lead in interface Field<T>

See Also:

Factory.lead(Field), AggregateFunction.over()

lead

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

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 Factory

Specified by:

lead in interface Field<T>

See Also:

Factory.lead(Field, int), AggregateFunction.over()

lead

@Deprecated
public final WindowIgnoreNullsStep<T> lead(int offset,
                                                      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 Factory

Specified by:

lead in interface Field<T>

See Also:

Factory.lead(Field, int, Object), AggregateFunction.over()

lead

@Deprecated
public final WindowIgnoreNullsStep<T> lead(int offset,
                                                      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 Factory

Specified by:

lead in interface Field<T>

See Also:

Factory.lead(Field, int, Field), AggregateFunction.over()

lag

@Deprecated
public final WindowIgnoreNullsStep<T> lag()

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 Factory

Specified by:

lag in interface Field<T>

See Also:

Factory.lag(Field), AggregateFunction.over()

lag

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

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 Factory

Specified by:

lag in interface Field<T>

See Also:

Factory.lag(Field, int), AggregateFunction.over()

lag

@Deprecated
public final WindowIgnoreNullsStep<T> lag(int offset,
                                                     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 Factory

Specified by:

lag in interface Field<T>

See Also:

Factory.lag(Field, int, Object), AggregateFunction.over()

lag

@Deprecated
public final WindowIgnoreNullsStep<T> lag(int offset,
                                                     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 Factory

Specified by:

lag in interface Field<T>

See Also:

Factory.lag(Field, int, Field), AggregateFunction.over()

stddevPopOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> stddevPopOver()

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 Factory

Specified by:

stddevPopOver in interface Field<T>

See Also:

Factory.stddevPop(Field), AggregateFunction.over()

stddevSampOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> stddevSampOver()

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 Factory

Specified by:

stddevSampOver in interface Field<T>

See Also:

Factory.stddevSamp(Field), AggregateFunction.over()

varPopOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> varPopOver()

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 Factory

Specified by:

varPopOver in interface Field<T>

See Also:

Factory.varPop(Field), AggregateFunction.over()

varSampOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> varSampOver()

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 Factory

Specified by:

varSampOver in interface Field<T>

See Also:

Factory.varSamp(Field), AggregateFunction.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 Factory

Specified by:

upper in interface Field<T>

See Also:

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

Specified by:

lower in interface Field<T>

See Also:

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

Specified by:

trim in interface Field<T>

See Also:

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

Specified by:

rtrim in interface Field<T>

See Also:

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

Specified by:

ltrim in interface Field<T>

See Also:

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

Specified by:

rpad in interface Field<T>

See Also:

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

Specified by:

rpad in interface Field<T>

See Also:

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

Specified by:

rpad in interface Field<T>

See Also:

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

Specified by:

rpad in interface Field<T>

See Also:

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

Specified by:

lpad in interface Field<T>

See Also:

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

Specified by:

lpad in interface Field<T>

See Also:

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

Specified by:

lpad in interface Field<T>

See Also:

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

Specified by:

lpad in interface Field<T>

See Also:

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

Specified by:

repeat in interface Field<T>

See Also:

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

Specified by:

repeat in interface Field<T>

See Also:

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

Specified by:

replace in interface Field<T>

See Also:

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

Specified by:

replace in interface Field<T>

See Also:

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

Specified by:

replace in interface Field<T>

See Also:

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

Specified by:

replace in interface Field<T>

See Also:

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

Specified by:

position in interface Field<T>

See Also:

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

Specified by:

position in interface Field<T>

See Also:

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

Specified by:

ascii in interface Field<T>

See Also:

Factory.ascii(Field)

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 Factory

Specified by:

concat in interface Field<T>

See Also:

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

Specified by:

concat in interface Field<T>

See Also:

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

Specified by:

substring in interface Field<T>

See Also:

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

Specified by:

substring in interface Field<T>

See Also:

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

Specified by:

substring in interface Field<T>

See Also:

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

Specified by:

substring in interface Field<T>

See Also:

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

Specified by:

length in interface Field<T>

See Also:

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

Specified by:

charLength in interface Field<T>

See Also:

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

Specified by:

bitLength in interface Field<T>

See Also:

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

Specified by:

octetLength in interface Field<T>

See Also:

Factory.octetLength(Field)

extract

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

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 Factory

Specified by:

extract in interface Field<T>

See Also:

Factory.extract(Field, DatePart)

greatest

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

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 Factory

Specified by:

greatest in interface Field<T>

See Also:

Factory.greatest(Field, Field...)

greatest

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

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 Factory

Specified by:

greatest in interface Field<T>

See Also:

Factory.greatest(Field, Field...)

least

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

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 Factory

Specified by:

least in interface Field<T>

See Also:

Factory.least(Field, Field...)

least

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

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 Factory

Specified by:

least in interface Field<T>

See Also:

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

Specified by:

nvl in interface Field<T>

See Also:

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

Specified by:

nvl in interface Field<T>

See Also:

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

Specified by:

nvl2 in interface Field<T>

See Also:

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

Specified by:

nvl2 in interface Field<T>

See Also:

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

Specified by:

nullif in interface Field<T>

See Also:

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

Specified by:

nullif in interface Field<T>

See Also:

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

Specified by:

decode in interface Field<T>

See Also:

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

Specified by:

decode in interface Field<T>

See Also:

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

Specified by:

decode in interface Field<T>

See Also:

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

Specified by:

decode in interface Field<T>

See Also:

Factory.decode(Field, Field, Field, Field...)

coalesce

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

Specified by:

coalesce in interface Field<T>

See Also:

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

Specified by:

coalesce in interface Field<T>

See Also:

Factory.coalesce(Field, Field...)

getDataType

public final DataType<T> getDataType()

Description copied from interface: NamedTypeProviderQueryPart

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

Specified by:

getDataType in interface NamedTypeProviderQueryPart<T>

getSQLDataType

protected final SQLDataType<T> getSQLDataType()

getDataType

public final DataType<T> getDataType(Configuration configuration)

Description copied from interface: NamedTypeProviderQueryPart

The dialect-specific type of this object

Specified by:

getDataType in interface NamedTypeProviderQueryPart<T>

getType

public final Class<? extends T> getType()

Description copied from interface: NamedTypeProviderQueryPart

The type of this object

Specified by:

getType in interface NamedTypeProviderQueryPart<T>

getName

public final String getName()

Description copied from interface: NamedQueryPart

The name of this query part

Specified by:

getName in interface NamedQueryPart

compareTo

public final int compareTo(NamedQueryPart that)

Specified by:

compareTo in interface Comparable<NamedQueryPart>

internalAPI

public final <I> I internalAPI(Class<I> internalType)

Description copied from interface: Adapter

Adapt to an internal type assuming its functionality

This is for JOOQ INTERNAL USE only. If you need to access the internal API, these are the known possible interfaces:

• QueryPartInternal: The internal API for QueryPart

Be aware though, that the internal API may change even between minor releases.

Specified by:

internalAPI in interface Adapter

Type Parameters:

I - The internal type's generic type parameter.

Parameters:

internalType - The internal type

Returns:

This object wrapped by or cast to an internal type

getConfiguration

public final Configuration getConfiguration()

Description copied from interface: AttachableInternal

Get the underlying configuration

Specified by:

getConfiguration in interface AttachableInternal

getDialect

@Deprecated
public final SQLDialect getDialect()

Deprecated.

Description copied from interface: QueryPartInternal

Reproduce the SQL dialect this QueryPart was created with

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

Specified by:

getDialect in interface QueryPartInternal

Returns:

The SQL dialect

getSQL

public final String getSQL()

This method is also declared as Query.getSQL()

Retrieve the SQL that will be rendered by this QueryPart

This method is exposed publicly in Query.getSQL()

Specified by:

getSQL in interface QueryPartInternal

getSQL

public final String getSQL(boolean inline)

This method is also declared as Query.getSQL(boolean)

Retrieve the SQL that will be rendered by this QueryPart

This method is exposed publicly in Query.getSQL(boolean)

Specified by:

getSQL in interface QueryPartInternal

getBindValues

public final List<Object> getBindValues()

This method is also declared as Query.getBindValues()

Retrieve the bind values that will be bound by this QueryPart

This method is exposed publicly in Query.getBindValues()

Specified by:

getBindValues in interface QueryPartInternal

getParams

public final Map<String,Param<?>> getParams()

This method is also declared as Query.getParams()

Retrieve the named parameters that will be bound by this QueryPart

This method is exposed publicly in Query.getParams()

Specified by:

getParams in interface QueryPartInternal

getParam

public final Param<?> getParam(String name)

This method is also declared as Query.getParam(String)

Retrieve a named parameter that will be bound by this QueryPart

This method is exposed publicly in Query.getParam(String)

Specified by:

getParam in interface QueryPartInternal

equals

public boolean equals(Object that)

Overrides:

equals in class Object

hashCode

public int hashCode()

Overrides:

hashCode in class Object

toString

public String toString()

Overrides:

toString in class Object

getAttachables

protected final List<Attachable> getAttachables(Collection<? extends QueryPart> list)

Internal convenience method

getAttachables

protected final List<Attachable> getAttachables(QueryPart... list)

Internal convenience method

getAttachables

protected final List<Attachable> getAttachables(Store<?> store)

Internal convenience method

create

protected final Factory create()

Internal convenience method

create

protected final Factory create(Configuration configuration)

Internal convenience method

translate

protected final DataAccessException translate(String task,
                                              String sql,
                                              SQLException e)

Internal convenience method