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.impl
Class CustomField<T>

java.lang.Object
  extended by org.jooq.impl.CustomField<T>
All Implemented Interfaces:
Serializable, Comparable<NamedQueryPart>, Adapter, AliasProvider<Field<T>>, Attachable, Field<T>, NamedQueryPart, NamedTypeProviderQueryPart<T>, QueryPart, QueryPartInternal
public abstract class CustomField<T>
extends Object

A base class for custom Field implementations in client code.

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

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

Author:
Lukas Eder
See Also:
Serialized Form

Constructor Summary
protected CustomField(String name, DataType<T> type)
           
 
Method Summary
 Field<T> abs()
          Deprecated. 
 Field<BigDecimal> acos()
          Deprecated. 
 Field<T> add(Field<?> value)
          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()
          Deprecated. 
 Field<BigDecimal> asin()
          Deprecated. 
 Field<BigDecimal> atan()
          Deprecated. 
 Field<BigDecimal> atan2(Field<? extends Number> y)
          Deprecated. 
 Field<BigDecimal> atan2(Number y)
          Deprecated. 
 void attach(Configuration configuration)
          Deprecated. 
 Field<BigDecimal> avg()
          Deprecated. 
 WindowPartitionByStep<BigDecimal> avgOver()
          Deprecated. 
 Condition between(Field<T> minValue, Field<T> maxValue)
          Create a condition to check this field against some bounds SQL: this between minValue and maxValue
 Condition between(T minValue, T maxValue)
          Create a condition to check this field against some bounds SQL: this between minValue and maxValue
 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
abstract  void bind(BindContext context)
          Subclasses must implement this method
Bind all parameters of this QueryPart to a PreparedStatement This method is for JOOQ INTERNAL USE only.
 Field<Integer> bitLength()
          Deprecated. 
<Z> Field<Z>
cast(Class<? extends Z> type)
          Cast this field to another type The actual cast may not be accurate as the DataType has to be "guessed" from the jOOQ-configured data types.
<Z> Field<Z>
cast(DataType<Z> type)
          Cast this field to a dialect-specific data type.
<Z> Field<Z>
cast(Field<Z> field)
          Cast this field to the type of another field.
 Field<T> ceil()
          Deprecated. 
 Field<Integer> charLength()
          Deprecated. 
 Field<T> coalesce(Field<T> option, Field<?>... options)
          Deprecated. 
 Field<T> coalesce(T option, T... options)
          Deprecated. 
 int compareTo(NamedQueryPart that)
           
 Field<String> concat(Field<?>... fields)
          Deprecated. 
 Field<String> concat(String... values)
          Deprecated. 
 Condition contains(Field<T> value)
          Convenience method for Field.like(String, char) including proper adding of wildcards and escaping SQL: this like ('%' || escape(value, '\') || '%') escape '\' Note: This also works with numbers, for instance val(1133).contains(13) If you're using SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator.
 Condition contains(T value)
          Convenience method for Field.like(String, char) including proper adding of wildcards and escaping SQL: this like ('%' || escape(value, '\') || '%') escape '\' Note: This also works with numbers, for instance val(1133).contains(13) If you're using SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator.
 Field<BigDecimal> cos()
          Deprecated. 
 Field<BigDecimal> cosh()
          Deprecated. 
 Field<BigDecimal> cot()
          Deprecated. 
 Field<BigDecimal> coth()
          Deprecated. 
 Field<Integer> count()
          Deprecated. 
 Field<Integer> countDistinct()
          Deprecated. 
 WindowPartitionByStep<Integer> countOver()
          Deprecated. 
protected  Factory create()
          Internal convenience method
protected  Factory create(Configuration configuration)
          Internal convenience method
 boolean declaresFields()
          Subclasses may override this
 boolean declaresTables()
          Subclasses may override this
<Z> Field<Z>
decode(Field<T> search, Field<Z> result)
          Deprecated. 
<Z> Field<Z>
decode(Field<T> search, Field<Z> result, Field<?>... more)
          Deprecated. 
<Z> Field<Z>
decode(T search, Z result)
          Deprecated. 
<Z> Field<Z>
decode(T search, Z result, Object... more)
          Deprecated. 
 Field<BigDecimal> deg()
          Deprecated. 
 SortField<T> desc()
          Create a descending sort field from this field
 Field<T> div(Field<? extends Number> value)
          An arithmetic expression dividing this by value If this is a numeric field, then the result is a number of the same type as this field.
 Field<T> div(Number value)
          An arithmetic expression dividing this by value If this is a numeric field, then the result is a number of the same type as this field.
 Condition endsWith(Field<T> value)
          Convenience method for Field.like(String, char) including proper adding of wildcards and escaping SQL: this like ('%' || escape(value, '\')) escape '\' Note: This also works with numbers, for instance val(1133).endsWith(33)
 Condition endsWith(T value)
          Convenience method for Field.like(String, char) including proper adding of wildcards and escaping SQL: this like ('%' || escape(value, '\')) escape '\' Note: This also works with numbers, for instance val(1133).endsWith(33)
 Condition 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 Field.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 Field.isNull() for convenience.
 Condition equalAll(Field<T[]> array)
          this = all (array) This is natively supported by SQLDialect.POSTGRES.
 Condition equalAll(Select<?> query)
          this = all (Select
 Condition equalAll(T... array)
          this = all (array) This is natively supported by SQLDialect.POSTGRES.
 Condition equalAny(Field<T[]> array)
          this = any (array) This is natively supported by SQLDialect.POSTGRES.
 Condition equalAny(Select<?> query)
          this = any (Select
 Condition equalAny(T... array)
          this = any (array) This is natively supported by SQLDialect.POSTGRES.
 Condition equalIgnoreCase(Field<String> value)
          lower(this) = lower(value)
 Condition equalIgnoreCase(String value)
          lower(this) = lower(value)
 boolean equals(Object that)
           
 Condition equalSome(Select<?> query)
          Deprecated. 
 Field<BigDecimal> exp()
          Deprecated. 
 Field<Integer> extract(DatePart datePart)
          Deprecated. 
 WindowIgnoreNullsStep<T> firstValue()
          Deprecated. 
 Field<T> floor()
          Deprecated. 
 Condition ge(Field<T> field)
          this >= field
 Condition ge(Select<?> query)
          this >= (Select
 Condition ge(T value)
          this >= value
 List<Object> getBindValues()
          This method is also declared as Query.getBindValues() Retrieve the bind values that will be bound by this QueryPart This method is exposed publicly in Query.getBindValues()
 DataType<T> getDataType()
          The type of this object (might not be dialect-specific)
 DataType<T> getDataType(Configuration configuration)
          The dialect-specific type of this object
 SQLDialect getDialect()
          Deprecated. 
 String getName()
          The name of this query part
 Param<?> getParam(String name)
          This method is also declared as Query.getParam(String) Retrieve a named parameter that will be bound by this QueryPart This method is exposed publicly in Query.getParam(String)
 Map<String,Param<?>> getParams()
          This method is also declared as Query.getParams() Retrieve the named parameters that will be bound by this QueryPart This method is exposed publicly in Query.getParams()
 String getSQL()
          This method is also declared as Query.getSQL() Retrieve the SQL that will be rendered by this QueryPart This method is exposed publicly in Query.getSQL()
 String getSQL(boolean inline)
          This method is also declared as Query.getSQL(boolean) Retrieve the SQL that will be rendered by this QueryPart This method is exposed publicly in Query.getSQL(boolean)
protected  SQLDataType<T> getSQLDataType()
           
 Class<? extends T> getType()
          The type of this object
 Condition greaterOrEqual(Field<T> field)
          this >= field
 Condition greaterOrEqual(Select<?> query)
          this >= (Select
 Condition greaterOrEqual(T value)
          this >= value
 Condition greaterOrEqualAll(Field<T[]> array)
          this >= all (array) This is natively supported by SQLDialect.POSTGRES.
 Condition greaterOrEqualAll(Select<?> query)
          this >= all (Select
 Condition greaterOrEqualAll(T... array)
          this >= all (array) This is natively supported by SQLDialect.POSTGRES.
 Condition greaterOrEqualAny(Field<T[]> array)
          this >= any (array) This is natively supported by SQLDialect.POSTGRES.
 Condition greaterOrEqualAny(Select<?> query)
          this >= any (Select
 Condition greaterOrEqualAny(T... array)
          this >= any (array) This is natively supported by SQLDialect.POSTGRES.
 Condition greaterOrEqualSome(Select<?> query)
          Deprecated. 
 Condition greaterThan(Field<T> field)
          this > field
 Condition greaterThan(Select<?> query)
          this > (Select
 Condition greaterThan(T value)
          this > value
 Condition greaterThanAll(Field<T[]> array)
          this > all (array) This is natively supported by SQLDialect.POSTGRES.
 Condition greaterThanAll(Select<?> query)
          this > all (Select
 Condition greaterThanAll(T... array)
          this > all (array) This is natively supported by SQLDialect.POSTGRES.
 Condition greaterThanAny(Field<T[]> array)
          this > any (array) This is natively supported by SQLDialect.POSTGRES.
 Condition greaterThanAny(Select<?> query)
          this > any (Select
 Condition greaterThanAny(T... array)
          this > any (array) This is natively supported by SQLDialect.POSTGRES.
 Condition greaterThanSome(Select<?> query)
          Deprecated. 
 Field<T> greatest(Field<?>... others)
          Deprecated. 
 Field<T> greatest(T... others)
          Deprecated. 
 Condition gt(Field<T> field)
          this > field
 Condition gt(Select<?> query)
          this > (Select
 Condition gt(T value)
          this > value
 int hashCode()
           
 Condition in(Collection<T> values)
          Create a condition to check this field against several values SQL: this in (values...)
 Condition in(Field<?>... values)
          Create a condition to check this field against several values SQL: this in (values...)
 Condition in(Select<?> query)
          Create a condition to check this field against a subquery Note that the subquery must return exactly one field.
 Condition in(T... values)
          Create a condition to check this field against several values SQL: this in (values...)
<I> I
internalAPI(Class<I> internalType)
          Adapt to an internal type assuming its functionality This is for JOOQ INTERNAL USE only.
 Condition 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()
          Subclasses may further override this method
Whether this field represents a null literal.
 Condition isTrue()
          Create a condition to check this field against known string literals for true SQL: lcase(this) in ("1", "y", "yes", "true", "on", "enabled")
 WindowIgnoreNullsStep<T> lag()
          Deprecated. 
 WindowIgnoreNullsStep<T> lag(int offset)
          Deprecated. 
 WindowIgnoreNullsStep<T> lag(int offset, Field<T> defaultValue)
          Deprecated. 
 WindowIgnoreNullsStep<T> lag(int offset, T defaultValue)
          Deprecated. 
 WindowIgnoreNullsStep<T> lastValue()
          Deprecated. 
 Condition le(Field<T> field)
          this <= field
 Condition le(Select<?> query)
          this <= (Select
 Condition le(T value)
          this <= value
 WindowIgnoreNullsStep<T> lead()
          Deprecated. 
 WindowIgnoreNullsStep<T> lead(int offset)
          Deprecated. 
 WindowIgnoreNullsStep<T> lead(int offset, Field<T> defaultValue)
          Deprecated. 
 WindowIgnoreNullsStep<T> lead(int offset, T defaultValue)
          Deprecated. 
 Field<T> least(Field<?>... others)
          Deprecated. 
 Field<T> least(T... others)
          Deprecated. 
 Field<Integer> length()
          Deprecated. 
 Condition lessOrEqual(Field<T> field)
          this <= field
 Condition lessOrEqual(Select<?> query)
          this <= (Select
 Condition lessOrEqual(T value)
          this <= value
 Condition lessOrEqualAll(Field<T[]> array)
          this <= all (array) This is natively supported by SQLDialect.POSTGRES.
 Condition lessOrEqualAll(Select<?> query)
          this <= all (Select
 Condition lessOrEqualAll(T... array)
          this <= all (array) This is natively supported by SQLDialect.POSTGRES.
 Condition lessOrEqualAny(Field<T[]> array)
          this <= any (array) This is natively supported by SQLDialect.POSTGRES.
 Condition lessOrEqualAny(Select<?> query)
          this <= any (Select
 Condition lessOrEqualAny(T... array)
          this <= any (array) This is natively supported by SQLDialect.POSTGRES.
 Condition lessOrEqualSome(Select<?> query)
          Deprecated. 
 Condition lessThan(Field<T> field)
          this < field
 Condition lessThan(Select<?> query)
          this < (Select
 Condition lessThan(T value)
          this < value
 Condition lessThanAll(Field<T[]> array)
          this < all (array) This is natively supported by SQLDialect.POSTGRES.
 Condition lessThanAll(Select<?> query)
          this < all (Select
 Condition lessThanAll(T... array)
          this < all (array) This is natively supported by SQLDialect.POSTGRES.
 Condition lessThanAny(Field<T[]> array)
          this < any (array) This is natively supported by SQLDialect.POSTGRES.
 Condition lessThanAny(Select<?> query)
          this < any (Select
 Condition lessThanAny(T... array)
          this < any (array) This is natively supported by SQLDialect.POSTGRES.
 Condition lessThanSome(Select<?> query)
          Deprecated. 
 Condition like(Field<String> value)
          Create a condition to pattern-check this field against a value SQL: this like value
 Condition like(Field<String> value, char escape)
          Create a condition to pattern-check this field against a value SQL: this like value escape 'e'
 Condition like(String value)
          Create a condition to pattern-check this field against a value SQL: this like value
 Condition like(String value, char escape)
          Create a condition to pattern-check this field against a value SQL: this like value escape 'e'
 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 Field.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()
          Deprecated. 
 Field<BigDecimal> log(int base)
          Deprecated. 
 Field<String> lower()
          Deprecated. 
 Field<String> lpad(Field<? extends Number> length)
          Deprecated. 
 Field<String> lpad(Field<? extends Number> length, Field<String> character)
          Deprecated. 
 Field<String> lpad(int length)
          Deprecated. 
 Field<String> lpad(int length, char character)
          Deprecated. 
 Condition lt(Field<T> field)
          this < field
 Condition lt(Select<?> query)
          this < (Select
 Condition lt(T value)
          this < value
 Field<String> ltrim()
          Deprecated. 
 Field<T> max()
          Deprecated. 
 WindowPartitionByStep<T> maxOver()
          Deprecated. 
 Field<BigDecimal> median()
          Deprecated. 
 Field<T> min()
          Deprecated. 
 WindowPartitionByStep<T> minOver()
          Deprecated. 
 Field<T> mod(Field<? extends Number> value)
          An arithmetic expression getting the modulo of this divided by value This renders the modulo operation where available: [this] % [value] ... or the modulo function elsewhere: mod([this], [value])
 Field<T> mod(Number value)
          An arithmetic expression getting the modulo of this divided by value This renders the modulo operation where available: [this] % [value] ... or the modulo function elsewhere: mod([this], [value])
 Field<T> mul(Field<? extends Number> value)
          This default implementation is known to be overridden by Expression to generate neater expressions
 Field<T> mul(Number value)
          An arithmetic expression multiplying this with value If this is a numeric field, then the result is a number of the same type as this field.
 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. 
 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 Field.likeRegex(String) for more details
 Condition notLikeRegex(String pattern)
          Create a condition to regex-pattern-check this field against a pattern See Field.likeRegex(String) for more details
 Field<T> nullif(Field<T> other)
          Deprecated. 
 Field<T> nullif(T other)
          Deprecated. 
 Field<T> nvl(Field<T> defaultValue)
          Deprecated. 
 Field<T> nvl(T defaultValue)
          Deprecated. 
<Z> Field<Z>
nvl2(Field<Z> valueIfNotNull, Field<Z> valueIfNull)
          Deprecated. 
<Z> Field<Z>
nvl2(Z valueIfNotNull, Z valueIfNull)
          Deprecated. 
 Field<Integer> octetLength()
          Deprecated. 
 Field<Integer> position(Field<String> search)
          Deprecated. 
 Field<Integer> position(String search)
          Deprecated. 
 Field<BigDecimal> power(Number exponent)
          Deprecated. 
 Field<BigDecimal> rad()
          Deprecated. 
 Field<String> repeat(Field<? extends Number> count)
          Deprecated. 
 Field<String> repeat(Number count)
          Deprecated. 
 Field<String> replace(Field<String> search)
          Deprecated. 
 Field<String> replace(Field<String> search, Field<String> replace)
          Deprecated. 
 Field<String> replace(String search)
          Deprecated. 
 Field<String> replace(String search, String replace)
          Deprecated. 
 Field<T> round()
          Deprecated. 
 Field<T> round(int decimals)
          Deprecated. 
 Field<String> rpad(Field<? extends Number> length)
          Deprecated. 
 Field<String> rpad(Field<? extends Number> length, Field<String> character)
          Deprecated. 
 Field<String> rpad(int length)
          Deprecated. 
 Field<String> rpad(int length, char character)
          Deprecated. 
 Field<String> rtrim()
          Deprecated. 
 Field<Integer> sign()
          Deprecated. 
 Field<BigDecimal> sin()
          Deprecated. 
 Field<BigDecimal> sinh()
          Deprecated. 
<Z> SortField<Z>
sort(Map<T,Z> sortMap)
          Create a sort field of the form (in pseudo code) CASE [this] WHEN [sortMap.key(0)] THEN sortMap.value(0) WHEN [sortMap.key(1)] THEN sortMap.value(1) ...
 SortField<Integer> sortAsc(Collection<T> sortList)
          Create a sort field of the form CASE [this] WHEN [sortList.get(0)] THEN 0 WHEN [sortList.get(1)] THEN 1 ...
 SortField<Integer> sortAsc(T... sortList)
          Create a sort field of the form CASE [this] WHEN [sortList[0]] THEN 0 WHEN [sortList[1]] THEN 1 ...
 SortField<Integer> sortDesc(Collection<T> sortList)
          Create a sort field of the form CASE [this] WHEN [sortList.get(0)] THEN 0 WHEN [sortList.get(1)] THEN 1 ...
 SortField<Integer> sortDesc(T... sortList)
          Create a sort field of the form CASE [this] WHEN [sortList[0]] THEN 0 WHEN [sortList[1]] THEN 1 ...
 Field<BigDecimal> sqrt()
          Deprecated. 
 Condition startsWith(Field<T> value)
          Convenience method for Field.like(String, char) including proper adding of wildcards and escaping SQL: this like (escape(value, '\') || '%') escape '\' Note: This also works with numbers, for instance val(1133).startsWith(11)
 Condition startsWith(T value)
          Convenience method for Field.like(String, char) including proper adding of wildcards and escaping SQL: this like (escape(value, '\') || '%') escape '\' Note: This also works with numbers, for instance val(1133).startsWith(11)
 Field<BigDecimal> stddevPop()
          Deprecated. 
 WindowPartitionByStep<BigDecimal> stddevPopOver()
          Deprecated. 
 Field<BigDecimal> stddevSamp()
          Deprecated. 
 WindowPartitionByStep<BigDecimal> stddevSampOver()
          Deprecated. 
 Field<T> sub(Field<?> value)
          An arithmetic expression subtracting value from this.
 Field<T> sub(Number value)
          An arithmetic expression subtracting value from this.
 Field<String> substring(Field<? extends Number> startingPosition)
          Deprecated. 
 Field<String> substring(Field<? extends Number> startingPosition, Field<? extends Number> length)
          Deprecated. 
 Field<String> substring(int startingPosition)
          Deprecated. 
 Field<String> substring(int startingPosition, int length)
          Deprecated. 
 Field<BigDecimal> sum()
          Deprecated. 
 WindowPartitionByStep<BigDecimal> sumOver()
          Deprecated. 
 Field<BigDecimal> tan()
          Deprecated. 
 Field<BigDecimal> tanh()
          Deprecated. 
abstract  void toSQL(RenderContext context)
          Subclasses must implement this method
Render this QueryPart to a SQL string contained in context.sql().
 String toString()
           
protected  DataAccessException translate(String sql, SQLException e)
          Internal convenience method
protected  DataAccessException translate(String task, String sql, SQLException e)
          Deprecated. - 2.3.0 - Do not reuse
 Field<String> trim()
          Deprecated. 
 Field<String> upper()
          Deprecated. 
 Field<BigDecimal> varPop()
          Deprecated. 
 WindowPartitionByStep<BigDecimal> varPopOver()
          Deprecated. 
 Field<BigDecimal> varSamp()
          Deprecated. 
 WindowPartitionByStep<BigDecimal> varSampOver()
          Deprecated. 
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, notify, notifyAll, wait, wait, wait
 
Methods inherited from interface org.jooq.Field
equals, getName, getType
 
Methods inherited from interface org.jooq.NamedTypeProviderQueryPart
getDataType, getDataType
 
Methods inherited from interface org.jooq.Adapter
internalAPI
 
Methods inherited from interface java.lang.Comparable
compareTo
 

Constructor Detail

CustomField

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

toSQL

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

Specified by:
toSQL in interface QueryPartInternal

bind

public abstract void bind(BindContext context)
                   throws DataAccessException
Subclasses must implement this method
Bind all parameters of this QueryPart to a PreparedStatement

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

Specified by:
bind in interface QueryPartInternal
Parameters:
context - The context holding the next bind index and other information for variable binding
Throws:
DataAccessException - If something went wrong while binding a variable

isNullLiteral

public boolean isNullLiteral()
Subclasses may further override this method
Whether this field represents a null literal.

This method is for JOOQ INTERNAL USE only!

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

Specified by:
isNullLiteral in interface Field<T>

attach

@Deprecated
public void attach(Configuration configuration)
Deprecated. 

Subclasses may further override this method
Attach this object to a new Configuration

Specified by:
attach in interface Attachable
Specified by:
attach in interface QueryPart
Parameters:
configuration - A configuration or null, if you wish to detach this Attachable from its previous configuration.

as

public final Field<T> as(String alias)
Description copied from interface: Field
Create an alias for this field

Specified by:
as in interface AliasProvider<Field<T>>
Specified by:
as in interface Field<T>
Parameters:
alias - The alias name
Returns:
The field alias

add

public final Field<T> add(Field<?> value)
Description copied from interface: Field
An arithmetic expression to add value to this.

The behaviour of this operation is as follows:

Operand 1 Operand 2 Result Type
Numeric Numeric Numeric
Date / Time Numeric Date / Time
Date / Time Interval Date / Time
Interval Interval Interval

Specified by:
add in interface Field<T>

mul

public final Field<T> mul(Field<? extends Number> value)
This default implementation is known to be overridden by Expression to generate neater expressions

Specified by:
mul in interface Field<T>

declaresFields

public final boolean declaresFields()
Subclasses may override this

Specified by:
declaresFields in interface QueryPartInternal

declaresTables

public final boolean declaresTables()
Subclasses may override this

Specified by:
declaresTables in interface QueryPartInternal

cast

public final <Z> Field<Z> cast(Field<Z> field)
Description copied from interface: Field
Cast this field to the type of another field.

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

Specified by:
cast in interface Field<T>
Type Parameters:
Z - The generic type of the cast field
Parameters:
field - The field whose type is used for the cast
Returns:
The cast field
See Also:
Field.cast(DataType)

cast

public final <Z> Field<Z> cast(DataType<Z> type)
Description copied from interface: Field
Cast this field to a dialect-specific data type.

Specified by:
cast in interface Field<T>
Type Parameters:
Z - The generic type of the cast field

cast

public final <Z> Field<Z> cast(Class<? extends Z> type)
Description copied from interface: Field
Cast this field to another type

The actual cast may not be accurate as the DataType has to be "guessed" from the jOOQ-configured data types. Use Field.cast(DataType) for more accurate casts.

Specified by:
cast in interface Field<T>
Type Parameters:
Z - The generic type of the cast field
Parameters:
type - The type that is used for the cast
Returns:
The cast field
See Also:
Field.cast(DataType)

asc

public final SortField<T> asc()
Description copied from interface: Field
Create an ascending sort field from this field

Specified by:
asc in interface Field<T>
Returns:
This field as an ascending sort field

desc

public final SortField<T> desc()
Description copied from interface: Field
Create a descending sort field from this field

Specified by:
desc in interface Field<T>
Returns:
This field as a descending sort field

sortAsc

public final SortField<Integer> sortAsc(Collection<T> sortList)
Description copied from interface: Field
Create a sort field of the form 
 CASE [this] WHEN [sortList.get(0)] THEN 0
             WHEN [sortList.get(1)] THEN 1
             ...
             WHEN [sortList.get(n)] THEN n
                                    ELSE null
 END ASC

Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority.

Specified by:
sortAsc in interface Field<T>
Parameters:
sortList - The list containing sort value preferences
Returns:
The sort field

sortAsc

public final SortField<Integer> sortAsc(T... sortList)
Description copied from interface: Field
Create a sort field of the form 
 CASE [this] WHEN [sortList[0]] THEN 0
             WHEN [sortList[1]] THEN 1
             ...
             WHEN [sortList[n]] THEN n
                                ELSE null
 END ASC

Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority.

Specified by:
sortAsc in interface Field<T>
Parameters:
sortList - The list containing sort value preferences
Returns:
The sort field

sortDesc

public final SortField<Integer> sortDesc(Collection<T> sortList)
Description copied from interface: Field
Create a sort field of the form 
 CASE [this] WHEN [sortList.get(0)] THEN 0
             WHEN [sortList.get(1)] THEN 1
             ...
             WHEN [sortList.get(n)] THEN n
                                    ELSE null
 END DESC

Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority.

Specified by:
sortDesc in interface Field<T>
Parameters:
sortList - The list containing sort value preferences
Returns:
The sort field

sortDesc

public final SortField<Integer> sortDesc(T... sortList)
Description copied from interface: Field
Create a sort field of the form 
 CASE [this] WHEN [sortList[0]] THEN 0
             WHEN [sortList[1]] THEN 1
             ...
             WHEN [sortList[n]] THEN n
                                    ELSE null
 END DESC

Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority.

Specified by:
sortDesc in interface Field<T>
Parameters:
sortList - The list containing sort value preferences
Returns:
The sort field

sort

public final <Z> SortField<Z> sort(Map<T,Z> sortMap)
Description copied from interface: Field
Create a sort field of the form (in pseudo code)
 CASE [this] WHEN [sortMap.key(0)] THEN sortMap.value(0)
             WHEN [sortMap.key(1)] THEN sortMap.value(1)
             ...
             WHEN [sortMap.key(n)] THEN sortMap.value(n)
                                   ELSE null
 END DESC

Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority.

Specified by:
sort in interface Field<T>
Parameters:
sortMap - The list containing sort value preferences
Returns:
The sort field

neg

public final Field<T> neg()
Description copied from interface: Field
Negate this field to get its negative value.

This renders the same on all dialects: 

-[this]

Specified by:
neg in interface Field<T>

add

public final Field<T> add(Number value)
Description copied from interface: Field
An arithmetic expression adding this to value.

Specified by:
add in interface Field<T>
See Also:
Field.add(Field)

sub

public final Field<T> sub(Number value)
Description copied from interface: Field
An arithmetic expression subtracting value from this.

Specified by:
sub in interface Field<T>
See Also:
Field.sub(Field)

sub

public final Field<T> sub(Field<?> value)
Description copied from interface: Field
An arithmetic expression subtracting value from this.

Operand 1 Operand 2 Result Type
Numeric Numeric Numeric
Date / Time Numeric Date / Time
Date / Time Interval Date / Time
Interval Interval Interval

In order to subtract one date time field from another, use any of these methods:

Specified by:
sub in interface Field<T>

mul

public final Field<T> mul(Number value)
Description copied from interface: Field
An arithmetic expression multiplying this with value

  • If this is a numeric field, then the result is a number of the same type as this field.
  • If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval)

Specified by:
mul in interface Field<T>

div

public final Field<T> div(Number value)
Description copied from interface: Field
An arithmetic expression dividing this by value

  • If this is a numeric field, then the result is a number of the same type as this field.
  • If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval)

Specified by:
div in interface Field<T>

div

public final Field<T> div(Field<? extends Number> value)
Description copied from interface: Field
An arithmetic expression dividing this by value

  • If this is a numeric field, then the result is a number of the same type as this field.
  • If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval)

Specified by:
div in interface Field<T>

mod

public final Field<T> mod(Number value)
Description copied from interface: Field
An arithmetic expression getting the modulo of this divided by value

This renders the modulo operation where available: 

[this] % [value]
... or the modulo function elsewhere: 
mod([this], [value])

Specified by:
mod in interface Field<T>

mod

public final Field<T> mod(Field<? extends Number> value)
Description copied from interface: Field
An arithmetic expression getting the modulo of this divided by value

This renders the modulo operation where available: 

[this] % [value]
... or the modulo function elsewhere: 
mod([this], [value])

Specified by:
mod in interface Field<T>

isNull

public final Condition isNull()
Description copied from interface: Field
Create a condition to check this field against null.

SQL: this is null

Specified by:
isNull in interface Field<T>

isNotNull

public final Condition isNotNull()
Description copied from interface: Field
Create a condition to check this field against null.

SQL: this is not null

Specified by:
isNotNull in interface Field<T>

isDistinctFrom

public final Condition isDistinctFrom(T value)
Description copied from interface: Field
Create a condition to check if this field is DISTINCT from another value

If this is not supported by the underlying database, jOOQ will render this instead: 

 CASE WHEN [this] IS     NULL AND [value] IS     NULL THEN FALSE
      WHEN [this] IS     NULL AND [value] IS NOT NULL THEN TRUE
      WHEN [this] IS NOT NULL AND [value] IS     NULL THEN TRUE
      WHEN [this] =               [value]             THEN FALSE
      ELSE                                                 TRUE
 END
SQL: this is distinct from value

Specified by:
isDistinctFrom in interface Field<T>

isDistinctFrom

public final Condition isDistinctFrom(Field<T> field)
Description copied from interface: Field
Create a condition to check if this field is DISTINCT from another field

If this is not supported by the underlying database, jOOQ will render this instead: 

 CASE WHEN [this] IS     NULL AND [field] IS     NULL THEN FALSE
      WHEN [this] IS     NULL AND [field] IS NOT NULL THEN TRUE
      WHEN [this] IS NOT NULL AND [field] IS     NULL THEN TRUE
      WHEN [this] =               [field]             THEN FALSE
      ELSE                                                 TRUE
 END
SQL: this is distinct from field

Specified by:
isDistinctFrom in interface Field<T>

isNotDistinctFrom

public final Condition isNotDistinctFrom(T value)
Description copied from interface: Field
Create a condition to check if this field is NOT DISTINCT from another value

If this is not supported by the underlying database, jOOQ will render this instead: 

 CASE WHEN [this] IS     NULL AND [value] IS     NULL THEN TRUE
      WHEN [this] IS     NULL AND [value] IS NOT NULL THEN FALSE
      WHEN [this] IS NOT NULL AND [value] IS     NULL THEN FALSE
      WHEN [this] =               [value]             THEN TRUE
      ELSE                                                 FALSE
 END
SQL: this is not distinct from value

Specified by:
isNotDistinctFrom in interface Field<T>

isNotDistinctFrom

public final Condition isNotDistinctFrom(Field<T> field)
Description copied from interface: Field
Create a condition to check if this field is NOT DISTINCT from another field

If this is not supported by the underlying database, jOOQ will render this instead: 

 CASE WHEN [this] IS     NULL AND [field] IS     NULL THEN TRUE
      WHEN [this] IS     NULL AND [field] IS NOT NULL THEN FALSE
      WHEN [this] IS NOT NULL AND [field] IS     NULL THEN FALSE
      WHEN [this] =               [value]             THEN TRUE
      ELSE                                                 FALSE
 END
SQL: this is not distinct from field

Specified by:
isNotDistinctFrom in interface Field<T>

isTrue

public final Condition isTrue()
Description copied from interface: Field
Create a condition to check this field against known string literals for true

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

Specified by:
isTrue in interface Field<T>

isFalse

public final Condition isFalse()
Description copied from interface: Field
Create a condition to check this field against known string literals for false

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

Specified by:
isFalse in interface Field<T>

like

public final Condition like(String value)
Description copied from interface: Field
Create a condition to pattern-check this field against a value

SQL: this like value

Specified by:
like in interface Field<T>

like

public final Condition like(String value,
                            char escape)
Description copied from interface: Field
Create a condition to pattern-check this field against a value

SQL: this like value escape 'e'

Specified by:
like in interface Field<T>

like

public final Condition like(Field<String> value)
Description copied from interface: Field
Create a condition to pattern-check this field against a value

SQL: this like value

Specified by:
like in interface Field<T>

like

public final Condition like(Field<String> value,
                            char escape)
Description copied from interface: Field
Create a condition to pattern-check this field against a value

SQL: this like value escape 'e'

Specified by:
like in interface Field<T>

likeIgnoreCase

public final Condition likeIgnoreCase(String value)
Description copied from interface: Field
Create a condition to case-insensitively pattern-check this field against a value

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

Specified by:
likeIgnoreCase in interface Field<T>

likeIgnoreCase

public final Condition likeIgnoreCase(String value,
                                      char escape)
Description copied from interface: Field
Create a condition to case-insensitively pattern-check this field against a value

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

Specified by:
likeIgnoreCase in interface Field<T>

likeIgnoreCase

public final Condition likeIgnoreCase(Field<String> value)
Description copied from interface: Field
Create a condition to case-insensitively pattern-check this field against a value

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

Specified by:
likeIgnoreCase in interface Field<T>

likeIgnoreCase

public final Condition likeIgnoreCase(Field<String> value,
                                      char escape)
Description copied from interface: Field
Create a condition to case-insensitively pattern-check this field against a value

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

Specified by:
likeIgnoreCase in interface Field<T>

likeRegex

public final Condition likeRegex(String pattern)
Description copied from interface: Field
Create a condition to regex-pattern-check this field against a pattern

The SQL:2008 standard specifies a <regex like predicate> of the following form: 

 <regex like predicate> ::=
   <row value predicand> <regex like predicate part 2>

 <regex like predicate part 2> ::=
  [ NOT ] LIKE_REGEX <XQuery pattern> [ FLAG <XQuery option flag> ]

This particular LIKE_REGEX operator comes in several flavours for various databases. jOOQ supports regular expressions as follows:

SQL dialect SQL syntax Pattern syntax Documentation
SQLDialect.ASE - - -
SQLDialect.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

Specified by:
likeRegex in interface Field<T>
See Also:
Field.likeRegex(String)

likeRegex

public final Condition likeRegex(Field<String> pattern)
Description copied from interface: Field
Create a condition to regex-pattern-check this field against a pattern

See Field.likeRegex(String) for more details

Specified by:
likeRegex in interface Field<T>
See Also:
Field.likeRegex(String)

notLike

public final Condition notLike(String value)
Description copied from interface: Field
Create a condition to pattern-check this field against a value

SQL: this not like value

Specified by:
notLike in interface Field<T>

notLike

public final Condition notLike(String value,
                               char escape)
Description copied from interface: Field
Create a condition to pattern-check this field against a value

SQL: this not like value escape 'e'

Specified by:
notLike in interface Field<T>

notLike

public final Condition notLike(Field<String> value)
Description copied from interface: Field
Create a condition to pattern-check this field against a value

SQL: this not like value

Specified by:
notLike in interface Field<T>

notLike

public final Condition notLike(Field<String> value,
                               char escape)
Description copied from interface: Field
Create a condition to pattern-check this field against a value

SQL: this not like value escape 'e'

Specified by:
notLike in interface Field<T>

notLikeIgnoreCase

public final Condition notLikeIgnoreCase(String value)
Description copied from interface: Field
Create a condition to case-insensitively pattern-check this field against a value

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

Specified by:
notLikeIgnoreCase in interface Field<T>

notLikeIgnoreCase

public final Condition notLikeIgnoreCase(String value,
                                         char escape)
Description copied from interface: Field
Create a condition to case-insensitively pattern-check this field against a value

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

Specified by:
notLikeIgnoreCase in interface Field<T>

notLikeIgnoreCase

public final Condition notLikeIgnoreCase(Field<String> value)
Description copied from interface: Field
Create a condition to case-insensitively pattern-check this field against a value

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

Specified by:
notLikeIgnoreCase in interface Field<T>

notLikeIgnoreCase

public final Condition notLikeIgnoreCase(Field<String> value,
                                         char escape)
Description copied from interface: Field
Create a condition to case-insensitively pattern-check this field against a value

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

Specified by:
notLikeIgnoreCase in interface Field<T>

notLikeRegex

public final Condition notLikeRegex(String pattern)
Description copied from interface: Field
Create a condition to regex-pattern-check this field against a pattern

See Field.likeRegex(String) for more details

Specified by:
notLikeRegex in interface Field<T>
See Also:
Field.likeRegex(String)

notLikeRegex

public final Condition notLikeRegex(Field<String> pattern)
Description copied from interface: Field
Create a condition to regex-pattern-check this field against a pattern

See Field.likeRegex(String) for more details

Specified by:
notLikeRegex in interface Field<T>
See Also:
Field.likeRegex(Field)

contains

public final Condition contains(T value)
Description copied from interface: Field
Convenience method for Field.like(String, char) including proper adding of wildcards and escaping

SQL: this like ('%' || escape(value, '\') || '%') escape '\'

Note: This also works with numbers, for instance val(1133).contains(13)

If you're using SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator. For example: 

 // Use this expression
 val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 })

 // ... to render this SQL
 ARRAY[1, 2, 3] @> ARRAY[1, 2]

Note, this does not correspond to the Oracle Text CONTAINS() function. Refer to OracleFactory.contains(Field, String) instead.

Specified by:
contains in interface Field<T>
See Also:
Factory.escape(String, char), Field.like(String, char)

contains

public final Condition contains(Field<T> value)
Description copied from interface: Field
Convenience method for Field.like(String, char) including proper adding of wildcards and escaping

SQL: this like ('%' || escape(value, '\') || '%') escape '\'

Note: This also works with numbers, for instance val(1133).contains(13)

If you're using SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator. For example: 

 // Use this expression
 val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 })

 // ... to render this SQL
 ARRAY[1, 2, 3] @> ARRAY[1, 2]

Note, this does not correspond to the Oracle Text CONTAINS() function. Refer to OracleFactory.contains(Field, String) instead.

Specified by:
contains in interface Field<T>
See Also:
Factory.escape(Field, char), Field.like(Field, char)

startsWith

public final Condition startsWith(T value)
Description copied from interface: Field
Convenience method for Field.like(String, char) including proper adding of wildcards and escaping

SQL: this like (escape(value, '\') || '%') escape '\'

Note: This also works with numbers, for instance val(1133).startsWith(11)

Specified by:
startsWith in interface Field<T>
See Also:
Factory.escape(String, char), Field.like(String, char)

startsWith

public final Condition startsWith(Field<T> value)
Description copied from interface: Field
Convenience method for Field.like(String, char) including proper adding of wildcards and escaping

SQL: this like (escape(value, '\') || '%') escape '\'

Note: This also works with numbers, for instance val(1133).startsWith(11)

Specified by:
startsWith in interface Field<T>
See Also:
Factory.escape(Field, char), Field.like(Field, char)

endsWith

public final Condition endsWith(T value)
Description copied from interface: Field
Convenience method for Field.like(String, char) including proper adding of wildcards and escaping

SQL: this like ('%' || escape(value, '\')) escape '\'

Note: This also works with numbers, for instance val(1133).endsWith(33)

Specified by:
endsWith in interface Field<T>
See Also:
Factory.escape(String, char), Field.like(String, char)

endsWith

public final Condition endsWith(Field<T> value)
Description copied from interface: Field
Convenience method for Field.like(String, char) including proper adding of wildcards and escaping

SQL: this like ('%' || escape(value, '\')) escape '\'

Note: This also works with numbers, for instance val(1133).endsWith(33)

Specified by:
endsWith in interface Field<T>
See Also:
Factory.escape(Field, char), Field.like(Field, char)

in

public final Condition in(T... values)
Description copied from interface: Field
Create a condition to check this field against several values

SQL: this in (values...)

Specified by:
in in interface Field<T>

in

public final Condition in(Field<?>... values)
Description copied from interface: Field
Create a condition to check this field against several values

SQL: this in (values...)

Specified by:
in in interface Field<T>

in

public final Condition in(Collection<T> values)
Description copied from interface: Field
Create a condition to check this field against several values

SQL: this in (values...)

Specified by:
in in interface Field<T>

in

public final Condition in(Select<?> query)
Description copied from interface: Field
Create a condition to check this field against a subquery

Note that the subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors on the database, if not used correctly.

SQL: this in (select...)

Specified by:
in in interface Field<T>

notIn

public final Condition notIn(T... values)
Description copied from interface: Field
Create a condition to check this field against several values

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

SQL: this not in (values...)

Specified by:
notIn in interface Field<T>

notIn

public final Condition notIn(Field<?>... values)
Description copied from interface: Field
Create a condition to check this field against several values

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

SQL: this not in (values...)

Specified by:
notIn in interface Field<T>

notIn

public final Condition notIn(Collection<T> values)
Description copied from interface: Field
Create a condition to check this field against several values

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

SQL: this not in (values...)

Specified by:
notIn in interface Field<T>

notIn

public final Condition notIn(Select<?> query)
Description copied from interface: Field
Create a condition to check this field against a subquery

Note that the subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors on the database, if not used correctly.

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

SQL: this not in (select...)

Specified by:
notIn in interface Field<T>

between

public final Condition between(T minValue,
                               T maxValue)
Description copied from interface: Field
Create a condition to check this field against some bounds

SQL: this between minValue and maxValue

Specified by:
between in interface Field<T>

between

public final Condition between(Field<T> minValue,
                               Field<T> maxValue)
Description copied from interface: Field
Create a condition to check this field against some bounds

SQL: this between minValue and maxValue

Specified by:
between in interface Field<T>

betweenSymmetric

public final Condition betweenSymmetric(T minValue,
                                        T maxValue)
Description copied from interface: Field
Create a condition to check this field against some bounds

SQL: this between symmetric minValue and maxValue

Specified by:
betweenSymmetric in interface Field<T>

betweenSymmetric

public final Condition betweenSymmetric(Field<T> minValue,
                                        Field<T> maxValue)
Description copied from interface: Field
Create a condition to check this field against some bounds

SQL: this between symmetric minValue and maxValue

Specified by:
betweenSymmetric in interface Field<T>

notBetween

public final Condition notBetween(T minValue,
                                  T maxValue)
Description copied from interface: Field
Create a condition to check this field against some bounds

SQL: this not between minValue and maxValue

Specified by:
notBetween in interface Field<T>

notBetween

public final Condition notBetween(Field<T> minValue,
                                  Field<T> maxValue)
Description copied from interface: Field
Create a condition to check this field against some bounds

SQL: this not between minValue and maxValue

Specified by:
notBetween in interface Field<T>

notBetweenSymmetric

public final Condition notBetweenSymmetric(T minValue,
                                           T maxValue)
Description copied from interface: Field
Create a condition to check this field against some bounds

SQL: this not between symmetric minValue and maxValue

Specified by:
notBetweenSymmetric in interface Field<T>

notBetweenSymmetric

public final Condition notBetweenSymmetric(Field<T> minValue,
                                           Field<T> maxValue)
Description copied from interface: Field
Create a condition to check this field against some bounds

SQL: this not between symmetric minValue and maxValue

Specified by:
notBetweenSymmetric in interface Field<T>

eq

public final Condition eq(T value)
Description copied from interface: Field
this = value

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

Specified by:
eq in interface Field<T>
See Also:
Field.equal(Object)

eq

public final Condition eq(Field<T> field)
Description copied from interface: Field
this = field

Specified by:
eq in interface Field<T>
See Also:
Field.equal(Field)

eq

public final Condition eq(Select<?> query)
Description copied from interface: Field
this = (Select ...)

Specified by:
eq in interface Field<T>
See Also:
Field.equal(Select)

ne

public final Condition ne(T value)
Description copied from interface: Field
this != value

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

Specified by:
ne in interface Field<T>
See Also:
Field.notEqual(Object)

ne

public final Condition ne(Field<T> field)
Description copied from interface: Field
this != field

Specified by:
ne in interface Field<T>
See Also:
Field.notEqual(Field)

ne

public final Condition ne(Select<?> query)
Description copied from interface: Field
this != (Select ...)

Specified by:
ne in interface Field<T>
See Also:
Field.notEqual(Select)

lt

public final Condition lt(T value)
Description copied from interface: Field
this < value

Specified by:
lt in interface Field<T>
See Also:
Field.lessThan(Object)

lt

public final Condition lt(Field<T> field)
Description copied from interface: Field
this < field

Specified by:
lt in interface Field<T>
See Also:
Field.lessThan(Field)

lt

public final Condition lt(Select<?> query)
Description copied from interface: Field
this < (Select ...)

Specified by:
lt in interface Field<T>
See Also:
Field.lessThan(Select)

le

public final Condition le(T value)
Description copied from interface: Field
this <= value

Specified by:
le in interface Field<T>
See Also:
Field.lessOrEqual(Object)

le

public final Condition le(Field<T> field)
Description copied from interface: Field
this <= field

Specified by:
le in interface Field<T>
See Also:
Field.lessOrEqual(Field)

le

public final Condition le(Select<?> query)
Description copied from interface: Field
this <= (Select ...)

Specified by:
le in interface Field<T>
See Also:
Field.lessOrEqual(Select)

gt

public final Condition gt(T value)
Description copied from interface: Field
this > value

Specified by:
gt in interface Field<T>
See Also:
Field.greaterThan(Object)

gt

public final Condition gt(Field<T> field)
Description copied from interface: Field
this > field

Specified by:
gt in interface Field<T>
See Also:
Field.greaterThan(Field)

gt

public final Condition gt(Select<?> query)
Description copied from interface: Field
this > (Select ...)

Specified by:
gt in interface Field<T>
See Also:
Field.greaterThan(Select)

ge

public final Condition ge(T value)
Description copied from interface: Field
this >= value

Specified by:
ge in interface Field<T>
See Also:
Field.greaterOrEqual(Object)

ge

public final Condition ge(Field<T> field)
Description copied from interface: Field
this >= field

Specified by:
ge in interface Field<T>
See Also:
Field.greaterOrEqual(Field)

ge

public final Condition ge(Select<?> query)
Description copied from interface: Field
this >= (Select ...)

Specified by:
ge in interface Field<T>
See Also:
Field.greaterOrEqual(Select)

equal

public final Condition equal(T value)
Description copied from interface: Field
this = value

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

Specified by:
equal in interface Field<T>

equal

public final Condition equal(Field<T> field)
Description copied from interface: Field
this = field

Specified by:
equal in interface Field<T>

equalIgnoreCase

public final Condition equalIgnoreCase(String value)
Description copied from interface: Field
lower(this) = lower(value)

Specified by:
equalIgnoreCase in interface Field<T>

equalIgnoreCase

public final Condition equalIgnoreCase(Field<String> value)
Description copied from interface: Field
lower(this) = lower(value)

Specified by:
equalIgnoreCase in interface Field<T>

equal

public final Condition equal(Select<?> query)
Description copied from interface: Field
this = (Select ...)

Specified by:
equal in interface Field<T>

equalAny

public final Condition equalAny(Select<?> query)
Description copied from interface: Field
this = any (Select ...)

Specified by:
equalAny in interface Field<T>

equalAny

public final Condition equalAny(T... array)
Description copied from interface: Field
this = any (array)

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

Specified by:
equalAny in interface Field<T>

equalAny

public final Condition equalAny(Field<T[]> array)
Description copied from interface: Field
this = any (array)

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

Specified by:
equalAny in interface Field<T>

equalSome

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

Description copied from interface: Field
this = some (Select ...)

Specified by:
equalSome in interface Field<T>

equalAll

public final Condition equalAll(Select<?> query)
Description copied from interface: Field
this = all (Select ...)

Specified by:
equalAll in interface Field<T>

equalAll

public final Condition equalAll(T... array)
Description copied from interface: Field
this = all (array)

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

Specified by:
equalAll in interface Field<T>

equalAll

public final Condition equalAll(Field<T[]> array)
Description copied from interface: Field
this = all (array)

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

Specified by:
equalAll in interface Field<T>

notEqual

public final Condition notEqual(T value)
Description copied from interface: Field
this != value

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

Specified by:
notEqual in interface Field<T>

notEqual

public final Condition notEqual(Field<T> field)
Description copied from interface: Field
this != field

Specified by:
notEqual in interface Field<T>

notEqualIgnoreCase

public final Condition notEqualIgnoreCase(String value)
Description copied from interface: Field
lower(this) != lower(value)

Specified by:
notEqualIgnoreCase in interface Field<T>

notEqualIgnoreCase

public final Condition notEqualIgnoreCase(Field<String> value)
Description copied from interface: Field
lower(this) != lower(value)

Specified by:
notEqualIgnoreCase in interface Field<T>

notEqual

public final Condition notEqual(Select<?> query)
Description copied from interface: Field
this != (Select ...)

Specified by:
notEqual in interface Field<T>

notEqualAny

public final Condition notEqualAny(Select<?> query)
Description copied from interface: Field
this != any (Select ...)

Specified by:
notEqualAny in interface Field<T>

notEqualAny

public final Condition notEqualAny(T... array)
Description copied from interface: Field
this != any (array)

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

Specified by:
notEqualAny in interface Field<T>

notEqualAny

public final Condition notEqualAny(Field<T[]> array)
Description copied from interface: Field
this != any (array)

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

Specified by:
notEqualAny in interface Field<T>

notEqualSome

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

Description copied from interface: Field
this != some (Select ...)

Specified by:
notEqualSome in interface Field<T>

notEqualAll

public final Condition notEqualAll(Select<?> query)
Description copied from interface: Field
this != all (Select ...)

Specified by:
notEqualAll in interface Field<T>

notEqualAll

public final Condition notEqualAll(T... array)
Description copied from interface: Field
this != all (array)

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

Specified by:
notEqualAll in interface Field<T>

notEqualAll

public final Condition notEqualAll(Field<T[]> array)
Description copied from interface: Field
this != all (array)

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

Specified by:
notEqualAll in interface Field<T>

lessThan

public final Condition lessThan(T value)
Description copied from interface: Field
this < value

Specified by:
lessThan in interface Field<T>

lessThan

public final Condition lessThan(Field<T> field)
Description copied from interface: Field
this < field

Specified by:
lessThan in interface Field<T>

lessThan

public final Condition lessThan(Select<?> query)
Description copied from interface: Field
this < (Select ...)

Specified by:
lessThan in interface Field<T>

lessThanAny

public final Condition lessThanAny(Select<?> query)
Description copied from interface: Field
this < any (Select ...)

Specified by:
lessThanAny in interface Field<T>

lessThanAny

public final Condition lessThanAny(T... array)
Description copied from interface: Field
this < any (array)

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

Specified by:
lessThanAny in interface Field<T>

lessThanAny

public final Condition lessThanAny(Field<T[]> array)
Description copied from interface: Field
this < any (array)

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

Specified by:
lessThanAny in interface Field<T>

lessThanSome

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

Description copied from interface: Field
this < some (Select ...)

Specified by:
lessThanSome in interface Field<T>

lessThanAll

public final Condition lessThanAll(Select<?> query)
Description copied from interface: Field
this < all (Select ...)

Specified by:
lessThanAll in interface Field<T>

lessThanAll

public final Condition lessThanAll(T... array)
Description copied from interface: Field
this < all (array)

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

Specified by:
lessThanAll in interface Field<T>

lessThanAll

public final Condition lessThanAll(Field<T[]> array)
Description copied from interface: Field
this < all (array)

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

Specified by:
lessThanAll in interface Field<T>

lessOrEqual

public final Condition lessOrEqual(T value)
Description copied from interface: Field
this <= value

Specified by:
lessOrEqual in interface Field<T>

lessOrEqual

public final Condition lessOrEqual(Field<T> field)
Description copied from interface: Field
this <= field

Specified by:
lessOrEqual in interface Field<T>

lessOrEqual

public final Condition lessOrEqual(Select<?> query)
Description copied from interface: Field
this <= (Select ...)

Specified by:
lessOrEqual in interface Field<T>

lessOrEqualAny

public final Condition lessOrEqualAny(Select<?> query)
Description copied from interface: Field
this <= any (Select ...)

Specified by:
lessOrEqualAny in interface Field<T>

lessOrEqualAny

public final Condition lessOrEqualAny(T... array)
Description copied from interface: Field
this <= any (array)

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

Specified by:
lessOrEqualAny in interface Field<T>

lessOrEqualAny

public final Condition lessOrEqualAny(Field<T[]> array)
Description copied from interface: Field
this <= any (array)

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

Specified by:
lessOrEqualAny in interface Field<T>

lessOrEqualSome

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

Description copied from interface: Field
this <= some (Select ...)

Specified by:
lessOrEqualSome in interface Field<T>

lessOrEqualAll

public final Condition lessOrEqualAll(Select<?> query)
Description copied from interface: Field
this <= all (Select ...)

Specified by:
lessOrEqualAll in interface Field<T>

lessOrEqualAll

public final Condition lessOrEqualAll(T... array)
Description copied from interface: Field
this <= all (array)

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

Specified by:
lessOrEqualAll in interface Field<T>

lessOrEqualAll

public final Condition lessOrEqualAll(Field<T[]> array)
Description copied from interface: Field
this <= all (array)

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

Specified by:
lessOrEqualAll in interface Field<T>

greaterThan

public final Condition greaterThan(T value)
Description copied from interface: Field
this > value

Specified by:
greaterThan in interface Field<T>

greaterThan

public final Condition greaterThan(Field<T> field)
Description copied from interface: Field
this > field

Specified by:
greaterThan in interface Field<T>

greaterThan

public final Condition greaterThan(Select<?> query)
Description copied from interface: Field
this > (Select ...)

Specified by:
greaterThan in interface Field<T>

greaterThanAny

public final Condition greaterThanAny(Select<?> query)
Description copied from interface: Field
this > any (Select ...)

Specified by:
greaterThanAny in interface Field<T>

greaterThanAny

public final Condition greaterThanAny(T... array)
Description copied from interface: Field
this > any (array)

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

Specified by:
greaterThanAny in interface Field<T>

greaterThanAny

public final Condition greaterThanAny(Field<T[]> array)
Description copied from interface: Field
this > any (array)

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

Specified by:
greaterThanAny in interface Field<T>

greaterThanSome

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

Description copied from interface: Field
this > some (Select ...)

Specified by:
greaterThanSome in interface Field<T>

greaterThanAll

public final Condition greaterThanAll(Select<?> query)
Description copied from interface: Field
this > all (Select ...)

Specified by:
greaterThanAll in interface Field<T>

greaterThanAll

public final Condition greaterThanAll(T... array)
Description copied from interface: Field
this > all (array)

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

Specified by:
greaterThanAll in interface Field<T>

greaterThanAll

public final Condition greaterThanAll(Field<T[]> array)
Description copied from interface: Field
this > all (array)

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

Specified by:
greaterThanAll in interface Field<T>

greaterOrEqual

public final Condition greaterOrEqual(T value)
Description copied from interface: Field
this >= value

Specified by:
greaterOrEqual in interface Field<T>

greaterOrEqual

public final Condition greaterOrEqual(Field<T> field)
Description copied from interface: Field
this >= field

Specified by:
greaterOrEqual in interface Field<T>

greaterOrEqual

public final Condition greaterOrEqual(Select<?> query)
Description copied from interface: Field
this >= (Select ...)

Specified by:
greaterOrEqual in interface Field<T>

greaterOrEqualAny

public final Condition greaterOrEqualAny(Select<?> query)
Description copied from interface: Field
this >= any (Select ...)

Specified by:
greaterOrEqualAny in interface Field<T>

greaterOrEqualAny

public final Condition greaterOrEqualAny(T... array)
Description copied from interface: Field
this >= any (array)

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

Specified by:
greaterOrEqualAny in interface Field<T>

greaterOrEqualAny

public final Condition greaterOrEqualAny(Field<T[]> array)
Description copied from interface: Field
this >= any (array)

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

Specified by:
greaterOrEqualAny in interface Field<T>

greaterOrEqualSome

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

Description copied from interface: Field
this >= some (Select ...)

Specified by:
greaterOrEqualSome in interface Field<T>

greaterOrEqualAll

public final Condition greaterOrEqualAll(Select<?> query)
Description copied from interface: Field
this >= all (Select ...)

Specified by:
greaterOrEqualAll in interface Field<T>

greaterOrEqualAll

public final Condition greaterOrEqualAll(T... array)
Description copied from interface: Field
this >= all (array)

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

Specified by:
greaterOrEqualAll in interface Field<T>

greaterOrEqualAll

public final Condition greaterOrEqualAll(Field<T[]> array)
Description copied from interface: Field
this >= all (array)

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

Specified by:
greaterOrEqualAll in interface Field<T>

sign

@Deprecated
public final Field<Integer> sign()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
sign in interface Field<T>
See Also:
Factory.sign(Field)

abs

@Deprecated
public final Field<T> abs()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
abs in interface Field<T>
See Also:
Factory.abs(Field)

round

@Deprecated
public final Field<T> round()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
round in interface Field<T>
See Also:
Factory.round(Field)

round

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
round in interface Field<T>
See Also:
Factory.round(Field, int)

floor

@Deprecated
public final Field<T> floor()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
floor in interface Field<T>
See Also:
Factory.floor(Field)

ceil

@Deprecated
public final Field<T> ceil()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
ceil in interface Field<T>
See Also:
Factory.ceil(Field)

sqrt

@Deprecated
public final Field<BigDecimal> sqrt()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
sqrt in interface Field<T>
See Also:
Factory.sqrt(Field)

exp

@Deprecated
public final Field<BigDecimal> exp()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
exp in interface Field<T>
See Also:
Factory.exp(Field)

ln

@Deprecated
public final Field<BigDecimal> ln()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
ln in interface Field<T>
See Also:
Factory.ln(Field)

log

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
log in interface Field<T>
See Also:
Factory.log(Field, int)

power

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
power in interface Field<T>
See Also:
Factory.power(Field, Number)

acos

@Deprecated
public final Field<BigDecimal> acos()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
acos in interface Field<T>
See Also:
Factory.acos(Field)

asin

@Deprecated
public final Field<BigDecimal> asin()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
asin in interface Field<T>
See Also:
Factory.asin(Field)

atan

@Deprecated
public final Field<BigDecimal> atan()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
atan in interface Field<T>
See Also:
Factory.atan(Field)

atan2

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
atan2 in interface Field<T>
See Also:
Factory.atan2(Field, Number)

atan2

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
atan2 in interface Field<T>
See Also:
Factory.atan2(Field, Field)

cos

@Deprecated
public final Field<BigDecimal> cos()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
cos in interface Field<T>
See Also:
Factory.cos(Field)

sin

@Deprecated
public final Field<BigDecimal> sin()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
sin in interface Field<T>
See Also:
Factory.sin(Field)

tan

@Deprecated
public final Field<BigDecimal> tan()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
tan in interface Field<T>
See Also:
Factory.tan(Field)

cot

@Deprecated
public final Field<BigDecimal> cot()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
cot in interface Field<T>
See Also:
Factory.cot(Field)

sinh

@Deprecated
public final Field<BigDecimal> sinh()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
sinh in interface Field<T>
See Also:
Factory.sinh(Field)

cosh

@Deprecated
public final Field<BigDecimal> cosh()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
cosh in interface Field<T>
See Also:
Factory.cosh(Field)

tanh

@Deprecated
public final Field<BigDecimal> tanh()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
tanh in interface Field<T>
See Also:
Factory.tanh(Field)

coth

@Deprecated
public final Field<BigDecimal> coth()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
coth in interface Field<T>
See Also:
Factory.coth(Field)

deg

@Deprecated
public final Field<BigDecimal> deg()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
deg in interface Field<T>
See Also:
Factory.deg(Field)

rad

@Deprecated
public final Field<BigDecimal> rad()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
rad in interface Field<T>
See Also:
Factory.rad(Field)

count

@Deprecated
public final Field<Integer> count()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
count in interface Field<T>
See Also:
Factory.count(Field)

countDistinct

@Deprecated
public final Field<Integer> countDistinct()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
countDistinct in interface Field<T>
See Also:
Factory.countDistinct(Field)

max

@Deprecated
public final Field<T> max()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
max in interface Field<T>
See Also:
Factory.max(Field)

min

@Deprecated
public final Field<T> min()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
min in interface Field<T>
See Also:
Factory.min(Field)

sum

@Deprecated
public final Field<BigDecimal> sum()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
sum in interface Field<T>
See Also:
Factory.sum(Field)

avg

@Deprecated
public final Field<BigDecimal> avg()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
avg in interface Field<T>
See Also:
Factory.avg(Field)

median

@Deprecated
public final Field<BigDecimal> median()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
median in interface Field<T>
See Also:
Factory.median(Field)

stddevPop

@Deprecated
public final Field<BigDecimal> stddevPop()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
stddevPop in interface Field<T>
See Also:
Factory.stddevPop(Field)

stddevSamp

@Deprecated
public final Field<BigDecimal> stddevSamp()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
stddevSamp in interface Field<T>
See Also:
Factory.stddevSamp(Field)

varPop

@Deprecated
public final Field<BigDecimal> varPop()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
varPop in interface Field<T>
See Also:
Factory.varPop(Field)

varSamp

@Deprecated
public final Field<BigDecimal> varSamp()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
varSamp in interface Field<T>
See Also:
Factory.varSamp(Field)

countOver

@Deprecated
public final WindowPartitionByStep<Integer> countOver()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
countOver in interface Field<T>
See Also:
Factory.count(Field), AggregateFunction.over()

maxOver

@Deprecated
public final WindowPartitionByStep<T> maxOver()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
maxOver in interface Field<T>
See Also:
Factory.max(Field), AggregateFunction.over()

minOver

@Deprecated
public final WindowPartitionByStep<T> minOver()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
minOver in interface Field<T>
See Also:
Factory.min(Field), AggregateFunction.over()

sumOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> sumOver()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
sumOver in interface Field<T>
See Also:
Factory.sum(Field), AggregateFunction.over()

avgOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> avgOver()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
avgOver in interface Field<T>
See Also:
Factory.avg(Field), AggregateFunction.over()

firstValue

@Deprecated
public final WindowIgnoreNullsStep<T> firstValue()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
firstValue in interface Field<T>
See Also:
Factory.firstValue(Field), AggregateFunction.over()

lastValue

@Deprecated
public final WindowIgnoreNullsStep<T> lastValue()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lastValue in interface Field<T>
See Also:
Factory.lastValue(Field), AggregateFunction.over()

lead

@Deprecated
public final WindowIgnoreNullsStep<T> lead()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lead in interface Field<T>
See Also:
Factory.lead(Field), AggregateFunction.over()

lead

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lead in interface Field<T>
See Also:
Factory.lead(Field, int), AggregateFunction.over()

lead

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lead in interface Field<T>
See Also:
Factory.lead(Field, int, Object), AggregateFunction.over()

lead

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lead in interface Field<T>
See Also:
Factory.lead(Field, int, Field), AggregateFunction.over()

lag

@Deprecated
public final WindowIgnoreNullsStep<T> lag()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lag in interface Field<T>
See Also:
Factory.lag(Field), AggregateFunction.over()

lag

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lag in interface Field<T>
See Also:
Factory.lag(Field, int), AggregateFunction.over()

lag

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lag in interface Field<T>
See Also:
Factory.lag(Field, int, Object), AggregateFunction.over()

lag

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lag in interface Field<T>
See Also:
Factory.lag(Field, int, Field), AggregateFunction.over()

stddevPopOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> stddevPopOver()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
stddevPopOver in interface Field<T>
See Also:
Factory.stddevPop(Field), AggregateFunction.over()

stddevSampOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> stddevSampOver()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
stddevSampOver in interface Field<T>
See Also:
Factory.stddevSamp(Field), AggregateFunction.over()

varPopOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> varPopOver()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
varPopOver in interface Field<T>
See Also:
Factory.varPop(Field), AggregateFunction.over()

varSampOver

@Deprecated
public final WindowPartitionByStep<BigDecimal> varSampOver()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
varSampOver in interface Field<T>
See Also:
Factory.varSamp(Field), AggregateFunction.over()

upper

@Deprecated
public final Field<String> upper()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
upper in interface Field<T>
See Also:
Factory.upper(Field)

lower

@Deprecated
public final Field<String> lower()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lower in interface Field<T>
See Also:
Factory.lower(Field)

trim

@Deprecated
public final Field<String> trim()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
trim in interface Field<T>
See Also:
Factory.trim(Field)

rtrim

@Deprecated
public final Field<String> rtrim()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
rtrim in interface Field<T>
See Also:
Factory.rtrim(Field)

ltrim

@Deprecated
public final Field<String> ltrim()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
ltrim in interface Field<T>
See Also:
Factory.ltrim(Field)

rpad

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
rpad in interface Field<T>
See Also:
Factory.rpad(Field, Field)

rpad

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
rpad in interface Field<T>
See Also:
Factory.rpad(Field, int)

rpad

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
rpad in interface Field<T>
See Also:
Factory.rpad(Field, Field, Field)

rpad

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
rpad in interface Field<T>
See Also:
Factory.rpad(Field, int, char)

lpad

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lpad in interface Field<T>
See Also:
Factory.lpad(Field, Field)

lpad

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lpad in interface Field<T>
See Also:
Factory.lpad(Field, int)

lpad

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lpad in interface Field<T>
See Also:
Factory.lpad(Field, Field, Field)

lpad

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
lpad in interface Field<T>
See Also:
Factory.lpad(Field, int, char)

repeat

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
repeat in interface Field<T>
See Also:
Factory.repeat(Field, int)

repeat

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
repeat in interface Field<T>
See Also:
Factory.repeat(Field, Field)

replace

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
replace in interface Field<T>
See Also:
Factory.replace(Field, Field)

replace

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
replace in interface Field<T>
See Also:
Factory.replace(Field, String)

replace

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
replace in interface Field<T>
See Also:
Factory.replace(Field, Field, Field)

replace

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
replace in interface Field<T>
See Also:
Factory.replace(Field, String, String)

position

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
position in interface Field<T>
See Also:
Factory.position(Field, String)

position

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
position in interface Field<T>
See Also:
Factory.position(Field, Field)

ascii

@Deprecated
public final Field<Integer> ascii()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
ascii in interface Field<T>
See Also:
Factory.ascii(Field)

concat

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
concat in interface Field<T>
See Also:
Factory.concat(Field...)

concat

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
concat in interface Field<T>
See Also:
Factory.concat(String...)

substring

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
substring in interface Field<T>
See Also:
Factory.substring(Field, int)

substring

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
substring in interface Field<T>
See Also:
Factory.substring(Field, Field)

substring

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
substring in interface Field<T>
See Also:
Factory.substring(Field, int, int)

substring

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
substring in interface Field<T>
See Also:
Factory.substring(Field, Field, Field)

length

@Deprecated
public final Field<Integer> length()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
length in interface Field<T>
See Also:
Factory.length(Field)

charLength

@Deprecated
public final Field<Integer> charLength()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
charLength in interface Field<T>
See Also:
Factory.charLength(Field)

bitLength

@Deprecated
public final Field<Integer> bitLength()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
bitLength in interface Field<T>
See Also:
Factory.bitLength(Field)

octetLength

@Deprecated
public final Field<Integer> octetLength()
Deprecated. 

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
octetLength in interface Field<T>
See Also:
Factory.octetLength(Field)

extract

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
extract in interface Field<T>
See Also:
Factory.extract(Field, DatePart)

greatest

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
greatest in interface Field<T>
See Also:
Factory.greatest(Field, Field...)

greatest

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
greatest in interface Field<T>
See Also:
Factory.greatest(Field, Field...)

least

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
least in interface Field<T>
See Also:
Factory.least(Field, Field...)

least

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
least in interface Field<T>
See Also:
Factory.least(Field, Field...)

nvl

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
nvl in interface Field<T>
See Also:
Factory.nvl(Field, Object)

nvl

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
nvl in interface Field<T>
See Also:
Factory.nvl(Field, Field)

nvl2

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
nvl2 in interface Field<T>
See Also:
Factory.nvl2(Field, Object, Object)

nvl2

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
nvl2 in interface Field<T>
See Also:
Factory.nvl2(Field, Field, Field)

nullif

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
nullif in interface Field<T>
See Also:
Factory.nullif(Field, Object)

nullif

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
nullif in interface Field<T>
See Also:
Factory.nullif(Field, Field)

decode

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
decode in interface Field<T>
See Also:
Factory.decode(Object, Object, Object)

decode

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
decode in interface Field<T>
See Also:
Factory.decode(Object, Object, Object, Object...)

decode

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
decode in interface Field<T>
See Also:
Factory.decode(Field, Field, Field)

decode

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
decode in interface Field<T>
See Also:
Factory.decode(Field, Field, Field, Field...)

coalesce

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
coalesce in interface Field<T>
See Also:
Factory.coalesce(Object, Object...)

coalesce

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

Description copied from interface: Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from Factory

Specified by:
coalesce in interface Field<T>
See Also:
Factory.coalesce(Field, Field...)

getDataType

public final DataType<T> getDataType()
Description copied from interface: NamedTypeProviderQueryPart
The type of this object (might not be dialect-specific)

Specified by:
getDataType in interface NamedTypeProviderQueryPart<T>

getSQLDataType

protected final SQLDataType<T> getSQLDataType()

getDataType

public final DataType<T> getDataType(Configuration configuration)
Description copied from interface: NamedTypeProviderQueryPart
The dialect-specific type of this object

Specified by:
getDataType in interface NamedTypeProviderQueryPart<T>

getType

public final Class<? extends T> getType()
Description copied from interface: NamedTypeProviderQueryPart
The type of this object

Specified by:
getType in interface NamedTypeProviderQueryPart<T>

getName

public final String getName()
Description copied from interface: NamedQueryPart
The name of this query part

Specified by:
getName in interface NamedQueryPart

compareTo

public final int compareTo(NamedQueryPart that)
Specified by:
compareTo in interface Comparable<NamedQueryPart>

internalAPI

public final <I> I internalAPI(Class<I> internalType)
Description copied from interface: Adapter
Adapt to an internal type assuming its functionality

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

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

Specified by:
internalAPI in interface Adapter
Type Parameters:
I - The internal type's generic type parameter.
Parameters:
internalType - The internal type
Returns:
This object wrapped by or cast to an internal type

getDialect

@Deprecated
public final SQLDialect getDialect()
Deprecated. 

Description copied from interface: QueryPartInternal
Reproduce the SQL dialect this QueryPart was created with

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

Specified by:
getDialect in interface QueryPartInternal
Returns:
The SQL dialect

getSQL

public final String getSQL()
This method is also declared as Query.getSQL()

Retrieve the SQL that will be rendered by this QueryPart

This method is exposed publicly in Query.getSQL()

Specified by:
getSQL in interface QueryPartInternal

getSQL

public final String getSQL(boolean inline)
This method is also declared as Query.getSQL(boolean)

Retrieve the SQL that will be rendered by this QueryPart

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

Specified by:
getSQL in interface QueryPartInternal

getBindValues

public final List<Object> getBindValues()
This method is also declared as Query.getBindValues()

Retrieve the bind values that will be bound by this QueryPart

This method is exposed publicly in Query.getBindValues()

Specified by:
getBindValues in interface QueryPartInternal

getParams

public final Map<String,Param<?>> getParams()
This method is also declared as Query.getParams()

Retrieve the named parameters that will be bound by this QueryPart

This method is exposed publicly in Query.getParams()

Specified by:
getParams in interface QueryPartInternal

getParam

public final Param<?> getParam(String name)
This method is also declared as Query.getParam(String)

Retrieve a named parameter that will be bound by this QueryPart

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

Specified by:
getParam in interface QueryPartInternal

equals

public boolean equals(Object that)
Overrides:
equals in class Object

hashCode

public int hashCode()
Overrides:
hashCode in class Object

toString

public String toString()
Overrides:
toString in class Object

create

protected final Factory create()
Internal convenience method

create

protected final Factory create(Configuration configuration)
Internal convenience method

translate

@Deprecated
protected final DataAccessException translate(String task,
                                                         String sql,
                                                         SQLException e)
Deprecated. - 2.3.0 - Do not reuse

Internal convenience method

translate

protected final DataAccessException translate(String sql,
                                              SQLException e)
Internal convenience method

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.