Overview  Package   Class  Use  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

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
 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
 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.
 Condition between(Field<T> minValue, Field<T> maxValue)
          Create a condition to check this field against some bounds SQL: this between minValue and maxValue
 Condition between(T minValue, T maxValue)
          Create a condition to check this field against some bounds SQL: this between minValue and maxValue
 Condition betweenSymmetric(Field<T> minValue, Field<T> maxValue)
          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 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.
 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
 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
 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> 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(Field<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 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.
 Condition notBetween(Field<T> minValue, Field<T> maxValue)
          Create a condition to check this field against some bounds SQL: this not between minValue and maxValue
 Condition notBetween(T minValue, T maxValue)
          Create a condition to check this field against some bounds SQL: this not between minValue and maxValue
 Condition notBetweenSymmetric(Field<T> minValue, Field<T> maxValue)
          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 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> value)
          Create a condition to pattern-check this field against a value SQL: this not like value
 Condition notLike(Field<String> value, char escape)
          Create a condition to pattern-check this field against a value SQL: this not like value escape 'e'
 Condition notLike(String value)
          Create a condition to pattern-check this field against a value SQL: this not like value
 Condition notLike(String value, char escape)
          Create a condition to pattern-check this field against a value SQL: this not like value escape 'e'
 Condition notLikeIgnoreCase(Field<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(Field<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 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<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.NamedTypeProviderQueryPart
getDataType, getDataType
 
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>

as

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

<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

<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

<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

SortField<T> asc()
Create an ascending sort field from this field

Returns:
This field as an ascending sort field

desc

SortField<T> desc()
Create a descending sort field from this field

Returns:
This field as a descending sort field

sortAsc

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

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

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

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

<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

Field<T> neg()
Negate this field to get its negative value.

This renders the same on all dialects: 

-[this]

add

Field<T> add(Number value)
An arithmetic expression adding this to value.

See Also:
add(Field)

add

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

Field<T> sub(Number value)
An arithmetic expression subtracting value from this.

See Also:
sub(Field)

sub

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:

mul

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

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

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

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

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

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

Condition isNull()
Create a condition to check this field against null.

SQL: this is null

isNotNull

Condition isNotNull()
Create a condition to check this field against null.

SQL: this is not null

isDistinctFrom

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

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

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

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

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

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

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

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

Condition like(Field<String> value)
Create a condition to pattern-check this field against a value

SQL: this like value

like

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

Condition like(String value)
Create a condition to pattern-check this field against a value

SQL: this like value

like

Condition like(String value,
               char escape)
Create a condition to pattern-check this field against a value

SQL: this like value escape 'e'

likeIgnoreCase

Condition likeIgnoreCase(Field<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

Condition likeIgnoreCase(Field<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.

likeIgnoreCase

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

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

Condition notLike(Field<String> value)
Create a condition to pattern-check this field against a value

SQL: this not like value

notLike

Condition notLike(Field<String> value,
                  char escape)
Create a condition to pattern-check this field against a value

SQL: this not like value escape 'e'

notLike

Condition notLike(String value)
Create a condition to pattern-check this field against a value

SQL: this not like value

notLike

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

Condition notLikeIgnoreCase(Field<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

Condition notLikeIgnoreCase(Field<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.

notLikeIgnoreCase

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

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

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

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

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

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

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

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

Condition in(Collection<T> values)
Create a condition to check this field against several values

SQL: this in (values...)

in

Condition in(T... values)
Create a condition to check this field against several values

SQL: this in (values...)

in

Condition in(Field<?>... values)
Create a condition to check this field against several values

SQL: this in (values...)

in

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 on the database, if not used correctly.

SQL: this in (select...)

notIn

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

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

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

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 on the database, if not used correctly.

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

SQL: this not in (select...)

between

Condition between(T minValue,
                  T maxValue)
Create a condition to check this field against some bounds

SQL: this between minValue and maxValue

between

Condition between(Field<T> minValue,
                  Field<T> maxValue)
Create a condition to check this field against some bounds

SQL: this between minValue and maxValue

betweenSymmetric

Condition betweenSymmetric(T minValue,
                           T maxValue)
Create a condition to check this field against some bounds

SQL: this between symmetric minValue and maxValue

betweenSymmetric

Condition betweenSymmetric(Field<T> minValue,
                           Field<T> maxValue)
Create a condition to check this field against some bounds

SQL: this between symmetric minValue and maxValue

notBetween

Condition notBetween(T minValue,
                     T maxValue)
Create a condition to check this field against some bounds

SQL: this not between minValue and maxValue

notBetween

Condition notBetween(Field<T> minValue,
                     Field<T> maxValue)
Create a condition to check this field against some bounds

SQL: this not between minValue and maxValue

notBetweenSymmetric

Condition notBetweenSymmetric(T minValue,
                              T maxValue)
Create a condition to check this field against some bounds

SQL: this not between symmetric minValue and maxValue

notBetweenSymmetric

Condition notBetweenSymmetric(Field<T> minValue,
                              Field<T> maxValue)
Create a condition to check this field against some bounds

SQL: this not between symmetric minValue and maxValue

equal

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

Condition equal(Field<T> field)
this = field

equal

Condition equal(Select<?> query)
this = (Select ...)

eq

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

Condition eq(Field<T> field)
this = field

See Also:
equal(Field)

eq

Condition eq(Select<?> query)
this = (Select ...)

See Also:
equal(Select)

notEqual

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

Condition notEqual(Field<T> field)
this != field

notEqual

Condition notEqual(Select<?> query)
this != (Select ...)

ne

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

Condition ne(Field<T> field)
this != field

See Also:
notEqual(Field)

ne

Condition ne(Select<?> query)
this != (Select ...)

See Also:
notEqual(Select)

lessThan

Condition lessThan(T value)
this < value

lessThan

Condition lessThan(Field<T> field)
this < field

lessThan

Condition lessThan(Select<?> query)
this < (Select ...)

lt

Condition lt(T value)
this < value

See Also:
lessThan(Object)

lt

Condition lt(Field<T> field)
this < field

See Also:
lessThan(Field)

lt

Condition lt(Select<?> query)
this < (Select ...)

See Also:
lessThan(Select)

lessOrEqual

Condition lessOrEqual(T value)
this <= value

lessOrEqual

Condition lessOrEqual(Field<T> field)
this <= field

lessOrEqual

Condition lessOrEqual(Select<?> query)
this <= (Select ...)

le

Condition le(T value)
this <= value

See Also:
lessOrEqual(Object)

le

Condition le(Field<T> field)
this <= field

See Also:
lessOrEqual(Field)

le

Condition le(Select<?> query)
this <= (Select ...)

See Also:
lessOrEqual(Select)

greaterThan

Condition greaterThan(T value)
this > value

greaterThan

Condition greaterThan(Field<T> field)
this > field

greaterThan

Condition greaterThan(Select<?> query)
this > (Select ...)

gt

Condition gt(T value)
this > value

See Also:
greaterThan(Object)

gt

Condition gt(Field<T> field)
this > field

See Also:
greaterThan(Field)

gt

Condition gt(Select<?> query)
this > (Select ...)

See Also:
greaterThan(Select)

greaterOrEqual

Condition greaterOrEqual(T value)
this >= value

greaterOrEqual

Condition greaterOrEqual(Field<T> field)
this >= field

greaterOrEqual

Condition greaterOrEqual(Select<?> query)
this >= (Select ...)

ge

Condition ge(T value)
this >= value

See Also:
greaterOrEqual(Object)

ge

Condition ge(Field<T> field)
this >= field

See Also:
greaterOrEqual(Field)

ge

Condition ge(Select<?> query)
this >= (Select ...)

See Also:
greaterOrEqual(Select)

isTrue

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

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

Condition equalIgnoreCase(String value)
lower(this) = lower(value)

equalIgnoreCase

Condition equalIgnoreCase(Field<String> value)
lower(this) = lower(value)

notEqualIgnoreCase

Condition notEqualIgnoreCase(String value)
lower(this) != lower(value)

notEqualIgnoreCase

Condition notEqualIgnoreCase(Field<String> value)
lower(this) != lower(value)

equalAny

Condition equalAny(Select<?> query)
this = any (Select ...)

equalAny

Condition equalAny(T... array)
this = any (array)

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

equalAny

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
Condition equalSome(Select<?> query)
Deprecated. - 2.0.2 - Use equalAny(Select) instead

this = some (Select ...)

equalAll

Condition equalAll(Select<?> query)
this = all (Select ...)

equalAll

Condition equalAll(T... array)
this = all (array)

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

equalAll

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

Condition notEqualAny(Select<?> query)
this != any (Select ...)

notEqualAny

Condition notEqualAny(T... array)
this != any (array)

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

notEqualAny

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
Condition notEqualSome(Select<?> query)
Deprecated. - 2.0.2 - Use notEqualAny(Select) instead

this != some (Select ...)

notEqualAll

Condition notEqualAll(Select<?> query)
this != all (Select ...)

notEqualAll

Condition notEqualAll(T... array)
this != all (array)

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

notEqualAll

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

Condition lessThanAny(Select<?> query)
this < any (Select ...)

lessThanAny

Condition lessThanAny(T... array)
this < any (array)

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

lessThanAny

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
Condition lessThanSome(Select<?> query)
Deprecated. - 2.0.2 - Use lessThanAny(Select) instead

this < some (Select ...)

lessThanAll

Condition lessThanAll(Select<?> query)
this < all (Select ...)

lessThanAll

Condition lessThanAll(T... array)
this < all (array)

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

lessThanAll

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

Condition lessOrEqualAny(Select<?> query)
this <= any (Select ...)

lessOrEqualAny

Condition lessOrEqualAny(T... array)
this <= any (array)

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

lessOrEqualAny

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
Condition lessOrEqualSome(Select<?> query)
Deprecated. - 2.0.2 - Use lessOrEqualAny(Select) instead

this <= some (Select ...)

lessOrEqualAll

Condition lessOrEqualAll(Select<?> query)
this <= all (Select ...)

lessOrEqualAll

Condition lessOrEqualAll(T... array)
this <= all (array)

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

lessOrEqualAll

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

Condition greaterThanAny(Select<?> query)
this > any (Select ...)

greaterThanAny

Condition greaterThanAny(T... array)
this > any (array)

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

greaterThanAny

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
Condition greaterThanSome(Select<?> query)
Deprecated. - 2.0.2 - Use greaterThanAny(Select) instead

this > some (Select ...)

greaterThanAll

Condition greaterThanAll(Select<?> query)
this > all (Select ...)

greaterThanAll

Condition greaterThanAll(T... array)
this > all (array)

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

greaterThanAll

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

Condition greaterOrEqualAny(Select<?> query)
this >= any (Select ...)

greaterOrEqualAny

Condition greaterOrEqualAny(T... array)
this >= any (array)

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

greaterOrEqualAny

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
Condition greaterOrEqualSome(Select<?> query)
Deprecated. - 2.0.2 - Use greaterOrEqualAny(Select) instead

this >= some (Select ...)

greaterOrEqualAll

Condition greaterOrEqualAll(Select<?> query)
this >= all (Select ...)

greaterOrEqualAll

Condition greaterOrEqualAll(T... array)
this >= all (array)

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

greaterOrEqualAll

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

<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

<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

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

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

<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

<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

<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

<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

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

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    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD
Copyright © 2012. All Rights Reserved.