org.jooq

Interface Field<T>

Type Parameters:

T - The field type

All Superinterfaces:

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

All Known Subinterfaces:

AggregateFunction<T>, CaseConditionStep<T>, CaseWhenStep<V,T>, GroupConcatOrderByStep, GroupConcatSeparatorStep, Param<T>, TableField<R,T>, UDTField<R,T>, WindowBeforeOverStep<T>, WindowFinalStep<T>, WindowOrderByStep<T>, WindowPartitionByStep<T>, WindowRowsStep<T>

All Known Implementing Classes:

CustomField

public interface Field<T>
extends NamedTypeProviderQueryPart<T>, AliasProvider<Field<T>>

A field used in tables and conditions

Author:

Lukas Eder

Method Summary

Methods

Modifier and Type	Method and Description
Field<T>	abs() This method is part of the pre-2.0 API.
Field<BigDecimal>	acos() This method is part of the pre-2.0 API.
Field<T>	add(Field<?> value) An arithmetic expression to add value to this.
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 This is the same as calling sort(SortOrder) with SortOrder.ASC
Field<Integer>	ascii() This method is part of the pre-2.0 API.
Field<BigDecimal>	asin() This method is part of the pre-2.0 API.
Field<BigDecimal>	atan() This method is part of the pre-2.0 API.
Field<BigDecimal>	atan2(Field<? extends Number> y) This method is part of the pre-2.0 API.
Field<BigDecimal>	atan2(Number y) This method is part of the pre-2.0 API.
Field<BigDecimal>	avg() This method is part of the pre-2.0 API.
WindowPartitionByStep<BigDecimal>	avgOver() This method is part of the pre-2.0 API.
BetweenAndStep<T>	between(Field<T> minValue) Create a condition to check this field against some bounds SQL: this between minValue and maxValue
Condition	between(Field<T> minValue, Field<T> maxValue) Create a condition to check this field against some bounds This is the same as calling between(minValue).and(maxValue) SQL: this between minValue and maxValue
BetweenAndStep<T>	between(T minValue) 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 This is the same as calling between(minValue).and(maxValue) SQL: this between minValue and maxValue
BetweenAndStep<T>	betweenSymmetric(Field<T> minValue) Create a condition to check this field against some bounds SQL: this between symmetric minValue and maxValue
Condition	betweenSymmetric(Field<T> minValue, Field<T> maxValue) Create a condition to check this field against some bounds This is the same as calling betweenSymmetric(minValue).and(maxValue) SQL: this between symmetric minValue and maxValue
BetweenAndStep<T>	betweenSymmetric(T minValue) Create a condition to check this field against some bounds SQL: this between symmetric minValue and maxValue
Condition	betweenSymmetric(T minValue, T maxValue) Create a condition to check this field against some bounds This is the same as calling betweenSymmetric(minValue).and(maxValue) SQL: this between symmetric minValue and maxValue
Field<Integer>	bitLength() This method is part of the pre-2.0 API.
<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() This method is part of the pre-2.0 API.
Field<Integer>	charLength() This method is part of the pre-2.0 API.
Field<T>	coalesce(Field<T> option, Field<?>... options) This method is part of the pre-2.0 API.
Field<T>	coalesce(T option, T... options) This method is part of the pre-2.0 API.
Condition	compare(Comparator comparator, Field<T> field) Compare this field with another field using a dynamic comparator
Condition	compare(Comparator comparator, T value) Compare this field with a value using a dynamic comparator
Field<String>	concat(Field<?>... fields) This method is part of the pre-2.0 API.
Field<String>	concat(String... values) This method is part of the pre-2.0 API.
Condition	contains(Field<T> value) Convenience method for like(String, char) including proper adding of wildcards and escaping SQL: this like ('%' || escape(value, '\') || '%') escape '\' Note: This also works with numbers, for instance val(1133).contains(13) If you're using SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator.
Condition	contains(T value) Convenience method for like(String, char) including proper adding of wildcards and escaping SQL: this like ('%' || escape(value, '\') || '%') escape '\' Note: This also works with numbers, for instance val(1133).contains(13) If you're using SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator.
Field<BigDecimal>	cos() This method is part of the pre-2.0 API.
Field<BigDecimal>	cosh() This method is part of the pre-2.0 API.
Field<BigDecimal>	cot() This method is part of the pre-2.0 API.
Field<BigDecimal>	coth() This method is part of the pre-2.0 API.
Field<Integer>	count() This method is part of the pre-2.0 API.
Field<Integer>	countDistinct() This method is part of the pre-2.0 API.
WindowPartitionByStep<Integer>	countOver() This method is part of the pre-2.0 API.
<Z> Field<Z>	decode(Field<T> search, Field<Z> result) This method is part of the pre-2.0 API.
<Z> Field<Z>	decode(Field<T> search, Field<Z> result, Field<?>... more) This method is part of the pre-2.0 API.
<Z> Field<Z>	decode(T search, Z result) This method is part of the pre-2.0 API.
<Z> Field<Z>	decode(T search, Z result, Object... more) This method is part of the pre-2.0 API.
Field<BigDecimal>	deg() This method is part of the pre-2.0 API.
SortField<T>	desc() Create a descending sort field from this field This is the same as calling sort(SortOrder) with SortOrder.DESC
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 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 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	eq(Field<T> field) this = field
Condition	eq(Select<?> query) this = (Select
Condition	eq(T value) this = value If value == null, then this will return a condition equivalent to isNull() for convenience.
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 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 other) Watch out!
Condition	equalSome(Select<?> query) Deprecated. - 2.0.2 - Use equalAny(Select) instead
Field<BigDecimal>	exp() This method is part of the pre-2.0 API.
Field<Integer>	extract(DatePart datePart) This method is part of the pre-2.0 API.
WindowIgnoreNullsStep<T>	firstValue() This method is part of the pre-2.0 API.
Field<T>	floor() This method is part of the pre-2.0 API.
Condition	ge(Field<T> field) this >= field
Condition	ge(Select<?> query) this >= (Select
Condition	ge(T value) this >= value
DataType<T>	getDataType() The type of this field (might not be dialect-specific)
DataType<T>	getDataType(Configuration configuration) The dialect-specific type of this field
String	getName() The name of the field.
Class<? extends T>	getType() The Java type of the field.
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. - 2.0.2 - Use greaterOrEqualAny(Select) instead
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. - 2.0.2 - Use greaterThanAny(Select) instead
Field<T>	greatest(Field<?>... others) This method is part of the pre-2.0 API.
Field<T>	greatest(T... others) This method is part of the pre-2.0 API.
Condition	gt(Field<T> field) this > field
Condition	gt(Select<?> query) this > (Select
Condition	gt(T value) this > value
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...)
Condition	isDistinctFrom(Field<T> field) Create a condition to check if this field is DISTINCT from another field If this is not supported by the underlying database, jOOQ will render this instead: CASE WHEN [this] IS NULL AND [field] IS NULL THEN FALSE WHEN [this] IS NULL AND [field] IS NOT NULL THEN TRUE WHEN [this] IS NOT NULL AND [field] IS NULL THEN TRUE WHEN [this] = [field] THEN FALSE ELSE TRUE END SQL: this is distinct from field
Condition	isDistinctFrom(T value) Create a condition to check if this field is DISTINCT from another value If this is not supported by the underlying database, jOOQ will render this instead: CASE WHEN [this] IS NULL AND [value] IS NULL THEN FALSE WHEN [this] IS NULL AND [value] IS NOT NULL THEN TRUE WHEN [this] IS NOT NULL AND [value] IS NULL THEN TRUE WHEN [this] = [value] THEN FALSE ELSE TRUE END SQL: this is distinct from value
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	isNotDistinctFrom(Field<T> field) Create a condition to check if this field is NOT DISTINCT from another field If this is not supported by the underlying database, jOOQ will render this instead: CASE WHEN [this] IS NULL AND [field] IS NULL THEN TRUE WHEN [this] IS NULL AND [field] IS NOT NULL THEN FALSE WHEN [this] IS NOT NULL AND [field] IS NULL THEN FALSE WHEN [this] = [value] THEN TRUE ELSE FALSE END SQL: this is not distinct from field
Condition	isNotDistinctFrom(T value) Create a condition to check if this field is NOT DISTINCT from another value If this is not supported by the underlying database, jOOQ will render this instead: CASE WHEN [this] IS NULL AND [value] IS NULL THEN TRUE WHEN [this] IS NULL AND [value] IS NOT NULL THEN FALSE WHEN [this] IS NOT NULL AND [value] IS NULL THEN FALSE WHEN [this] = [value] THEN TRUE ELSE FALSE END SQL: this is not distinct from value
Condition	isNotNull() Create a condition to check this field against null.
Condition	isNull() Create a condition to check this field against null.
boolean	isNullLiteral() 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() This method is part of the pre-2.0 API.
WindowIgnoreNullsStep<T>	lag(int offset) This method is part of the pre-2.0 API.
WindowIgnoreNullsStep<T>	lag(int offset, Field<T> defaultValue) This method is part of the pre-2.0 API.
WindowIgnoreNullsStep<T>	lag(int offset, T defaultValue) This method is part of the pre-2.0 API.
WindowIgnoreNullsStep<T>	lastValue() This method is part of the pre-2.0 API.
Condition	le(Field<T> field) this <= field
Condition	le(Select<?> query) this <= (Select
Condition	le(T value) this <= value
WindowIgnoreNullsStep<T>	lead() This method is part of the pre-2.0 API.
WindowIgnoreNullsStep<T>	lead(int offset) This method is part of the pre-2.0 API.
WindowIgnoreNullsStep<T>	lead(int offset, Field<T> defaultValue) This method is part of the pre-2.0 API.
WindowIgnoreNullsStep<T>	lead(int offset, T defaultValue) This method is part of the pre-2.0 API.
Field<T>	least(Field<?>... others) This method is part of the pre-2.0 API.
Field<T>	least(T... others) This method is part of the pre-2.0 API.
Field<Integer>	length() This method is part of the pre-2.0 API.
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. - 2.0.2 - Use lessOrEqualAny(Select) instead
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. - 2.0.2 - Use lessThanAny(Select) instead
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'
Condition	likeIgnoreCase(Field<String> field) Create a condition to case-insensitively pattern-check this field against a field This translates to this ilike field in SQLDialect.POSTGRES, or to lower(this) like lower(field) in all other dialects.
Condition	likeIgnoreCase(Field<String> field, char escape) Create a condition to case-insensitively pattern-check this field against a field This translates to this ilike field in SQLDialect.POSTGRES, or to lower(this) like lower(field) in all other dialects.
Condition	likeIgnoreCase(String value) Create a condition to case-insensitively pattern-check this field against a value This translates to this ilike value in SQLDialect.POSTGRES, or to lower(this) like lower(value) in all other dialects.
Condition	likeIgnoreCase(String value, char escape) Create a condition to case-insensitively pattern-check this field against a value This translates to this ilike value in SQLDialect.POSTGRES, or to lower(this) like lower(value) in all other dialects.
Condition	likeRegex(Field<String> pattern) Create a condition to regex-pattern-check this field against a pattern See likeRegex(String) for more details
Condition	likeRegex(String pattern) Create a condition to regex-pattern-check this field against a pattern The SQL:2008 standard specifies a <regex like predicate> of the following form: <regex like predicate> ::= <row value predicand> <regex like predicate part 2> <regex like predicate part 2> ::= [ NOT ] LIKE_REGEX <XQuery pattern> [ FLAG <XQuery option flag> ] This particular LIKE_REGEX operator comes in several flavours for various databases. jOOQ supports regular expressions as follows: SQL dialect SQL syntax Pattern syntax Documentation SQLDialect.ASE - - - SQLDialect.CUBRID[search] REGEXP [pattern] POSIX http://www.cubrid.org/manual/841/en/REGEXP Conditional ExpressionSQLDialect.DB2 - - - SQLDialect.DERBY - - - SQLDialect.H2[search] REGEXP [pattern] Java http ://www.h2database.com/html/grammar.html#condition_right_hand_sideSQLDialect.HSQLDBREGEXP_MATCHES([search], [pattern]) Java http://hsqldb.org/doc/guide/builtinfunctions-chapt.html#N13577 SQLDialect.INGRES - - - SQLDialect.MYSQL [search] REGEXP [pattern] POSIX http://dev.mysql.com/doc/refman/5.6/en/regexp.html SQLDialect.ORACLE REGEXP_LIKE([search], [pattern]) POSIX http://docs.oracle.com/cd/E14072_01/server.112/e10592/conditions007.htm# sthref1994 SQLDialect.POSTGRES [search] ~ [pattern] POSIX http://www.postgresql.org/docs/9.1/static/functions-matching.html# FUNCTIONS-POSIX-REGEXP SQLDialect.SQLITE [search] REGEXP [pattern] ? Field<BigDecimal> ln() This method is part of the pre-2.0 API. Field<BigDecimal> log(int base) This method is part of the pre-2.0 API. Field<String> lower() This method is part of the pre-2.0 API. Field<String> lpad(Field<? extends Number> length) This method is part of the pre-2.0 API. Field<String> lpad(Field<? extends Number> length, Field<String> character) This method is part of the pre-2.0 API. Field<String> lpad(int length) This method is part of the pre-2.0 API. Field<String> lpad(int length, char character) This method is part of the pre-2.0 API. Condition lt(Field<T> field) this < field Condition lt(Select<?> query) this < (Select Condition lt(T value) this < value Field<String> ltrim() This method is part of the pre-2.0 API. Field<T> max() This method is part of the pre-2.0 API. WindowPartitionByStep<T> maxOver() This method is part of the pre-2.0 API. Field<BigDecimal> median() This method is part of the pre-2.0 API. Field<T> min() This method is part of the pre-2.0 API. WindowPartitionByStep<T> minOver() This method is part of the pre-2.0 API. 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) 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> 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. Condition ne(Field<T> field) this ! Condition ne(Select<?> query) this ! Condition ne(T value) this ! Field<T> neg() Negate this field to get its negative value. BetweenAndStep<T> notBetween(Field<T> minValue) Create a condition to check this field against some bounds SQL: this not between minValue and maxValue Condition notBetween(Field<T> minValue, Field<T> maxValue) Create a condition to check this field against some bounds This is the same as calling notBetween(minValue).and(maxValue) SQL: this not between minValue and maxValue BetweenAndStep<T> notBetween(T minValue) 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 This is the same as calling notBetween(minValue).and(maxValue) SQL: this not between minValue and maxValue BetweenAndStep<T> notBetweenSymmetric(Field<T> minValue) Create a condition to check this field against some bounds SQL: this not between symmetric minValue and maxValue Condition notBetweenSymmetric(Field<T> minValue, Field<T> maxValue) Create a condition to check this field against some bounds This is the same as calling notBetweenSymmetric(minValue).and(maxValue) SQL: this not between symmetric minValue and maxValue BetweenAndStep<T> notBetweenSymmetric(T minValue) Create a condition to check this field against some bounds SQL: this not between symmetric minValue and maxValue Condition notBetweenSymmetric(T minValue, T maxValue) Create a condition to check this field against some bounds This is the same as calling notBetweenSymmetric(minValue).and(maxValue) SQL: this not between symmetric minValue and maxValue 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. - 2.0.2 - Use notEqualAny(Select) instead 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> field) Create a condition to pattern-check this field against a field SQL: this not like field Condition notLike(Field<String> field, char escape) Create a condition to pattern-check this field against a field SQL: this not like field escape 'e' 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' Condition notLikeIgnoreCase(Field<String> field) Create a condition to case-insensitively pattern-check this field against a field This translates to this not ilike field in SQLDialect.POSTGRES, or to lower(this) not like lower(field) in all other dialects. Condition notLikeIgnoreCase(Field<String> field, char escape) Create a condition to case-insensitively pattern-check this field against a field This translates to this not ilike field in SQLDialect.POSTGRES, or to lower(this) not like lower(field) in all other dialects. Condition notLikeIgnoreCase(String value) Create a condition to case-insensitively pattern-check this field against a value This translates to this not ilike value in SQLDialect.POSTGRES, or to lower(this) not like lower(value) in all other dialects. Condition notLikeIgnoreCase(String value, char escape) Create a condition to case-insensitively pattern-check this field against a value This translates to this not ilike value in SQLDialect.POSTGRES, or to lower(this) not like lower(value) in all other dialects. Condition notLikeRegex(Field<String> pattern) Create a condition to regex-pattern-check this field against a pattern See likeRegex(String) for more details Condition notLikeRegex(String pattern) Create a condition to regex-pattern-check this field against a pattern See likeRegex(String) for more details Field<T> nullif(Field<T> other) This method is part of the pre-2.0 API. Field<T> nullif(T other) This method is part of the pre-2.0 API. Field<T> nvl(Field<T> defaultValue) This method is part of the pre-2.0 API. Field<T> nvl(T defaultValue) This method is part of the pre-2.0 API. <Z> Field<Z> nvl2(Field<Z> valueIfNotNull, Field<Z> valueIfNull) This method is part of the pre-2.0 API. <Z> Field<Z> nvl2(Z valueIfNotNull, Z valueIfNull) This method is part of the pre-2.0 API. Field<Integer> octetLength() This method is part of the pre-2.0 API. Field<Integer> position(Field<String> search) This method is part of the pre-2.0 API. Field<Integer> position(String search) This method is part of the pre-2.0 API. Field<BigDecimal> power(Number exponent) This method is part of the pre-2.0 API. Field<BigDecimal> rad() This method is part of the pre-2.0 API. Field<String> repeat(Field<? extends Number> count) This method is part of the pre-2.0 API. Field<String> repeat(Number count) This method is part of the pre-2.0 API. Field<String> replace(Field<String> search) This method is part of the pre-2.0 API. Field<String> replace(Field<String> search, Field<String> replace) This method is part of the pre-2.0 API. Field<String> replace(String search) This method is part of the pre-2.0 API. Field<String> replace(String search, String replace) This method is part of the pre-2.0 API. Field<T> round() This method is part of the pre-2.0 API. Field<T> round(int decimals) This method is part of the pre-2.0 API. Field<String> rpad(Field<? extends Number> length) This method is part of the pre-2.0 API. Field<String> rpad(Field<? extends Number> length, Field<String> character) This method is part of the pre-2.0 API. Field<String> rpad(int length) This method is part of the pre-2.0 API. Field<String> rpad(int length, char character) This method is part of the pre-2.0 API. Field<String> rtrim() This method is part of the pre-2.0 API. Field<Integer> sign() This method is part of the pre-2.0 API. Field<BigDecimal> sin() This method is part of the pre-2.0 API. Field<BigDecimal> sinh() This method is part of the pre-2.0 API. <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<T> sort(SortOrder order) Create an ascending/descending sort field from this field 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() This method is part of the pre-2.0 API. Condition startsWith(Field<T> value) Convenience method for like(String, char) including proper adding of wildcards and escaping SQL: this like (escape(value, '\') || '%') escape '\' Note: This also works with numbers, for instance val(1133).startsWith(11) Condition startsWith(T value) Convenience method for like(String, char) including proper adding of wildcards and escaping SQL: this like (escape(value, '\') || '%') escape '\' Note: This also works with numbers, for instance val(1133).startsWith(11) Field<BigDecimal> stddevPop() This method is part of the pre-2.0 API. WindowPartitionByStep<BigDecimal> stddevPopOver() This method is part of the pre-2.0 API. Field<BigDecimal> stddevSamp() This method is part of the pre-2.0 API. WindowPartitionByStep<BigDecimal> stddevSampOver() This method is part of the pre-2.0 API. 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) This method is part of the pre-2.0 API. Field<String> substring(Field<? extends Number> startingPosition, Field<? extends Number> length) This method is part of the pre-2.0 API. Field<String> substring(int startingPosition) This method is part of the pre-2.0 API. Field<String> substring(int startingPosition, int length) This method is part of the pre-2.0 API. Field<BigDecimal> sum() This method is part of the pre-2.0 API. WindowPartitionByStep<BigDecimal> sumOver() This method is part of the pre-2.0 API. Field<BigDecimal> tan() This method is part of the pre-2.0 API. Field<BigDecimal> tanh() This method is part of the pre-2.0 API. Field<String> trim() This method is part of the pre-2.0 API. Field<String> upper() This method is part of the pre-2.0 API. Field<BigDecimal> varPop() This method is part of the pre-2.0 API. WindowPartitionByStep<BigDecimal> varPopOver() This method is part of the pre-2.0 API. Field<BigDecimal> varSamp() This method is part of the pre-2.0 API. WindowPartitionByStep<BigDecimal> varSampOver() This method is part of the pre-2.0 API. Methods inherited from interface org.jooq.QueryPart attach Methods inherited from interface org.jooq.Adapter internalAPI Methods inherited from interface java.lang.Comparable compareTo Method Detail getName String getName() The name of the field. The name is any of these: The formal name of the field, if it is a physical table/view field The alias of an aliased field A generated / unspecified value for any other expression The name of a parameter if it is a named Param Specified by: getName in interface NamedQueryPart getType Class<? extends T> getType() The Java type of the field. Specified by: getType in interface NamedTypeProviderQueryPart<T> getDataType DataType<T> getDataType() The type of this field (might not be dialect-specific) Specified by: getDataType in interface NamedTypeProviderQueryPart<T> getDataType DataType<T> getDataType(Configuration configuration) The dialect-specific type of this field Specified by: getDataType in interface NamedTypeProviderQueryPart<T> as @Support Field<T> as(String alias) Create an alias for this field Specified by: as in interface AliasProvider<Field<T>> Parameters: alias - The alias name Returns: The field alias equals boolean equals(Object other) Watch out! This is Object.equals(Object), not a jOOQ feature! :-) Overrides: equals in class Object isNullLiteral boolean isNullLiteral() 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. cast @Support <Z> Field<Z> cast(Field<Z> field) Cast this field to the type of another field. This results in the same as casting this field to DataType.getCastTypeName() Type Parameters: Z - The generic type of the cast field Parameters: field - The field whose type is used for the cast Returns: The cast field See Also: cast(DataType) cast @Support <Z> Field<Z> cast(DataType<Z> type) Cast this field to a dialect-specific data type. Type Parameters: Z - The generic type of the cast field Parameters: type - cast @Support <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. Use cast(DataType) for more accurate casts. Type Parameters: Z - The generic type of the cast field Parameters: type - The type that is used for the cast Returns: The cast field See Also: cast(DataType) asc @Support SortField<T> asc() Create an ascending sort field from this field This is the same as calling sort(SortOrder) with SortOrder.ASC Returns: This field as an ascending sort field desc @Support SortField<T> desc() Create a descending sort field from this field This is the same as calling sort(SortOrder) with SortOrder.DESC Returns: This field as a descending sort field sort @Support SortField<T> sort(SortOrder order) Create an ascending/descending sort field from this field Parameters: order - The sort order Returns: This field as an ascending/descending sort field. sortAsc @Support 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 ... WHEN [sortList.get(n)] THEN n ELSE null END ASC Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority. Parameters: sortList - The list containing sort value preferences Returns: The sort field sortAsc @Support SortField<Integer> sortAsc(T... sortList) Create a sort field of the form CASE [this] WHEN [sortList[0]] THEN 0 WHEN [sortList[1]] THEN 1 ... WHEN [sortList[n]] THEN n ELSE null END ASC Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority. Parameters: sortList - The list containing sort value preferences Returns: The sort field sortDesc @Support 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 ... WHEN [sortList.get(n)] THEN n ELSE null END DESC Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority. Parameters: sortList - The list containing sort value preferences Returns: The sort field sortDesc @Support SortField<Integer> sortDesc(T... sortList) Create a sort field of the form CASE [this] WHEN [sortList[0]] THEN 0 WHEN [sortList[1]] THEN 1 ... WHEN [sortList[n]] THEN n ELSE null END DESC Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority. Parameters: sortList - The list containing sort value preferences Returns: The sort field sort @Support <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) ... WHEN [sortMap.key(n)] THEN sortMap.value(n) ELSE null END DESC Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority. Parameters: sortMap - The list containing sort value preferences Returns: The sort field neg @Support Field<T> neg() Negate this field to get its negative value. This renders the same on all dialects: -[this] add @Support Field<T> add(Number value) An arithmetic expression adding this to value. See Also: add(Field) add @Support Field<T> add(Field<?> value) An arithmetic expression to add value to this. The behaviour of this operation is as follows: Operand 1 Operand 2 Result Type Numeric Numeric Numeric Date / Time Numeric Date / Time Date / Time Interval Date / Time Interval Interval Interval sub @Support Field<T> sub(Number value) An arithmetic expression subtracting value from this. See Also: sub(Field) sub @Support Field<T> sub(Field<?> value) An arithmetic expression subtracting value from this. Operand 1 Operand 2 Result Type Numeric Numeric Numeric Date / Time Numeric Date / Time Date / Time Interval Date / Time Interval Interval Interval In order to subtract one date time field from another, use any of these methods: Factory.dateDiff(Field, Field) Factory.timestampDiff(Field, Field) mul @Support Field<T> mul(Number value) An arithmetic expression multiplying this with value If this is a numeric field, then the result is a number of the same type as this field. If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval) mul @Support Field<T> mul(Field<? extends Number> value) An arithmetic expression multiplying this with value If this is a numeric field, then the result is a number of the same type as this field. If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval) div @Support Field<T> div(Number value) An arithmetic expression dividing this by value If this is a numeric field, then the result is a number of the same type as this field. If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval) div @Support Field<T> div(Field<? extends Number> value) An arithmetic expression dividing this by value If this is a numeric field, then the result is a number of the same type as this field. If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval) mod @Support Field<T> mod(Number value) An arithmetic expression getting the modulo of this divided by value This renders the modulo operation where available: [this] % [value] ... or the modulo function elsewhere: mod([this], [value]) mod @Support 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]) isNull @Support Condition isNull() Create a condition to check this field against null. SQL: this is null isNotNull @Support Condition isNotNull() Create a condition to check this field against null. SQL: this is not null isDistinctFrom @Support Condition isDistinctFrom(T value) Create a condition to check if this field is DISTINCT from another value If this is not supported by the underlying database, jOOQ will render this instead: CASE WHEN [this] IS NULL AND [value] IS NULL THEN FALSE WHEN [this] IS NULL AND [value] IS NOT NULL THEN TRUE WHEN [this] IS NOT NULL AND [value] IS NULL THEN TRUE WHEN [this] = [value] THEN FALSE ELSE TRUE END SQL: this is distinct from value isDistinctFrom @Support Condition isDistinctFrom(Field<T> field) Create a condition to check if this field is DISTINCT from another field If this is not supported by the underlying database, jOOQ will render this instead: CASE WHEN [this] IS NULL AND [field] IS NULL THEN FALSE WHEN [this] IS NULL AND [field] IS NOT NULL THEN TRUE WHEN [this] IS NOT NULL AND [field] IS NULL THEN TRUE WHEN [this] = [field] THEN FALSE ELSE TRUE END SQL: this is distinct from field isNotDistinctFrom @Support Condition isNotDistinctFrom(T value) Create a condition to check if this field is NOT DISTINCT from another value If this is not supported by the underlying database, jOOQ will render this instead: CASE WHEN [this] IS NULL AND [value] IS NULL THEN TRUE WHEN [this] IS NULL AND [value] IS NOT NULL THEN FALSE WHEN [this] IS NOT NULL AND [value] IS NULL THEN FALSE WHEN [this] = [value] THEN TRUE ELSE FALSE END SQL: this is not distinct from value isNotDistinctFrom @Support Condition isNotDistinctFrom(Field<T> field) Create a condition to check if this field is NOT DISTINCT from another field If this is not supported by the underlying database, jOOQ will render this instead: CASE WHEN [this] IS NULL AND [field] IS NULL THEN TRUE WHEN [this] IS NULL AND [field] IS NOT NULL THEN FALSE WHEN [this] IS NOT NULL AND [field] IS NULL THEN FALSE WHEN [this] = [value] THEN TRUE ELSE FALSE END SQL: this is not distinct from field likeRegex @Support(value={CUBRID,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLITE,SYBASE}) Condition likeRegex(String pattern) Create a condition to regex-pattern-check this field against a pattern The SQL:2008 standard specifies a <regex like predicate> of the following form: <regex like predicate> ::= <row value predicand> <regex like predicate part 2> <regex like predicate part 2> ::= [ NOT ] LIKE_REGEX <XQuery pattern> [ FLAG <XQuery option flag> ] This particular LIKE_REGEX operator comes in several flavours for various databases. jOOQ supports regular expressions as follows: SQL dialect SQL syntax Pattern syntax Documentation SQLDialect.ASE - - - SQLDialect.CUBRID [search] REGEXP [pattern] POSIX http://www.cubrid.org/manual/841/en/REGEXP Conditional Expression SQLDialect.DB2 - - - SQLDialect.DERBY - - - SQLDialect.H2 [search] REGEXP [pattern] Java http ://www.h2database.com/html/grammar.html#condition_right_hand_side SQLDialect.HSQLDB REGEXP_MATCHES([search], [pattern]) Java http://hsqldb.org/doc/guide/builtinfunctions-chapt.html#N13577 SQLDialect.INGRES - - - SQLDialect.MYSQL [search] REGEXP [pattern] POSIX http://dev.mysql.com/doc/refman/5.6/en/regexp.html SQLDialect.ORACLE REGEXP_LIKE([search], [pattern]) POSIX http://docs.oracle.com/cd/E14072_01/server.112/e10592/conditions007.htm# sthref1994 SQLDialect.POSTGRES [search] ~ [pattern] POSIX http://www.postgresql.org/docs/9.1/static/functions-matching.html# FUNCTIONS-POSIX-REGEXP SQLDialect.SQLITE [search] REGEXP [pattern] ? This module has to be loaded explicitly http://www.sqlite.org/ lang_expr.html SQLDialect.SQLSERVER - - - SQLDialect.SYBASE [search] REGEXP [pattern] Perl http://infocenter.sybase.com/help/topic/com.sybase.help.sqlanywhere.12.0 .1/dbreference/like-regexp-similarto.html See Also: likeRegex(String) likeRegex @Support(value={CUBRID,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLITE,SYBASE}) Condition likeRegex(Field<String> pattern) Create a condition to regex-pattern-check this field against a pattern See likeRegex(String) for more details See Also: likeRegex(String) notLikeRegex @Support(value={CUBRID,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLITE,SYBASE}) Condition notLikeRegex(String pattern) Create a condition to regex-pattern-check this field against a pattern See likeRegex(String) for more details See Also: likeRegex(String) notLikeRegex @Support(value={CUBRID,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLITE,SYBASE}) Condition notLikeRegex(Field<String> pattern) Create a condition to regex-pattern-check this field against a pattern See likeRegex(String) for more details See Also: likeRegex(Field) like @Support Condition like(Field<String> value) Create a condition to pattern-check this field against a value SQL: this like value like @Support Condition like(Field<String> value, char escape) Create a condition to pattern-check this field against a value SQL: this like value escape 'e' like @Support Condition like(String value) Create a condition to pattern-check this field against a value SQL: this like value like @Support Condition like(String value, char escape) Create a condition to pattern-check this field against a value SQL: this like value escape 'e' likeIgnoreCase @Support Condition likeIgnoreCase(Field<String> field) Create a condition to case-insensitively pattern-check this field against a field This translates to this ilike field in SQLDialect.POSTGRES, or to lower(this) like lower(field) in all other dialects. likeIgnoreCase @Support Condition likeIgnoreCase(Field<String> field, char escape) Create a condition to case-insensitively pattern-check this field against a field This translates to this ilike field in SQLDialect.POSTGRES, or to lower(this) like lower(field) in all other dialects. likeIgnoreCase @Support Condition likeIgnoreCase(String value) Create a condition to case-insensitively pattern-check this field against a value This translates to this ilike value in SQLDialect.POSTGRES, or to lower(this) like lower(value) in all other dialects. likeIgnoreCase @Support Condition likeIgnoreCase(String value, char escape) Create a condition to case-insensitively pattern-check this field against a value This translates to this ilike value in SQLDialect.POSTGRES, or to lower(this) like lower(value) in all other dialects. notLike @Support Condition notLike(Field<String> field) Create a condition to pattern-check this field against a field SQL: this not like field notLike @Support Condition notLike(Field<String> field, char escape) Create a condition to pattern-check this field against a field SQL: this not like field escape 'e' notLike @Support Condition notLike(String value) Create a condition to pattern-check this field against a value SQL: this not like value notLike @Support Condition notLike(String value, char escape) Create a condition to pattern-check this field against a value SQL: this not like value escape 'e' notLikeIgnoreCase @Support Condition notLikeIgnoreCase(Field<String> field) Create a condition to case-insensitively pattern-check this field against a field This translates to this not ilike field in SQLDialect.POSTGRES, or to lower(this) not like lower(field) in all other dialects. notLikeIgnoreCase @Support Condition notLikeIgnoreCase(Field<String> field, char escape) Create a condition to case-insensitively pattern-check this field against a field This translates to this not ilike field in SQLDialect.POSTGRES, or to lower(this) not like lower(field) in all other dialects. notLikeIgnoreCase @Support Condition notLikeIgnoreCase(String value) Create a condition to case-insensitively pattern-check this field against a value This translates to this not ilike value in SQLDialect.POSTGRES, or to lower(this) not like lower(value) in all other dialects. notLikeIgnoreCase @Support Condition notLikeIgnoreCase(String value, char escape) Create a condition to case-insensitively pattern-check this field against a value This translates to this not ilike value in SQLDialect.POSTGRES, or to lower(this) not like lower(value) in all other dialects. contains @Support Condition contains(T value) Convenience method for like(String, char) including proper adding of wildcards and escaping SQL: this like ('%' || escape(value, '\') || '%') escape '\' Note: This also works with numbers, for instance val(1133).contains(13) If you're using SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator. For example: // Use this expression val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 }) // ... to render this SQL ARRAY[1, 2, 3] @> ARRAY[1, 2] Note, this does not correspond to the Oracle Text CONTAINS() function. Refer to OracleFactory.contains(Field, String) instead. See Also: Factory.escape(String, char), like(String, char) contains @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,SQLITE}) Condition contains(Field<T> value) Convenience method for like(String, char) including proper adding of wildcards and escaping SQL: this like ('%' || escape(value, '\') || '%') escape '\' Note: This also works with numbers, for instance val(1133).contains(13) If you're using SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator. For example: // Use this expression val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 }) // ... to render this SQL ARRAY[1, 2, 3] @> ARRAY[1, 2] Note, this does not correspond to the Oracle Text CONTAINS() function. Refer to OracleFactory.contains(Field, String) instead. See Also: Factory.escape(Field, char), like(Field, char) startsWith @Support Condition startsWith(T value) Convenience method for like(String, char) including proper adding of wildcards and escaping SQL: this like (escape(value, '\') || '%') escape '\' Note: This also works with numbers, for instance val(1133).startsWith(11) See Also: Factory.escape(String, char), like(String, char) startsWith @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,SQLITE}) Condition startsWith(Field<T> value) Convenience method for like(String, char) including proper adding of wildcards and escaping SQL: this like (escape(value, '\') || '%') escape '\' Note: This also works with numbers, for instance val(1133).startsWith(11) See Also: Factory.escape(Field, char), like(Field, char) endsWith @Support Condition endsWith(T value) Convenience method for like(String, char) including proper adding of wildcards and escaping SQL: this like ('%' || escape(value, '\')) escape '\' Note: This also works with numbers, for instance val(1133).endsWith(33) See Also: Factory.escape(String, char), like(String, char) endsWith @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,SQLITE}) Condition endsWith(Field<T> value) Convenience method for like(String, char) including proper adding of wildcards and escaping SQL: this like ('%' || escape(value, '\')) escape '\' Note: This also works with numbers, for instance val(1133).endsWith(33) See Also: Factory.escape(Field, char), like(Field, char) in @Support Condition in(Collection<T> values) Create a condition to check this field against several values SQL: this in (values...) in @Support Condition in(T... values) Create a condition to check this field against several values SQL: this in (values...) in @Support Condition in(Field<?>... values) Create a condition to check this field against several values SQL: this in (values...) in @Support Condition in(Select<?> query) Create a condition to check this field against a subquery Note that the subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly. SQL: this in (select...) notIn @Support 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. This is standard SQL behaviour. SQL: this not in (values...) notIn @Support Condition notIn(T... values) Create a condition to check this field against several values Note that if any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well. This is standard SQL behaviour. SQL: this not in (values...) notIn @Support Condition notIn(Field<?>... values) Create a condition to check this field against several values Note that if any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well. This is standard SQL behaviour. SQL: this not in (values...) notIn @Support Condition notIn(Select<?> query) Create a condition to check this field against a subquery Note that the subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly. Note that if any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well. This is standard SQL behaviour. SQL: this not in (select...) between @Support Condition between(T minValue, T maxValue) Create a condition to check this field against some bounds This is the same as calling between(minValue).and(maxValue) SQL: this between minValue and maxValue between @Support Condition between(Field<T> minValue, Field<T> maxValue) Create a condition to check this field against some bounds This is the same as calling between(minValue).and(maxValue) SQL: this between minValue and maxValue betweenSymmetric @Support Condition betweenSymmetric(T minValue, T maxValue) Create a condition to check this field against some bounds This is the same as calling betweenSymmetric(minValue).and(maxValue) SQL: this between symmetric minValue and maxValue betweenSymmetric @Support Condition betweenSymmetric(Field<T> minValue, Field<T> maxValue) Create a condition to check this field against some bounds This is the same as calling betweenSymmetric(minValue).and(maxValue) SQL: this between symmetric minValue and maxValue notBetween @Support Condition notBetween(T minValue, T maxValue) Create a condition to check this field against some bounds This is the same as calling notBetween(minValue).and(maxValue) SQL: this not between minValue and maxValue notBetween @Support Condition notBetween(Field<T> minValue, Field<T> maxValue) Create a condition to check this field against some bounds This is the same as calling notBetween(minValue).and(maxValue) SQL: this not between minValue and maxValue notBetweenSymmetric @Support Condition notBetweenSymmetric(T minValue, T maxValue) Create a condition to check this field against some bounds This is the same as calling notBetweenSymmetric(minValue).and(maxValue) SQL: this not between symmetric minValue and maxValue notBetweenSymmetric @Support Condition notBetweenSymmetric(Field<T> minValue, Field<T> maxValue) Create a condition to check this field against some bounds This is the same as calling notBetweenSymmetric(minValue).and(maxValue) SQL: this not between symmetric minValue and maxValue between @Support BetweenAndStep<T> between(T minValue) Create a condition to check this field against some bounds SQL: this between minValue and maxValue between @Support BetweenAndStep<T> between(Field<T> minValue) Create a condition to check this field against some bounds SQL: this between minValue and maxValue betweenSymmetric @Support BetweenAndStep<T> betweenSymmetric(T minValue) Create a condition to check this field against some bounds SQL: this between symmetric minValue and maxValue betweenSymmetric @Support BetweenAndStep<T> betweenSymmetric(Field<T> minValue) Create a condition to check this field against some bounds SQL: this between symmetric minValue and maxValue notBetween @Support BetweenAndStep<T> notBetween(T minValue) Create a condition to check this field against some bounds SQL: this not between minValue and maxValue notBetween @Support BetweenAndStep<T> notBetween(Field<T> minValue) Create a condition to check this field against some bounds SQL: this not between minValue and maxValue notBetweenSymmetric @Support BetweenAndStep<T> notBetweenSymmetric(T minValue) Create a condition to check this field against some bounds SQL: this not between symmetric minValue and maxValue notBetweenSymmetric @Support BetweenAndStep<T> notBetweenSymmetric(Field<T> minValue) Create a condition to check this field against some bounds SQL: this not between symmetric minValue and maxValue compare @Support Condition compare(Comparator comparator, T value) Compare this field with a value using a dynamic comparator Parameters: comparator - The comparator to use for comparing this field with a value value - The value to compare this field with Returns: A comparison predicate compare @Support Condition compare(Comparator comparator, Field<T> field) Compare this field with another field using a dynamic comparator Parameters: comparator - The comparator to use for comparing this field with another field field - The field to compare this field with Returns: A comparison predicate equal @Support Condition equal(T value) this = value If value == null, then this will return a condition equivalent to isNull() for convenience. SQL's ternary NULL logic is rarely of use for Java programmers. equal @Support Condition equal(Field<T> field) this = field equal @Support Condition equal(Select<?> query) this = (Select ...) eq @Support Condition eq(T value) this = value If value == null, then this will return a condition equivalent to isNull() for convenience. SQL's ternary NULL logic is rarely of use for Java programmers. See Also: equal(Object) eq @Support Condition eq(Field<T> field) this = field See Also: equal(Field) eq @Support Condition eq(Select<?> query) this = (Select ...) See Also: equal(Select) notEqual @Support Condition notEqual(T value) this != value If value == null, then this will return a condition equivalent to isNotNull() for convenience. SQL's ternary NULL logic is rarely of use for Java programmers. notEqual @Support Condition notEqual(Field<T> field) this != field notEqual @Support Condition notEqual(Select<?> query) this != (Select ...) ne @Support Condition ne(T value) this != value If value == null, then this will return a condition equivalent to isNotNull() for convenience. SQL's ternary NULL logic is rarely of use for Java programmers. See Also: notEqual(Object) ne @Support Condition ne(Field<T> field) this != field See Also: notEqual(Field) ne @Support Condition ne(Select<?> query) this != (Select ...) See Also: notEqual(Select) lessThan @Support Condition lessThan(T value) this < value lessThan @Support Condition lessThan(Field<T> field) this < field lessThan @Support Condition lessThan(Select<?> query) this < (Select ...) lt @Support Condition lt(T value) this < value See Also: lessThan(Object) lt @Support Condition lt(Field<T> field) this < field See Also: lessThan(Field) lt @Support Condition lt(Select<?> query) this < (Select ...) See Also: lessThan(Select) lessOrEqual @Support Condition lessOrEqual(T value) this <= value lessOrEqual @Support Condition lessOrEqual(Field<T> field) this <= field lessOrEqual @Support Condition lessOrEqual(Select<?> query) this <= (Select ...) le @Support Condition le(T value) this <= value See Also: lessOrEqual(Object) le @Support Condition le(Field<T> field) this <= field See Also: lessOrEqual(Field) le @Support Condition le(Select<?> query) this <= (Select ...) See Also: lessOrEqual(Select) greaterThan @Support Condition greaterThan(T value) this > value greaterThan @Support Condition greaterThan(Field<T> field) this > field greaterThan @Support Condition greaterThan(Select<?> query) this > (Select ...) gt @Support Condition gt(T value) this > value See Also: greaterThan(Object) gt @Support Condition gt(Field<T> field) this > field See Also: greaterThan(Field) gt @Support Condition gt(Select<?> query) this > (Select ...) See Also: greaterThan(Select) greaterOrEqual @Support Condition greaterOrEqual(T value) this >= value greaterOrEqual @Support Condition greaterOrEqual(Field<T> field) this >= field greaterOrEqual @Support Condition greaterOrEqual(Select<?> query) this >= (Select ...) ge @Support Condition ge(T value) this >= value See Also: greaterOrEqual(Object) ge @Support Condition ge(Field<T> field) this >= field See Also: greaterOrEqual(Field) ge @Support Condition ge(Select<?> query) this >= (Select ...) See Also: greaterOrEqual(Select) isTrue @Support Condition isTrue() Create a condition to check this field against known string literals for true SQL: lcase(this) in ("1", "y", "yes", "true", "on", "enabled") isFalse @Support Condition isFalse() Create a condition to check this field against known string literals for false SQL: lcase(this) in ("0", "n", "no", "false", "off", "disabled") equalIgnoreCase @Support Condition equalIgnoreCase(String value) lower(this) = lower(value) equalIgnoreCase @Support Condition equalIgnoreCase(Field<String> value) lower(this) = lower(value) notEqualIgnoreCase @Support Condition notEqualIgnoreCase(String value) lower(this) != lower(value) notEqualIgnoreCase @Support Condition notEqualIgnoreCase(Field<String> value) lower(this) != lower(value) equalAny @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition equalAny(Select<?> query) this = any (Select ...) equalAny @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition equalAny(T... array) this = any (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. equalAny @Support(value={H2,CUBRID,HSQLDB,POSTGRES}) Condition equalAny(Field<T[]> array) this = any (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. equalSome @Deprecated @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition equalSome(Select<?> query) Deprecated. - 2.0.2 - Use equalAny(Select) instead this = some (Select ...) equalAll @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition equalAll(Select<?> query) this = all (Select ...) equalAll @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition equalAll(T... array) this = all (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. equalAll @Support(value={H2,HSQLDB,POSTGRES}) Condition equalAll(Field<T[]> array) this = all (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. notEqualAny @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition notEqualAny(Select<?> query) this != any (Select ...) notEqualAny @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition notEqualAny(T... array) this != any (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. notEqualAny @Support(value={H2,HSQLDB,POSTGRES}) Condition notEqualAny(Field<T[]> array) this != any (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. notEqualSome @Deprecated @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition notEqualSome(Select<?> query) Deprecated. - 2.0.2 - Use notEqualAny(Select) instead this != some (Select ...) notEqualAll @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition notEqualAll(Select<?> query) this != all (Select ...) notEqualAll @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition notEqualAll(T... array) this != all (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. notEqualAll @Support(value={H2,HSQLDB,POSTGRES}) Condition notEqualAll(Field<T[]> array) this != all (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. lessThanAny @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessThanAny(Select<?> query) this < any (Select ...) lessThanAny @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessThanAny(T... array) this < any (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. lessThanAny @Support(value={H2,HSQLDB,POSTGRES}) Condition lessThanAny(Field<T[]> array) this < any (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. lessThanSome @Deprecated @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessThanSome(Select<?> query) Deprecated. - 2.0.2 - Use lessThanAny(Select) instead this < some (Select ...) lessThanAll @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessThanAll(Select<?> query) this < all (Select ...) lessThanAll @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessThanAll(T... array) this < all (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. lessThanAll @Support(value={H2,HSQLDB,POSTGRES}) Condition lessThanAll(Field<T[]> array) this < all (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. lessOrEqualAny @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessOrEqualAny(Select<?> query) this <= any (Select ...) lessOrEqualAny @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessOrEqualAny(T... array) this <= any (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. lessOrEqualAny @Support(value={H2,HSQLDB,POSTGRES}) Condition lessOrEqualAny(Field<T[]> array) this <= any (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. lessOrEqualSome @Deprecated @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessOrEqualSome(Select<?> query) Deprecated. - 2.0.2 - Use lessOrEqualAny(Select) instead this <= some (Select ...) lessOrEqualAll @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessOrEqualAll(Select<?> query) this <= all (Select ...) lessOrEqualAll @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessOrEqualAll(T... array) this <= all (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. lessOrEqualAll @Support(value={H2,HSQLDB,POSTGRES}) Condition lessOrEqualAll(Field<T[]> array) this <= all (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. greaterThanAny @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterThanAny(Select<?> query) this > any (Select ...) greaterThanAny @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterThanAny(T... array) this > any (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. greaterThanAny @Support(value={H2,HSQLDB,POSTGRES}) Condition greaterThanAny(Field<T[]> array) this > any (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. greaterThanSome @Deprecated @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterThanSome(Select<?> query) Deprecated. - 2.0.2 - Use greaterThanAny(Select) instead this > some (Select ...) greaterThanAll @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterThanAll(Select<?> query) this > all (Select ...) greaterThanAll @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterThanAll(T... array) this > all (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. greaterThanAll @Support(value={H2,HSQLDB,POSTGRES}) Condition greaterThanAll(Field<T[]> array) this > all (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. greaterOrEqualAny @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterOrEqualAny(Select<?> query) this >= any (Select ...) greaterOrEqualAny @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterOrEqualAny(T... array) this >= any (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. greaterOrEqualAny @Support(value={H2,HSQLDB,POSTGRES}) Condition greaterOrEqualAny(Field<T[]> array) this >= any (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. greaterOrEqualSome @Deprecated @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterOrEqualSome(Select<?> query) Deprecated. - 2.0.2 - Use greaterOrEqualAny(Select) instead this >= some (Select ...) greaterOrEqualAll @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterOrEqualAll(Select<?> query) this >= all (Select ...) greaterOrEqualAll @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterOrEqualAll(T... array) this >= all (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. greaterOrEqualAll @Support(value={H2,HSQLDB,POSTGRES}) Condition greaterOrEqualAll(Field<T[]> array) this >= all (array) This is natively supported by SQLDialect.POSTGRES. Other dialects will render a subselect unnesting the array. sign @Support Field<Integer> sign() This method is part 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 See Also: Factory.sign(Field) abs @Support Field<T> abs() This method is part 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 See Also: Factory.abs(Field) round @Support Field<T> round() This method is part 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 See Also: Factory.round(Field) round @Support Field<T> round(int decimals) This method is part 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 See Also: Factory.round(Field, int) floor @Support Field<T> floor() This method is part 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 See Also: Factory.floor(Field) ceil @Support Field<T> ceil() This method is part 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 See Also: Factory.ceil(Field) sqrt @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> sqrt() This method is part 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 See Also: Factory.sqrt(Field) exp @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> exp() This method is part 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 See Also: Factory.exp(Field) ln @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> ln() This method is part 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 See Also: Factory.ln(Field) log @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> log(int base) This method is part 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 See Also: Factory.log(Field, int) power @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> power(Number exponent) This method is part 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 See Also: Factory.power(Field, Number) acos @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> acos() This method is part 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 See Also: Factory.acos(Field) asin @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> asin() This method is part 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 See Also: Factory.asin(Field) atan @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> atan() This method is part 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 See Also: Factory.atan(Field) atan2 @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> atan2(Number y) This method is part 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 See Also: Factory.atan2(Field, Number) atan2 @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> atan2(Field<? extends Number> y) This method is part 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 See Also: Factory.atan2(Field, Field) cos @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> cos() This method is part 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 See Also: Factory.cos(Field) sin @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> sin() This method is part 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 See Also: Factory.sin(Field) tan @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> tan() This method is part 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 See Also: Factory.tan(Field) cot @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> cot() This method is part 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 See Also: Factory.cot(Field) sinh @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> sinh() This method is part 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 See Also: Factory.sinh(Field) cosh @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> cosh() This method is part 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 See Also: Factory.cosh(Field) tanh @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> tanh() This method is part 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 See Also: Factory.tanh(Field) coth @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> coth() This method is part 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 See Also: Factory.coth(Field) deg @Support Field<BigDecimal> deg() This method is part 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 See Also: Factory.deg(Field) rad @Support Field<BigDecimal> rad() This method is part 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 See Also: Factory.rad(Field) count @Support Field<Integer> count() This method is part 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 See Also: Factory.count(Field) countDistinct @Support Field<Integer> countDistinct() This method is part 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 See Also: Factory.countDistinct(Field) max @Support Field<T> max() This method is part 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 See Also: Factory.max(Field) min @Support Field<T> min() This method is part 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 See Also: Factory.min(Field) sum @Support Field<BigDecimal> sum() This method is part 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 See Also: Factory.sum(Field) avg @Support Field<BigDecimal> avg() This method is part 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 See Also: Factory.avg(Field) median @Support(value={HSQLDB,ORACLE,SYBASE}) Field<BigDecimal> median() This method is part 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 See Also: Factory.median(Field) stddevPop @Support(value={ASE,CUBRID,DB2,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> stddevPop() This method is part 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 See Also: Factory.stddevPop(Field) stddevSamp @Support(value={ASE,CUBRID,DB2,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> stddevSamp() This method is part 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 See Also: Factory.stddevSamp(Field) varPop @Support(value={ASE,CUBRID,DB2,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> varPop() This method is part 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 See Also: Factory.varPop(Field) varSamp @Support(value={ASE,CUBRID,DB2,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<BigDecimal> varSamp() This method is part 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 See Also: Factory.varSamp(Field) countOver @Support(value={DB2,POSTGRES,ORACLE,SQLSERVER,SYBASE}) WindowPartitionByStep<Integer> countOver() This method is part 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 See Also: Factory.count(Field), AggregateFunction.over() maxOver @Support(value={DB2,POSTGRES,ORACLE,SQLSERVER,SYBASE}) WindowPartitionByStep<T> maxOver() This method is part 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 See Also: Factory.max(Field), AggregateFunction.over() minOver @Support(value={DB2,POSTGRES,ORACLE,SQLSERVER,SYBASE}) WindowPartitionByStep<T> minOver() This method is part 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 See Also: Factory.min(Field), AggregateFunction.over() sumOver @Support(value={DB2,POSTGRES,ORACLE,SQLSERVER,SYBASE}) WindowPartitionByStep<BigDecimal> sumOver() This method is part 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 See Also: Factory.sum(Field), AggregateFunction.over() avgOver @Support(value={DB2,POSTGRES,ORACLE,SQLSERVER,SYBASE}) WindowPartitionByStep<BigDecimal> avgOver() This method is part 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 See Also: Factory.avg(Field), AggregateFunction.over() firstValue @Support(value={DB2,POSTGRES,ORACLE,SYBASE}) WindowIgnoreNullsStep<T> firstValue() This method is part 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 See Also: Factory.firstValue(Field), AggregateFunction.over() lastValue @Support(value={DB2,POSTGRES,ORACLE,SYBASE}) WindowIgnoreNullsStep<T> lastValue() This method is part 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 See Also: Factory.lastValue(Field), AggregateFunction.over() lead @Support(value={DB2,POSTGRES,ORACLE}) WindowIgnoreNullsStep<T> lead() This method is part 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 See Also: Factory.lead(Field), AggregateFunction.over() lead @Support(value={DB2,POSTGRES,ORACLE}) WindowIgnoreNullsStep<T> lead(int offset) This method is part 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 See Also: Factory.lead(Field, int), AggregateFunction.over() lead @Support(value={DB2,POSTGRES,ORACLE}) WindowIgnoreNullsStep<T> lead(int offset, T defaultValue) This method is part 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 See Also: Factory.lead(Field, int, Object), AggregateFunction.over() lead @Support(value={DB2,POSTGRES,ORACLE}) WindowIgnoreNullsStep<T> lead(int offset, Field<T> defaultValue) This method is part 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 See Also: Factory.lead(Field, int, Field), AggregateFunction.over() lag @Support(value={DB2,POSTGRES,ORACLE}) WindowIgnoreNullsStep<T> lag() This method is part 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 See Also: Factory.lag(Field), AggregateFunction.over() lag @Support(value={DB2,POSTGRES,ORACLE}) WindowIgnoreNullsStep<T> lag(int offset) This method is part 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 See Also: Factory.lag(Field, int), AggregateFunction.over() lag @Support(value={DB2,POSTGRES,ORACLE}) WindowIgnoreNullsStep<T> lag(int offset, T defaultValue) This method is part 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 See Also: Factory.lag(Field, int, Object), AggregateFunction.over() lag @Support(value={DB2,POSTGRES,ORACLE}) WindowIgnoreNullsStep<T> lag(int offset, Field<T> defaultValue) This method is part 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 See Also: Factory.lag(Field, int, Field), AggregateFunction.over() stddevPopOver @Support(value={DB2,POSTGRES,ORACLE,SQLSERVER,SYBASE}) WindowPartitionByStep<BigDecimal> stddevPopOver() This method is part 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 See Also: Factory.stddevPop(Field), AggregateFunction.over() stddevSampOver @Support(value={DB2,POSTGRES,ORACLE,SQLSERVER,SYBASE}) WindowPartitionByStep<BigDecimal> stddevSampOver() This method is part 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 See Also: Factory.stddevSamp(Field), AggregateFunction.over() varPopOver @Support(value={DB2,POSTGRES,ORACLE,SQLSERVER,SYBASE}) WindowPartitionByStep<BigDecimal> varPopOver() This method is part 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 See Also: Factory.varPop(Field), AggregateFunction.over() varSampOver @Support(value={DB2,POSTGRES,ORACLE,SQLSERVER,SYBASE}) WindowPartitionByStep<BigDecimal> varSampOver() This method is part 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 See Also: Factory.varSamp(Field), AggregateFunction.over() upper @Support Field<String> upper() This method is part 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 See Also: Factory.upper(Field) lower @Support Field<String> lower() This method is part 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 See Also: Factory.lower(Field) trim @Support Field<String> trim() This method is part 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 See Also: Factory.trim(Field) rtrim @Support Field<String> rtrim() This method is part 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 See Also: Factory.rtrim(Field) ltrim @Support Field<String> ltrim() This method is part 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 See Also: Factory.ltrim(Field) rpad @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<String> rpad(Field<? extends Number> length) This method is part 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 See Also: Factory.rpad(Field, Field) rpad @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<String> rpad(int length) This method is part 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 See Also: Factory.rpad(Field, int) rpad @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<String> rpad(Field<? extends Number> length, Field<String> character) This method is part 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 See Also: Factory.rpad(Field, Field, Field) rpad @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<String> rpad(int length, char character) This method is part 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 See Also: Factory.rpad(Field, int, char) lpad @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<String> lpad(Field<? extends Number> length) This method is part 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 See Also: Factory.lpad(Field, Field) lpad @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<String> lpad(int length) This method is part 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 See Also: Factory.lpad(Field, int) lpad @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<String> lpad(Field<? extends Number> length, Field<String> character) This method is part 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 See Also: Factory.lpad(Field, Field, Field) lpad @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<String> lpad(int length, char character) This method is part 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 See Also: Factory.lpad(Field, int, char) repeat @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<String> repeat(Number count) This method is part 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 See Also: Factory.repeat(Field, int) repeat @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<String> repeat(Field<? extends Number> count) This method is part 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 See Also: Factory.repeat(Field, Field) replace @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,SQLITE}) Field<String> replace(Field<String> search) This method is part 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 See Also: Factory.replace(Field, Field) replace @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,SQLITE}) Field<String> replace(String search) This method is part 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 See Also: Factory.replace(Field, String) replace @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,SQLITE}) Field<String> replace(Field<String> search, Field<String> replace) This method is part 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 See Also: Factory.replace(Field, Field, Field) replace @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,SQLITE}) Field<String> replace(String search, String replace) This method is part 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 See Also: Factory.replace(Field, String, String) position @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<Integer> position(String search) This method is part 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 See Also: Factory.position(Field, String) position @Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<Integer> position(Field<String> search) This method is part 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 See Also: Factory.position(Field, Field) ascii @Support(value={ASE,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Field<Integer> ascii() This method is part 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 See Also: Factory.ascii(Field) concat @Support Field<String> concat(Field<?>... fields) This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory See Also: Factory.concat(Field...) concat @Support Field<String> concat(String... values) This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory See Also: Factory.concat(String...) substring @Support Field<String> substring(int startingPosition) This method is part 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 See Also: Factory.substring(Field, int) substring @Support Field<String> substring(Field<? extends Number> startingPosition) This method is part 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 See Also: Factory.substring(Field, Field) substring @Support Field<String> substring(int startingPosition, int length) This method is part 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 See Also: Factory.substring(Field, int, int) substring @Support Field<String> substring(Field<? extends Number> startingPosition, Field<? extends Number> length) This method is part 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 See Also: Factory.substring(Field, Field, Field) length @Support Field<Integer> length() This method is part 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 See Also: Factory.length(Field) charLength @Support Field<Integer> charLength() This method is part 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 See Also: Factory.charLength(Field) bitLength @Support Field<Integer> bitLength() This method is part 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 See Also: Factory.bitLength(Field) octetLength @Support Field<Integer> octetLength() This method is part 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 See Also: Factory.octetLength(Field) extract @Support Field<Integer> extract(DatePart datePart) This method is part 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 See Also: Factory.extract(Field, DatePart) greatest @Support Field<T> greatest(T... others) This method is part 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 See Also: Factory.greatest(Field, Field...) greatest @Support Field<T> greatest(Field<?>... others) This method is part 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 See Also: Factory.greatest(Field, Field...) least @Support Field<T> least(T... others) This method is part 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 See Also: Factory.least(Field, Field...) least @Support Field<T> least(Field<?>... others) This method is part 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 See Also: Factory.least(Field, Field...) nvl @Support Field<T> nvl(T defaultValue) This method is part 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 See Also: Factory.nvl(Field, Object) nvl @Support Field<T> nvl(Field<T> defaultValue) This method is part 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 See Also: Factory.nvl(Field, Field) nvl2 @Support <Z> Field<Z> nvl2(Z valueIfNotNull, Z valueIfNull) This method is part 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 See Also: Factory.nvl2(Field, Object, Object) nvl2 @Support <Z> Field<Z> nvl2(Field<Z> valueIfNotNull, Field<Z> valueIfNull) This method is part 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 See Also: Factory.nvl2(Field, Field, Field) nullif @Support Field<T> nullif(T other) This method is part 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 See Also: Factory.nullif(Field, Object) nullif @Support Field<T> nullif(Field<T> other) This method is part 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 See Also: Factory.nullif(Field, Field) decode @Support <Z> Field<Z> decode(T search, Z result) This method is part 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 See Also: Factory.decode(Object, Object, Object) decode @Support <Z> Field<Z> decode(T search, Z result, Object... more) This method is part 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 See Also: Factory.decode(Object, Object, Object, Object...) decode @Support <Z> Field<Z> decode(Field<T> search, Field<Z> result) This method is part 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 See Also: Factory.decode(Field, Field, Field) decode @Support <Z> Field<Z> decode(Field<T> search, Field<Z> result, Field<?>... more) This method is part 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 See Also: Factory.decode(Field, Field, Field, Field...) coalesce @Support Field<T> coalesce(T option, T... options) This method is part 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 See Also: Factory.coalesce(Object, Object...) coalesce @Support Field<T> coalesce(Field<T> option, Field<?>... options) This method is part 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 See Also: Factory.coalesce(Field, Field...) Overview Package Class Use Deprecated Index Help Prev Class Next Class Frames No Frames All Classes Summary: Nested | Field | Constr | Method Detail: Field | Constr | Method Copyright © 2013. All Rights Reserved.