NullIf (jOOQ 3.3.4 API)

java.lang.Object
- org.jooq.impl.NullIf<T>

All Implemented Interfaces:

Serializable, Field<T>, GroupField, QueryPart, QueryPartInternal
```
public class NullIf<T>
extends Object
```
Author:

Lukas Eder

See Also:

Serialized Form

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`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.
`Field<BigDecimal>`	`avg()` Deprecated.
`WindowPartitionByStep<BigDecimal>`	`avgOver()` Deprecated.
`BetweenAndStep<T>`	`between(Field<T> minValue)` Create a condition to check this field against some bounds.
`Condition`	`between(Field<T> minValue, Field<T> maxValue)` Create a condition to check this field against some bounds.
`BetweenAndStep<T>`	`between(T minValue)` Create a condition to check this field against some bounds.
`Condition`	`between(T minValue, T maxValue)` Create a condition to check this field against some bounds.
`BetweenAndStep<T>`	`betweenSymmetric(Field<T> minValue)` Create a condition to check this field against some bounds.
`Condition`	`betweenSymmetric(Field<T> minValue, Field<T> maxValue)` Create a condition to check this field against some bounds.
`BetweenAndStep<T>`	`betweenSymmetric(T minValue)` Create a condition to check this field against some bounds.
`Condition`	`betweenSymmetric(T minValue, T maxValue)` Create a condition to check this field against some bounds.
`void`	`bind(BindContext ctx)` Bind all parameters of this `QueryPart` to a PreparedStatement This method is for JOOQ INTERNAL USE only.
`Field<T>`	`bitAnd(Field<T> value)` The bitwise and operator.
`Field<T>`	`bitAnd(T value)` The bitwise and operator.
`Field<Integer>`	`bitLength()` Deprecated.
`Field<T>`	`bitNand(Field<T> value)` The bitwise not and operator.
`Field<T>`	`bitNand(T value)` The bitwise not and operator.
`Field<T>`	`bitNor(Field<T> value)` The bitwise not or operator.
`Field<T>`	`bitNor(T value)` The bitwise not or operator.
`Field<T>`	`bitNot()` The bitwise not operator.
`Field<T>`	`bitOr(Field<T> value)` The bitwise or operator.
`Field<T>`	`bitOr(T value)` The bitwise or operator.
`Field<T>`	`bitXNor(Field<T> value)` The bitwise not xor operator.
`Field<T>`	`bitXNor(T value)` The bitwise not xor operator.
`Field<T>`	`bitXor(Field<T> value)` The bitwise xor operator.
`Field<T>`	`bitXor(T value)` The bitwise xor operator.
`<Z> Field<Z>`	`cast(Class<Z> type)` Cast this field to another type.
`<Z> Field<Z>`	`cast(DataType<Z> type)` Cast this field to a dialect-specific data type.
`<Z> Field<Z>`	`cast(Field<Z> field)` Cast this field to the type of another field.
`Field<T>`	`ceil()` Deprecated.
`Field<Integer>`	`charLength()` Deprecated.
`Clause[]`	`clauses(Context<?> ctx)` The `Clause`s that are represented by this query part.
`Field<T>`	`coalesce(Field<T> option, Field<?>... options)` Deprecated.
`Field<T>`	`coalesce(T option, T... options)` Deprecated.
`<Z> Field<Z>`	`coerce(Class<Z> type)` Coerce this field to another type.
`<Z> Field<Z>`	`coerce(DataType<Z> type)` Coerce this field to a dialect-specific data type.
`<Z> Field<Z>`	`coerce(Field<Z> field)` Coerce this field to the type of another field.
`Condition`	`compare(Comparator comparator, Field<T> field)` Compare this field with another field using a dynamic comparator.
`Condition`	`compare(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query)` Compare this field with a quantified subselect using a dynamic comparator.
`Condition`	`compare(Comparator comparator, Select<? extends Record1<T>> query)` Compare this field with a subselect using a dynamic comparator.
`Condition`	`compare(Comparator comparator, T value)` Compare this field with a value using a dynamic comparator.
`Field<String>`	`concat(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.
`Condition`	`contains(T value)` Convenience method for `Field.like(String, char)` including proper adding of wildcards and escaping.
`Field<BigDecimal>`	`cos()` Deprecated.
`Field<BigDecimal>`	`cosh()` Deprecated.
`Field<BigDecimal>`	`cot()` Deprecated.
`Field<BigDecimal>`	`coth()` Deprecated.
`Field<Integer>`	`count()` Deprecated.
`Field<Integer>`	`countDistinct()` Deprecated.
`WindowPartitionByStep<Integer>`	`countOver()` Deprecated.
`protected DSLContext`	`create()` Internal convenience method
`protected DSLContext`	`create(BindContext ctx)` Internal convenience method
`protected DSLContext`	`create(Configuration configuration)` Internal convenience method
`protected DSLContext`	`create(RenderContext ctx)` Internal convenience method
`boolean`	`declaresFields()` Subclasses may override this
`boolean`	`declaresTables()` Subclasses may override this
`boolean`	`declaresWindows()` Subclasses may override this
`<Z> Field<Z>`	`decode(Field<T> search, Field<Z> result)` Deprecated.
`<Z> Field<Z>`	`decode(Field<T> search, Field<Z> result, Field<?>... more)` Deprecated.
`<Z> Field<Z>`	`decode(T search, Z result)` Deprecated.
`<Z> Field<Z>`	`decode(T search, Z result, Object... more)` Deprecated.
`Field<BigDecimal>`	`deg()` Deprecated.
`SortField<T>`	`desc()` Create a descending sort field from this field.
`Field<T>`	`div(Field<? extends Number> value)` An arithmetic expression dividing this by value.
`Field<T>`	`div(Number value)` An arithmetic expression dividing this by value.
`Field<T>`	`divide(Field<? extends Number> value)` An alias for `Field.div(Field)`.
`Field<T>`	`divide(Number value)` An alias for `Field.div(Number)`.
`Condition`	`endsWith(Field<T> value)` Convenience method for `Field.like(String, char)` including proper adding of wildcards and escaping.
`Condition`	`endsWith(T value)` Convenience method for `Field.like(String, char)` including proper adding of wildcards and escaping.
`Condition`	`eq(Field<T> field)` `this = field`.
`Condition`	`eq(QuantifiedSelect<? extends Record1<T>> query)` `this = [quantifier] (Select`
`Condition`	`eq(Select<? extends Record1<T>> query)` `this = (Select`
`Condition`	`eq(T value)` `this = value`.
`Condition`	`equal(Field<T> field)` `this = field`.
`Condition`	`equal(QuantifiedSelect<? extends Record1<T>> query)` `this = [quantifier] (Select`
`Condition`	`equal(Select<? extends Record1<T>> query)` `this = (Select`
`Condition`	`equal(T value)` `this = value`.
`Condition`	`equalIgnoreCase(Field<String> value)` `lower(this) = lower(value)`.
`Condition`	`equalIgnoreCase(String value)` `lower(this) = lower(value)`.
`boolean`	`equals(Object that)` Check whether this `QueryPart` can be considered equal to another `QueryPart`.
`Field<BigDecimal>`	`exp()` Deprecated.
`Field<Integer>`	`extract(DatePart datePart)` Deprecated.
`WindowIgnoreNullsStep<T>`	`firstValue()` Deprecated.
`Field<T>`	`floor()` Deprecated.
`Condition`	`ge(Field<T> field)` `this >= field`.
`Condition`	`ge(QuantifiedSelect<? extends Record1<T>> query)` `this >= [quantifier] (Select`
`Condition`	`ge(Select<? extends Record1<T>> query)` `this >= (Select`
`Condition`	`ge(T value)` `this >= value`.
`String`	`getComment()` The comment given to the field.
`Converter<?,T>`	`getConverter()` The field's underlying `Converter`.
`DataType<T>`	`getDataType()` The type of this field (might not be dialect-specific).
`DataType<T>`	`getDataType(Configuration configuration)` The dialect-specific type of this field.
`String`	`getName()` The name of the field.
`Class<T>`	`getType()` The Java type of the field.
`Condition`	`greaterOrEqual(Field<T> field)` `this >= field`.
`Condition`	`greaterOrEqual(QuantifiedSelect<? extends Record1<T>> query)` `this >= [quantifier] (Select`
`Condition`	`greaterOrEqual(Select<? extends Record1<T>> query)` `this >= (Select`
`Condition`	`greaterOrEqual(T value)` `this >= value`.
`Condition`	`greaterThan(Field<T> field)` `this > field`.
`Condition`	`greaterThan(QuantifiedSelect<? extends Record1<T>> query)` `this > [quantifier] (Select`
`Condition`	`greaterThan(Select<? extends Record1<T>> query)` `this > (Select`
`Condition`	`greaterThan(T value)` `this > value`.
`Field<T>`	`greatest(Field<?>... others)` Deprecated.
`Field<T>`	`greatest(T... others)` Deprecated.
`Condition`	`gt(Field<T> field)` `this > field`.
`Condition`	`gt(QuantifiedSelect<? extends Record1<T>> query)` `this > [quantifier] (Select`
`Condition`	`gt(Select<? extends Record1<T>> query)` `this > (Select`
`Condition`	`gt(T value)` `this > value`.
`int`	`hashCode()` Generate a hash code from this `QueryPart`.
`Condition`	`in(Collection<T> values)` Create a condition to check this field against several values.
`Condition`	`in(Field<?>... values)` Create a condition to check this field against several values.
`Condition`	`in(Select<? extends Record1<T>> query)` Create a condition to check this field against a subquery.
`Condition`	`in(T... values)` Create a condition to check this field against several values.
`Condition`	`isDistinctFrom(Field<T> field)` Create a condition to check if this field is `DISTINCT` from another field.
`Condition`	`isDistinctFrom(T value)` Create a condition to check if this field is `DISTINCT` from another value.
`Condition`	`isFalse()` Create a condition to check this field against known string literals for `false`.
`Condition`	`isNotDistinctFrom(Field<T> field)` Create a condition to check if this field is `NOT DISTINCT` from another field.
`Condition`	`isNotDistinctFrom(T value)` Create a condition to check if this field is `NOT DISTINCT` from another value.
`Condition`	`isNotNull()` Create a condition to check this field against `null`.
`Condition`	`isNull()` Create a condition to check this field against `null`.
`Condition`	`isTrue()` Create a condition to check this field against known string literals for `true`.
`WindowIgnoreNullsStep<T>`	`lag()` Deprecated.
`WindowIgnoreNullsStep<T>`	`lag(int offset)` Deprecated.
`WindowIgnoreNullsStep<T>`	`lag(int offset, Field<T> defaultValue)` Deprecated.
`WindowIgnoreNullsStep<T>`	`lag(int offset, T defaultValue)` Deprecated.
`WindowIgnoreNullsStep<T>`	`lastValue()` Deprecated.
`Condition`	`le(Field<T> field)` `this <= field`.
`Condition`	`le(QuantifiedSelect<? extends Record1<T>> query)` `this <= [quantifier] (Select`
`Condition`	`le(Select<? extends Record1<T>> query)` `this <= (Select`
`Condition`	`le(T value)` `this <= value`.
`WindowIgnoreNullsStep<T>`	`lead()` Deprecated.
`WindowIgnoreNullsStep<T>`	`lead(int offset)` Deprecated.
`WindowIgnoreNullsStep<T>`	`lead(int offset, Field<T> defaultValue)` Deprecated.
`WindowIgnoreNullsStep<T>`	`lead(int offset, T defaultValue)` Deprecated.
`Field<T>`	`least(Field<?>... others)` Deprecated.
`Field<T>`	`least(T... others)` Deprecated.
`Field<Integer>`	`length()` Deprecated.
`Condition`	`lessOrEqual(Field<T> field)` `this <= field`.
`Condition`	`lessOrEqual(QuantifiedSelect<? extends Record1<T>> query)` `this <= [quantifier] (Select`
`Condition`	`lessOrEqual(Select<? extends Record1<T>> query)` `this <= (Select`
`Condition`	`lessOrEqual(T value)` `this <= value`.
`Condition`	`lessThan(Field<T> field)` `this < field`.
`Condition`	`lessThan(QuantifiedSelect<? extends Record1<T>> query)` `this < [quantifier] (Select`
`Condition`	`lessThan(Select<? extends Record1<T>> query)` `this < (Select`
`Condition`	`lessThan(T value)` `this < value`.
`Condition`	`like(Field<String> field)` Create a condition to pattern-check this field against a value.
`Condition`	`like(Field<String> field, char escape)` Create a condition to pattern-check this field against a value.
`Condition`	`like(String value)` Create a condition to pattern-check this field against a value.
`Condition`	`like(String value, char escape)` Create a condition to pattern-check this field against a value.
`Condition`	`likeIgnoreCase(Field<String> field)` Create a condition to case-insensitively pattern-check this field against a field.
`Condition`	`likeIgnoreCase(Field<String> field, char escape)` Create a condition to case-insensitively pattern-check this field against a field.
`Condition`	`likeIgnoreCase(String value)` Create a condition to case-insensitively pattern-check this field against a value.
`Condition`	`likeIgnoreCase(String value, char escape)` Create a condition to case-insensitively pattern-check this field against a value.
`Condition`	`likeRegex(Field<String> pattern)` Create a condition to regex-pattern-check this field against a pattern.
`Condition`	`likeRegex(String pattern)` Create a condition to regex-pattern-check this field against a pattern.
`Field<BigDecimal>`	`ln()` Deprecated.
`Field<BigDecimal>`	`log(int base)` Deprecated.
`Field<String>`	`lower()` Deprecated.
`Field<String>`	`lpad(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(QuantifiedSelect<? extends Record1<T>> query)` `this < [quantifier] (Select`
`Condition`	`lt(Select<? extends Record1<T>> query)` `this < (Select`
`Condition`	`lt(T value)` `this < value`.
`Field<String>`	`ltrim()` Deprecated.
`Field<T>`	`max()` Deprecated.
`WindowPartitionByStep<T>`	`maxOver()` Deprecated.
`Field<BigDecimal>`	`median()` Deprecated.
`Field<T>`	`min()` Deprecated.
`WindowPartitionByStep<T>`	`minOver()` Deprecated.
`Field<T>`	`minus(Field<?> value)` An alias for `Field.sub(Field)`.
`Field<T>`	`minus(Number value)` An alias for `Field.sub(Number)`.
`Field<T>`	`mod(Field<? extends Number> value)` An arithmetic expression getting the modulo of this divided by value.
`Field<T>`	`mod(Number value)` An arithmetic expression getting the modulo of this divided by value.
`Field<T>`	`modulo(Field<? extends Number> value)` An alias for `Field.mod(Field)`.
`Field<T>`	`modulo(Number value)` An alias for `Field.mod(Number)`.
`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.
`Field<T>`	`multiply(Field<? extends Number> value)` An alias for `Field.mul(Field)`.
`Field<T>`	`multiply(Number value)` An alias for `Field.mul(Number)`.
`Condition`	`ne(Field<T> field)` `this !`
`Condition`	`ne(QuantifiedSelect<? extends Record1<T>> query)` `this !`
`Condition`	`ne(Select<? extends Record1<T>> query)` `this !`
`Condition`	`ne(T value)` `this !`
`Field<T>`	`neg()` Negate this field to get its negative value.
`BetweenAndStep<T>`	`notBetween(Field<T> minValue)` Create a condition to check this field against some bounds.
`Condition`	`notBetween(Field<T> minValue, Field<T> maxValue)` Create a condition to check this field against some bounds.
`BetweenAndStep<T>`	`notBetween(T minValue)` Create a condition to check this field against some bounds.
`Condition`	`notBetween(T minValue, T maxValue)` Create a condition to check this field against some bounds.
`BetweenAndStep<T>`	`notBetweenSymmetric(Field<T> minValue)` Create a condition to check this field against some bounds.
`Condition`	`notBetweenSymmetric(Field<T> minValue, Field<T> maxValue)` Create a condition to check this field against some bounds.
`BetweenAndStep<T>`	`notBetweenSymmetric(T minValue)` Create a condition to check this field against some bounds.
`Condition`	`notBetweenSymmetric(T minValue, T maxValue)` Create a condition to check this field against some bounds.
`Condition`	`notEqual(Field<T> field)` `this !`
`Condition`	`notEqual(QuantifiedSelect<? extends Record1<T>> query)` `this !`
`Condition`	`notEqual(Select<? extends Record1<T>> query)` `this !`
`Condition`	`notEqual(T value)` `this !`
`Condition`	`notEqualIgnoreCase(Field<String> value)` `lower(this) !`
`Condition`	`notEqualIgnoreCase(String value)` `lower(this) !`
`Condition`	`notIn(Collection<T> values)` Create a condition to check this field against several values.
`Condition`	`notIn(Field<?>... values)` Create a condition to check this field against several values.
`Condition`	`notIn(Select<? extends Record1<T>> query)` Create a condition to check this field against a subquery.
`Condition`	`notIn(T... values)` Create a condition to check this field against several values.
`Condition`	`notLike(Field<String> field)` Create a condition to pattern-check this field against a field.
`Condition`	`notLike(Field<String> field, char escape)` Create a condition to pattern-check this field against a field.
`Condition`	`notLike(String value)` Create a condition to pattern-check this field against a value.
`Condition`	`notLike(String value, char escape)` Create a condition to pattern-check this field against a value.
`Condition`	`notLikeIgnoreCase(Field<String> field)` Create a condition to case-insensitively pattern-check this field against a field.
`Condition`	`notLikeIgnoreCase(Field<String> field, char escape)` Create a condition to case-insensitively pattern-check this field against a field.
`Condition`	`notLikeIgnoreCase(String value)` Create a condition to case-insensitively pattern-check this field against a value.
`Condition`	`notLikeIgnoreCase(String value, char escape)` Create a condition to case-insensitively pattern-check this field against a value.
`Condition`	`notLikeRegex(Field<String> pattern)` Create a condition to regex-pattern-check this field against a pattern.
`Condition`	`notLikeRegex(String pattern)` Create a condition to regex-pattern-check this field against a pattern.
`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<T>`	`plus(Field<?> value)` An alias for `Field.add(Field)`.
`Field<T>`	`plus(Number value)` An alias for `Field.add(Number)`.
`Field<Integer>`	`position(Field<String> search)` Deprecated.
`Field<Integer>`	`position(String search)` Deprecated.
`Field<BigDecimal>`	`pow(Number exponent)` This method is part of the pre-2.0 API.
`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<T>`	`shl(Field<T> value)` The bitwise left shift operator.
`Field<T>`	`shl(T value)` The bitwise left shift operator.
`Field<T>`	`shr(Field<T> value)` The bitwise right shift operator.
`Field<T>`	`shr(T value)` The bitwise right shift operator.
`Field<Integer>`	`sign()` Deprecated.
`Field<BigDecimal>`	`sin()` Deprecated.
`Field<BigDecimal>`	`sinh()` Deprecated.
`<Z> SortField<Z>`	`sort(Map<T,Z> sortMap)` Create an indirected sort field.
`SortField<T>`	`sort(SortOrder order)` Create an ascending/descending sort field from this field.
`SortField<Integer>`	`sortAsc(Collection<T> sortList)` Create an indirected sort field.
`SortField<Integer>`	`sortAsc(T... sortList)` Create an indirected sort field.
`SortField<Integer>`	`sortDesc(Collection<T> sortList)` Create an indirected sort field.
`SortField<Integer>`	`sortDesc(T... sortList)` Create an indirected sort field.
`Field<BigDecimal>`	`sqrt()` Deprecated.
`Condition`	`startsWith(Field<T> value)` Convenience method for `Field.like(String, char)` including proper adding of wildcards and escaping.
`Condition`	`startsWith(T value)` Convenience method for `Field.like(String, char)` including proper adding of wildcards and escaping.
`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<T>`	`subtract(Field<?> value)` An alias for `Field.sub(Field)`.
`Field<T>`	`subtract(Number value)` An alias for `Field.sub(Number)`.
`Field<BigDecimal>`	`sum()` Deprecated.
`WindowPartitionByStep<BigDecimal>`	`sumOver()` Deprecated.
`Field<BigDecimal>`	`tan()` Deprecated.
`Field<BigDecimal>`	`tanh()` Deprecated.
`void`	`toSQL(RenderContext ctx)` Render this `QueryPart` to a SQL string contained in `context.sql()`.
`String`	`toString()` Render a SQL string of this `QueryPart` For improved debugging, this renders a SQL string of this `QueryPart` with inlined bind variables.
`protected DataAccessException`	`translate(String sql, SQLException e)` Internal convenience method
`Field<String>`	`trim()` Deprecated.
`Field<String>`	`upper()` Deprecated.
`Field<BigDecimal>`	`varPop()` Deprecated.
`WindowPartitionByStep<BigDecimal>`	`varPopOver()` Deprecated.
`Field<BigDecimal>`	`varSamp()` Deprecated.
`WindowPartitionByStep<BigDecimal>`	`varSampOver()` Deprecated.

Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.jooq.QueryPart
toString

Method Detail

toSQL
```
public final void toSQL(RenderContext ctx)
```
Description copied from interface: QueryPartInternal

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 final void bind(BindContext ctx)
```
Description copied from interface: QueryPartInternal

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:

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

clauses
```
public Clause[] clauses(Context<?> ctx)
```
Description copied from interface: QueryPartInternal

The Clauses that are represented by this query part.
QueryParts can specify several Clauses for which an event will be emitted before (in forward order) and after (in reverse order) visiting the the query part through Context.visit(QueryPart)
This method is for JOOQ INTERNAL USE only. Do not reference directly

Specified by:

clauses in interface QueryPartInternal

Returns:

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

as
```
public Field<T> as(String alias)
```
Description copied from interface: Field

Create an alias for this field.
Note that the case-sensitivity of the returned field depends on Settings.getRenderNameStyle(). By default, field aliases are quoted, and thus case-sensitive!

Specified by:

as in interface Field<T>

Parameters:

alias - The alias name

Returns:

The field alias

getName
```
public final String getName()
```
Description copied from interface: Field
The name of the field.
The name is any of these:
- The formal name of the field, if it is a physical table/view field
- The alias of an aliased field
- A generated / unspecified value for any other expression
- The name of a parameter if it is a named Param
Specified by:

getName in interface Field<T>

getComment
```
public final String getComment()
```
Description copied from interface: Field

The comment given to the field.
If this Field is a generated field from your database, it may provide its DDL comment through this method. All other column expressions return the empty string "" here, never null.

Specified by:

getComment in interface Field<T>

getConverter
```
public final Converter<?,T> getConverter()
```
Description copied from interface: Field

The field's underlying Converter.
By default, all fields reference an identity-converter Converter<T, T>. Custom data types may be obtained by a custom Converter placed on the generated TableField.

Specified by:

getConverter in interface Field<T>

getDataType
```
public final DataType<T> getDataType()
```
Description copied from interface: Field

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

Specified by:

getDataType in interface Field<T>

getDataType
```
public final DataType<T> getDataType(Configuration configuration)
```
Description copied from interface: Field

The dialect-specific type of this field.

Specified by:

getDataType in interface Field<T>

getType
```
public final Class<T> getType()
```
Description copied from interface: Field

The Java type of the field.

Specified by:

getType in interface Field<T>

cast
```
public final <Z> Field<Z> cast(Field<Z> field)
```
Description copied from interface: Field

Cast this field to the type of another field.
This results in the same as casting this field to DataType.getCastTypeName()

Specified by:

cast in interface Field<T>

Type Parameters:

Z - The generic type of the cast field

Parameters:

field - The field whose type is used for the cast

Returns:

The cast field

See Also:

Field.cast(DataType)

cast
```
public final <Z> Field<Z> cast(DataType<Z> type)
```
Description copied from interface: Field

Cast this field to a dialect-specific data type.

Specified by:

cast in interface Field<T>

Type Parameters:

Z - The generic type of the cast field

Parameters:

type - The data type that is used for the cast

Returns:

The cast field

cast
```
public final <Z> Field<Z> cast(Class<Z> type)
```
Description copied from interface: Field

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

Specified by:

cast in interface Field<T>

Type Parameters:

Z - The generic type of the cast field

Parameters:

type - The type that is used for the cast

Returns:

The cast field

See Also:

Field.cast(DataType)

coerce

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

Description copied from interface: Field

Coerce this field to the type of another field.

Unlike with casting, coercing doesn't affect the way the database sees a Field's type. This is how coercing affects your SQL:

Bind values

 // This binds an int value to a JDBC PreparedStatement
 DSL.val(1).coerce(String.class);

 // This binds an int value to a JDBC PreparedStatement
 // and casts it to VARCHAR in SQL
 DSL.val(1).cast(String.class);

Other Field types

 // This fetches a String value for the BOOK.ID field from JDBC
 BOOK.ID.coerce(String.class);

 // This fetches a String value for the BOOK.ID field from JDBC
 // after casting it to VARCHAR in the database
 BOOK.ID.cast(String.class);

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

coerce

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

Description copied from interface: Field

Coerce this field to a dialect-specific data type.

Unlike with casting, coercing doesn't affect the way the database sees a Field's type. This is how coercing affects your SQL:

Bind values

 // This binds an int value to a JDBC PreparedStatement
 DSL.val(1).coerce(String.class);

 // This binds an int value to a JDBC PreparedStatement
 // and casts it to VARCHAR in SQL
 DSL.val(1).cast(String.class);

Other Field types

 // This fetches a String value for the BOOK.ID field from JDBC
 BOOK.ID.coerce(String.class);

 // This fetches a String value for the BOOK.ID field from JDBC
 // after casting it to VARCHAR in the database
 BOOK.ID.cast(String.class);

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

coerce

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

Description copied from interface: Field

Coerce this field to another type.

Unlike with casting, coercing doesn't affect the way the database sees a Field's type. This is how coercing affects your SQL:

Bind values

 // This binds an int value to a JDBC PreparedStatement
 DSL.val(1).coerce(String.class);

 // This binds an int value to a JDBC PreparedStatement
 // and casts it to VARCHAR in SQL
 DSL.val(1).cast(String.class);

Other Field types

 // This fetches a String value for the BOOK.ID field from JDBC
 BOOK.ID.coerce(String.class);

 // This fetches a String value for the BOOK.ID field from JDBC
 // after casting it to VARCHAR in the database
 BOOK.ID.cast(String.class);

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

asc
```
public final SortField<T> asc()
```
Description copied from interface: Field

Create an ascending sort field from this field.
This is the same as calling Field.sort(SortOrder) with SortOrder.ASC

Specified by:

asc in interface Field<T>

Returns:

This field as an ascending sort field

desc
```
public final SortField<T> desc()
```
Description copied from interface: Field

Create a descending sort field from this field.
This is the same as calling Field.sort(SortOrder) with SortOrder.DESC

Specified by:

desc in interface Field<T>

Returns:

This field as a descending sort field

sort
```
public final SortField<T> sort(SortOrder order)
```
Description copied from interface: Field

Create an ascending/descending sort field from this field.

Specified by:

sort in interface Field<T>

Parameters:

order - The sort order

Returns:

This field as an ascending/descending sort field.

sortAsc
```
public final SortField<Integer> sortAsc(Collection<T> sortList)
```
Description copied from interface: Field
Create an indirected sort field.
Create a sort field of the form
```
 CASE [this] WHEN [sortList.get(0)] THEN 0
             WHEN [sortList.get(1)] THEN 1
             ...
             WHEN [sortList.get(n)] THEN n
                                    ELSE null
 END ASC
 
```
Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority.
Specified by:

sortAsc in interface Field<T>

Parameters:

sortList - The list containing sort value preferences

Returns:

The sort field

sortAsc
```
public final SortField<Integer> sortAsc(T... sortList)
```
Description copied from interface: Field
Create an indirected sort field.
Create a sort field of the form
```
 CASE [this] WHEN [sortList[0]] THEN 0
             WHEN [sortList[1]] THEN 1
             ...
             WHEN [sortList[n]] THEN n
                                ELSE null
 END ASC
 
```
Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority.
Specified by:

sortAsc in interface Field<T>

Parameters:

sortList - The list containing sort value preferences

Returns:

The sort field

sortDesc
```
public final SortField<Integer> sortDesc(Collection<T> sortList)
```
Description copied from interface: Field
Create an indirected sort field.
Create a sort field of the form
```
 CASE [this] WHEN [sortList.get(0)] THEN 0
             WHEN [sortList.get(1)] THEN 1
             ...
             WHEN [sortList.get(n)] THEN n
                                    ELSE null
 END DESC
 
```
Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority.
Specified by:

sortDesc in interface Field<T>

Parameters:

sortList - The list containing sort value preferences

Returns:

The sort field

sortDesc
```
public final SortField<Integer> sortDesc(T... sortList)
```
Description copied from interface: Field
Create an indirected sort field.
Create a sort field of the form
```
 CASE [this] WHEN [sortList[0]] THEN 0
             WHEN [sortList[1]] THEN 1
             ...
             WHEN [sortList[n]] THEN n
                                    ELSE null
 END DESC
 
```
Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority.
Specified by:

sortDesc in interface Field<T>

Parameters:

sortList - The list containing sort value preferences

Returns:

The sort field

sort
```
public final <Z> SortField<Z> sort(Map<T,Z> sortMap)
```
Description copied from interface: Field
Create an indirected sort field.
Create a sort field of the form (in pseudo code)
```
 CASE [this] WHEN [sortMap.key(0)] THEN sortMap.value(0)
             WHEN [sortMap.key(1)] THEN sortMap.value(1)
             ...
             WHEN [sortMap.key(n)] THEN sortMap.value(n)
                                   ELSE null
 END DESC
 
```
Note: You can use this in combination with SortField.nullsFirst() or SortField.nullsLast() to specify whether the default should have highest or lowest priority.
Specified by:

sort in interface Field<T>

Parameters:

sortMap - The list containing sort value preferences

Returns:

The sort field

neg
```
public final Field<T> neg()
```
Description copied from interface: Field
Negate this field to get its negative value.
This renders the same on all dialects:
```
-[this]
```
Specified by:

neg in interface Field<T>

add
```
public final Field<T> add(Number value)
```
Description copied from interface: Field

An arithmetic expression adding this to value.

Specified by:

add in interface Field<T>

See Also:

Field.add(Field)

add
```
public 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>

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

sub
```
public final Field<T> sub(Number value)
```
Description copied from interface: Field

An arithmetic expression subtracting value from this.

Specified by:

sub in interface Field<T>

See Also:

Field.sub(Field)

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

Operand 1 Operand 2 Result Type

Numeric Numeric Numeric

Date / Time Numeric Date / Time

Date / Time Interval Date / Time

Interval Interval Interval

In order to subtract one date time field from another, use any of these methods:
- DSL.dateDiff(Field, Field)
- DSL.timestampDiff(Field, Field)
Specified by:

sub in interface Field<T>

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

mul
```
public final Field<T> mul(Number value)
```
Description copied from interface: Field
An arithmetic expression multiplying this with value.
- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval)
Specified by:

mul in interface Field<T>

mul
```
public 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>

div
```
public final Field<T> div(Number value)
```
Description copied from interface: Field
An arithmetic expression dividing this by value.
- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval)
Specified by:

div in interface Field<T>

div
```
public final Field<T> div(Field<? extends Number> value)
```
Description copied from interface: Field
An arithmetic expression dividing this by value.
- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval)
Specified by:

div in interface Field<T>

mod
```
public final Field<T> mod(Number value)
```
Description copied from interface: Field
An arithmetic expression getting the modulo of this divided by value.
This renders the modulo operation where available:
```
[this] % [value]
```
... or the modulo function elsewhere: mod([this], [value])
Specified by:

mod in interface Field<T>

mod
```
public final Field<T> mod(Field<? extends Number> value)
```
Description copied from interface: Field
An arithmetic expression getting the modulo of this divided by value.
This renders the modulo operation where available:
```
[this] % [value]
```
... or the modulo function elsewhere: mod([this], [value])
Specified by:

mod in interface Field<T>

plus
```
public final Field<T> plus(Number value)
```
Description copied from interface: Field

An alias for Field.add(Number).

Specified by:

plus in interface Field<T>

See Also:

Field.add(Number)

plus
```
public final Field<T> plus(Field<?> value)
```
Description copied from interface: Field

An alias for Field.add(Field).

Specified by:

plus in interface Field<T>

See Also:

Field.add(Field)

subtract
```
public final Field<T> subtract(Number value)
```
Description copied from interface: Field

An alias for Field.sub(Number).

Specified by:

subtract in interface Field<T>

See Also:

Field.sub(Number)

subtract
```
public final Field<T> subtract(Field<?> value)
```
Description copied from interface: Field

An alias for Field.sub(Field).

Specified by:

subtract in interface Field<T>

See Also:

Field.sub(Field)

minus
```
public final Field<T> minus(Number value)
```
Description copied from interface: Field

An alias for Field.sub(Number).

Specified by:

minus in interface Field<T>

See Also:

Field.sub(Number)

minus
```
public final Field<T> minus(Field<?> value)
```
Description copied from interface: Field

An alias for Field.sub(Field).

Specified by:

minus in interface Field<T>

See Also:

Field.sub(Field)

multiply
```
public final Field<T> multiply(Number value)
```
Description copied from interface: Field

An alias for Field.mul(Number).

Specified by:

multiply in interface Field<T>

See Also:

Field.mul(Number)

multiply
```
public final Field<T> multiply(Field<? extends Number> value)
```
Description copied from interface: Field

An alias for Field.mul(Field).

Specified by:

multiply in interface Field<T>

See Also:

Field.mul(Field)

divide
```
public final Field<T> divide(Number value)
```
Description copied from interface: Field

An alias for Field.div(Number).

Specified by:

divide in interface Field<T>

See Also:

Field.div(Number)

divide
```
public final Field<T> divide(Field<? extends Number> value)
```
Description copied from interface: Field

An alias for Field.div(Field).

Specified by:

divide in interface Field<T>

See Also:

Field.div(Field)

modulo
```
public final Field<T> modulo(Number value)
```
Description copied from interface: Field

An alias for Field.mod(Number).

Specified by:

modulo in interface Field<T>

See Also:

Field.mod(Number)

modulo
```
public final Field<T> modulo(Field<? extends Number> value)
```
Description copied from interface: Field

An alias for Field.mod(Field).

Specified by:

modulo in interface Field<T>

See Also:

Field.mod(Field)

bitNot
```
public final Field<T> bitNot()
```
Description copied from interface: Field

The bitwise not operator.

Specified by:

bitNot in interface Field<T>

See Also:

DSL.bitNot(Field)

bitAnd
```
public final Field<T> bitAnd(T value)
```
Description copied from interface: Field

The bitwise and operator.

Specified by:

bitAnd in interface Field<T>

See Also:

DSL.bitAnd(Field, Field)

bitAnd
```
public final Field<T> bitAnd(Field<T> value)
```
Description copied from interface: Field

The bitwise and operator.

Specified by:

bitAnd in interface Field<T>

See Also:

DSL.bitAnd(Field, Field)

bitNand
```
public final Field<T> bitNand(T value)
```
Description copied from interface: Field

The bitwise not and operator.

Specified by:

bitNand in interface Field<T>

See Also:

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

bitNand
```
public final Field<T> bitNand(Field<T> value)
```
Description copied from interface: Field

The bitwise not and operator.

Specified by:

bitNand in interface Field<T>

See Also:

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

bitOr
```
public final Field<T> bitOr(T value)
```
Description copied from interface: Field

The bitwise or operator.

Specified by:

bitOr in interface Field<T>

See Also:

DSL.bitOr(Field, Field)

bitOr
```
public final Field<T> bitOr(Field<T> value)
```
Description copied from interface: Field

The bitwise or operator.

Specified by:

bitOr in interface Field<T>

See Also:

DSL.bitOr(Field, Field)

bitNor
```
public final Field<T> bitNor(T value)
```
Description copied from interface: Field

The bitwise not or operator.

Specified by:

bitNor in interface Field<T>

See Also:

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

bitNor
```
public final Field<T> bitNor(Field<T> value)
```
Description copied from interface: Field

The bitwise not or operator.

Specified by:

bitNor in interface Field<T>

See Also:

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

bitXor
```
public final Field<T> bitXor(T value)
```
Description copied from interface: Field

The bitwise xor operator.

Specified by:

bitXor in interface Field<T>

See Also:

DSL.bitXor(Field, Field)

bitXor
```
public final Field<T> bitXor(Field<T> value)
```
Description copied from interface: Field

The bitwise xor operator.

Specified by:

bitXor in interface Field<T>

See Also:

DSL.bitXor(Field, Field)

bitXNor
```
public final Field<T> bitXNor(T value)
```
Description copied from interface: Field

The bitwise not xor operator.

Specified by:

bitXNor in interface Field<T>

See Also:

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

bitXNor
```
public final Field<T> bitXNor(Field<T> value)
```
Description copied from interface: Field

The bitwise not xor operator.

Specified by:

bitXNor in interface Field<T>

See Also:

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

shl
```
public final Field<T> shl(T value)
```
Description copied from interface: Field

The bitwise left shift operator.

Specified by:

shl in interface Field<T>

See Also:

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

shl
```
public final Field<T> shl(Field<T> value)
```
Description copied from interface: Field

The bitwise left shift operator.

Specified by:

shl in interface Field<T>

See Also:

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

shr
```
public final Field<T> shr(T value)
```
Description copied from interface: Field

The bitwise right shift operator.

Specified by:

shr in interface Field<T>

See Also:

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

shr
```
public final Field<T> shr(Field<T> value)
```
Description copied from interface: Field

The bitwise right shift operator.

Specified by:

shr in interface Field<T>

See Also:

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

isNull
```
public final Condition isNull()
```
Description copied from interface: Field

Create a condition to check this field against null.
SQL: this is null

Specified by:

isNull in interface Field<T>

isNotNull
```
public final Condition isNotNull()
```
Description copied from interface: Field

Create a condition to check this field against null.
SQL: this is not null

Specified by:

isNotNull in interface Field<T>

isDistinctFrom

public final Condition isDistinctFrom(T value)

Description copied from interface: Field

Create a condition to check if this field is DISTINCT from another value.

In SQLDialect.MYSQL and SQLDialect.MARIADB, this can be emulated through

not([this] <=> [value])

In SQLDialect.SQLITE, this can be emulated through

[this] IS NOT [value]

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

 CASE WHEN [this] IS     NULL AND [value] IS     NULL THEN FALSE
      WHEN [this] IS     NULL AND [value] IS NOT NULL THEN TRUE
      WHEN [this] IS NOT NULL AND [value] IS     NULL THEN TRUE
      WHEN [this] =               [value]             THEN FALSE
      ELSE                                                 TRUE
 END

SQL: this is distinct from value

Specified by:: isDistinctFrom in interface Field<T>

isDistinctFrom

public final Condition isDistinctFrom(Field<T> field)

Description copied from interface: Field

Create a condition to check if this field is DISTINCT from another field.

In SQLDialect.MYSQL and SQLDialect.MARIADB, this can be emulated through

not([this] <=> [value])

In SQLDialect.SQLITE, this can be emulated through

[this] IS NOT [value]

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

 CASE WHEN [this] IS     NULL AND [field] IS     NULL THEN FALSE
      WHEN [this] IS     NULL AND [field] IS NOT NULL THEN TRUE
      WHEN [this] IS NOT NULL AND [field] IS     NULL THEN TRUE
      WHEN [this] =               [field]             THEN FALSE
      ELSE                                                 TRUE
 END

SQL: this is distinct from field

Specified by:: isDistinctFrom in interface Field<T>

isNotDistinctFrom

public final Condition isNotDistinctFrom(T value)

Description copied from interface: Field

Create a condition to check if this field is NOT DISTINCT from another value.

In SQLDialect.MYSQL and SQLDialect.MARIADB, this can be emulated through

[this] <=> [value]

In SQLDialect.SQLITE, this can be emulated through

[this] IS [value]

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

 CASE WHEN [this] IS     NULL AND [value] IS     NULL THEN TRUE
      WHEN [this] IS     NULL AND [value] IS NOT NULL THEN FALSE
      WHEN [this] IS NOT NULL AND [value] IS     NULL THEN FALSE
      WHEN [this] =               [value]             THEN TRUE
      ELSE                                                 FALSE
 END

SQL: this is not distinct from value

Specified by:: isNotDistinctFrom in interface Field<T>

isNotDistinctFrom

public final Condition isNotDistinctFrom(Field<T> field)

Description copied from interface: Field

Create a condition to check if this field is NOT DISTINCT from another field.

In SQLDialect.MYSQL and SQLDialect.MARIADB, this can be emulated through

[this] <=> [value]

In SQLDialect.SQLITE, this can be emulated through

[this] IS [value]

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> field)
```
Description copied from interface: Field

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

Specified by:

like in interface Field<T>

like
```
public final Condition like(Field<String> field,
                            char escape)
```
Description copied from interface: Field

Create a condition to pattern-check this field against a value.
SQL: this like value escape 'e'

Specified by:

like in interface Field<T>

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> field)
```
Description copied from interface: Field

Create a condition to case-insensitively pattern-check this field against a field.
This translates to this ilike field in SQLDialect.POSTGRES, or to lower(this) like lower(field) in all other dialects.

Specified by:

likeIgnoreCase in interface Field<T>

likeIgnoreCase
```
public final Condition likeIgnoreCase(Field<String> field,
                                      char escape)
```
Description copied from interface: Field

Create a condition to case-insensitively pattern-check this field against a field.
This translates to this ilike field in SQLDialect.POSTGRES, or to lower(this) like lower(field) in all other dialects.

Specified by:

likeIgnoreCase in interface Field<T>

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> field)
```
Description copied from interface: Field

Create a condition to pattern-check this field against a field.
SQL: this not like field

Specified by:

notLike in interface Field<T>

notLike
```
public final Condition notLike(Field<String> field,
                               char escape)
```
Description copied from interface: Field

Create a condition to pattern-check this field against a field.
SQL: this not like field escape 'e'

Specified by:

notLike in interface Field<T>

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> field)
```
Description copied from interface: Field

Create a condition to case-insensitively pattern-check this field against a field.
This translates to this not ilike field in SQLDialect.POSTGRES, or to lower(this) not like lower(field) in all other dialects.

Specified by:

notLikeIgnoreCase in interface Field<T>

notLikeIgnoreCase
```
public final Condition notLikeIgnoreCase(Field<String> field,
                                         char escape)
```
Description copied from interface: Field

Create a condition to case-insensitively pattern-check this field against a field.
This translates to this not ilike field in SQLDialect.POSTGRES, or to lower(this) not like lower(field) in all other dialects.

Specified by:

notLikeIgnoreCase in interface Field<T>

notLikeRegex
```
public final Condition notLikeRegex(String pattern)
```
Description copied from interface: Field

Create a condition to regex-pattern-check this field against a pattern.
See Field.likeRegex(String) for more details

Specified by:

notLikeRegex in interface Field<T>

See Also:

Field.likeRegex(String)

notLikeRegex
```
public final Condition notLikeRegex(Field<String> pattern)
```
Description copied from interface: Field

Create a condition to regex-pattern-check this field against a pattern.
See Field.likeRegex(String) for more details

Specified by:

notLikeRegex in interface Field<T>

See Also:

Field.likeRegex(Field)

contains
```
public final Condition contains(T value)
```
Description copied from interface: Field
Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
SQL: this like ('%' || escape(value, '\') || '%') escape '\'
Note: This also works with numbers, for instance val(1133).contains(13)
If you're using SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator. For example:
```
 // Use this expression
 val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 })

 // ... to render this SQL
 ARRAY[1, 2, 3] @> ARRAY[1, 2]
 
```
Note, this does not correspond to the Oracle Text CONTAINS() function. Refer to OracleDSL.contains(Field, String) instead.
Specified by:

contains in interface Field<T>

See Also:

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

contains
```
public final Condition contains(Field<T> value)
```
Description copied from interface: Field
Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
SQL: this like ('%' || escape(value, '\') || '%') escape '\'
Note: This also works with numbers, for instance val(1133).contains(13)
If you're using SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator. For example:
```
 // Use this expression
 val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 })

 // ... to render this SQL
 ARRAY[1, 2, 3] @> ARRAY[1, 2]
 
```
Note, this does not correspond to the Oracle Text CONTAINS() function. Refer to OracleDSL.contains(Field, String) instead.
Specified by:

contains in interface Field<T>

See Also:

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

startsWith
```
public final Condition startsWith(T value)
```
Description copied from interface: Field

Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
SQL: this like (escape(value, '\') || '%') escape '\'
Note: This also works with numbers, for instance val(1133).startsWith(11)

Specified by:

startsWith in interface Field<T>

See Also:

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

startsWith
```
public final Condition startsWith(Field<T> value)
```
Description copied from interface: Field

Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
SQL: this like (escape(value, '\') || '%') escape '\'
Note: This also works with numbers, for instance val(1133).startsWith(11)

Specified by:

startsWith in interface Field<T>

See Also:

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

endsWith
```
public final Condition endsWith(T value)
```
Description copied from interface: Field

Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
SQL: this like ('%' || escape(value, '\')) escape '\'
Note: This also works with numbers, for instance val(1133).endsWith(33)

Specified by:

endsWith in interface Field<T>

See Also:

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

endsWith
```
public final Condition endsWith(Field<T> value)
```
Description copied from interface: Field

Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.
SQL: this like ('%' || escape(value, '\')) escape '\'
Note: This also works with numbers, for instance val(1133).endsWith(33)

Specified by:

endsWith in interface Field<T>

See Also:

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

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<? extends Record1<T>> query)
```
Description copied from interface: Field

Create a condition to check this field against a subquery.
Note that the subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.
SQL: this in (select...)

Specified by:

in in interface Field<T>

notIn
```
public final Condition notIn(T... values)
```
Description copied from interface: Field

Create a condition to check this field against several values.
Note that if any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well. This is standard SQL behaviour.
SQL: this not in (values...)

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<? extends Record1<T>> query)
```
Description copied from interface: Field

Create a condition to check this field against a subquery.
Note that the subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.
Note that if any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well. This is standard SQL behaviour.
SQL: this not in (select...)

Specified by:

notIn in interface Field<T>

between
```
public final Condition between(T minValue,
                               T maxValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
This is the same as calling between(minValue).and(maxValue)
SQL: this between minValue and maxValue

Specified by:

between in interface Field<T>

between
```
public final Condition between(Field<T> minValue,
                               Field<T> maxValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
This is the same as calling between(minValue).and(maxValue)
SQL: this between minValue and maxValue

Specified by:

between in interface Field<T>

betweenSymmetric
```
public final Condition betweenSymmetric(T minValue,
                                        T maxValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
This is the same as calling betweenSymmetric(minValue).and(maxValue)
SQL: this between symmetric minValue and maxValue

Specified by:

betweenSymmetric in interface Field<T>

betweenSymmetric
```
public final Condition betweenSymmetric(Field<T> minValue,
                                        Field<T> maxValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
This is the same as calling betweenSymmetric(minValue).and(maxValue)
SQL: this between symmetric minValue and maxValue

Specified by:

betweenSymmetric in interface Field<T>

notBetween
```
public final Condition notBetween(T minValue,
                                  T maxValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
This is the same as calling notBetween(minValue).and(maxValue)
SQL: this not between minValue and maxValue

Specified by:

notBetween in interface Field<T>

notBetween
```
public final Condition notBetween(Field<T> minValue,
                                  Field<T> maxValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
This is the same as calling notBetween(minValue).and(maxValue)
SQL: this not between minValue and maxValue

Specified by:

notBetween in interface Field<T>

notBetweenSymmetric
```
public final Condition notBetweenSymmetric(T minValue,
                                           T maxValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
This is the same as calling notBetweenSymmetric(minValue).and(maxValue)
SQL: this not between symmetric minValue and maxValue

Specified by:

notBetweenSymmetric in interface Field<T>

notBetweenSymmetric
```
public final Condition notBetweenSymmetric(Field<T> minValue,
                                           Field<T> maxValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
This is the same as calling notBetweenSymmetric(minValue).and(maxValue)
SQL: this not between symmetric minValue and maxValue

Specified by:

notBetweenSymmetric in interface Field<T>

between
```
public final BetweenAndStep<T> between(T minValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
SQL: this between minValue and maxValue

Specified by:

between in interface Field<T>

between
```
public final BetweenAndStep<T> between(Field<T> minValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
SQL: this between minValue and maxValue

Specified by:

between in interface Field<T>

betweenSymmetric
```
public final BetweenAndStep<T> betweenSymmetric(T minValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
SQL: this between symmetric minValue and maxValue

Specified by:

betweenSymmetric in interface Field<T>

betweenSymmetric
```
public final BetweenAndStep<T> betweenSymmetric(Field<T> minValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
SQL: this between symmetric minValue and maxValue

Specified by:

betweenSymmetric in interface Field<T>

notBetween
```
public final BetweenAndStep<T> notBetween(T minValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
SQL: this not between minValue and maxValue

Specified by:

notBetween in interface Field<T>

notBetween
```
public final BetweenAndStep<T> notBetween(Field<T> minValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
SQL: this not between minValue and maxValue

Specified by:

notBetween in interface Field<T>

notBetweenSymmetric
```
public final BetweenAndStep<T> notBetweenSymmetric(T minValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
SQL: this not between symmetric minValue and maxValue

Specified by:

notBetweenSymmetric in interface Field<T>

notBetweenSymmetric
```
public final BetweenAndStep<T> notBetweenSymmetric(Field<T> minValue)
```
Description copied from interface: Field

Create a condition to check this field against some bounds.
SQL: this not between symmetric minValue and maxValue

Specified by:

notBetweenSymmetric in interface Field<T>

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

this = value.

Specified by:

eq in interface Field<T>

See Also:

Field.equal(Object)

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

this = field.

Specified by:

eq in interface Field<T>

See Also:

Field.equal(Field)

eq
```
public final Condition eq(Select<? extends Record1<T>> query)
```
Description copied from interface: Field

this = (Select ...).

Specified by:

eq in interface Field<T>

See Also:

Field.equal(Select)

eq
```
public final Condition eq(QuantifiedSelect<? extends Record1<T>> query)
```
Description copied from interface: Field

this = [quantifier] (Select ...).

Specified by:

eq in interface Field<T>

See Also:

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

ne
```
public final Condition ne(T value)
```
Description copied from interface: Field

this != value.

Specified by:

ne in interface Field<T>

See Also:

Field.notEqual(Object)

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

this != field.

Specified by:

ne in interface Field<T>

See Also:

Field.notEqual(Field)

ne
```
public final Condition ne(Select<? extends Record1<T>> query)
```
Description copied from interface: Field

this != (Select ...).

Specified by:

ne in interface Field<T>

See Also:

Field.notEqual(Select)

ne
```
public final Condition ne(QuantifiedSelect<? extends Record1<T>> query)
```
Description copied from interface: Field

this != [quantifier] (Select ...).

Specified by:

ne in interface Field<T>

See Also:

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

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

this < value.

Specified by:

lt in interface Field<T>

See Also:

Field.lessThan(Object)

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

this < field.

Specified by:

lt in interface Field<T>

See Also:

Field.lessThan(Field)

lt
```
public final Condition lt(Select<? extends Record1<T>> query)
```
Description copied from interface: Field

this < (Select ...).

Specified by:

lt in interface Field<T>

See Also:

Field.lessThan(Select)

lt
```
public final Condition lt(QuantifiedSelect<? extends Record1<T>> query)
```
Description copied from interface: Field

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

Specified by:

lt in interface Field<T>

See Also:

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

le
```
public final Condition le(T value)
```
Description copied from interface: Field

this <= value.

Specified by:

le in interface Field<T>

See Also:

Field.lessOrEqual(Object)

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

this <= field.

Specified by:

le in interface Field<T>

See Also:

Field.lessOrEqual(Field)

le
```
public final Condition le(Select<? extends Record1<T>> query)
```
Description copied from interface: Field

this <= (Select ...).

Specified by:

le in interface Field<T>

See Also:

Field.lessOrEqual(Select)

le
```
public final Condition le(QuantifiedSelect<? extends Record1<T>> query)
```
Description copied from interface: Field

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

Specified by:

le in interface Field<T>

See Also:

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

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

this > value.

Specified by:

gt in interface Field<T>

See Also:

Field.greaterThan(Object)

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

this > field.

Specified by:

gt in interface Field<T>

See Also:

Field.greaterThan(Field)

gt
```
public final Condition gt(Select<? extends Record1<T>> query)
```
Description copied from interface: Field

this > (Select ...).

Specified by:

gt in interface Field<T>

See Also:

Field.greaterThan(Select)

gt
```
public final Condition gt(QuantifiedSelect<? extends Record1<T>> query)
```
Description copied from interface: Field

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

Specified by:

gt in interface Field<T>

See Also:

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

ge
```
public final Condition ge(T value)
```
Description copied from interface: Field

this >= value.

Specified by:

ge in interface Field<T>

See Also:

Field.greaterOrEqual(Object)

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

this >= field.

Specified by:

ge in interface Field<T>

See Also:

Field.greaterOrEqual(Field)

ge
```
public final Condition ge(Select<? extends Record1<T>> query)
```
Description copied from interface: Field

this >= (Select ...).

Specified by:

ge in interface Field<T>

See Also:

Field.greaterOrEqual(Select)

ge
```
public final Condition ge(QuantifiedSelect<? extends Record1<T>> query)
```
Description copied from interface: Field

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

Specified by:

ge in interface Field<T>

See Also:

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

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

this = value.

Specified by:

equal in interface Field<T>

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

this = field.

Specified by:

equal in interface Field<T>

equalIgnoreCase
```
public final Condition equalIgnoreCase(String value)
```
Description copied from interface: Field

lower(this) = lower(value).

Specified by:

equalIgnoreCase in interface Field<T>

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

lower(this) = lower(value).

Specified by:

equalIgnoreCase in interface Field<T>

equal
```
public final Condition equal(Select<? extends Record1<T>> query)
```
Description copied from interface: Field

this = (Select ...).

Specified by:

equal in interface Field<T>

equal
```
public final Condition equal(QuantifiedSelect<? extends Record1<T>> query)
```
Description copied from interface: Field

this = [quantifier] (Select ...).

Specified by:

equal in interface Field<T>

See Also:

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

notEqual
```
public final Condition notEqual(T value)
```
Description copied from interface: Field

this != value.

Specified by:

notEqual in interface Field<T>

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

this != field.

Specified by:

notEqual in interface Field<T>

notEqualIgnoreCase
```
public final Condition notEqualIgnoreCase(String value)
```
Description copied from interface: Field

lower(this) != lower(value).

Specified by:

notEqualIgnoreCase in interface Field<T>

notEqualIgnoreCase
```
public final Condition notEqualIgnoreCase(Field<String> value)
```
Description copied from interface: Field

lower(this) != lower(value).

Specified by:

notEqualIgnoreCase in interface Field<T>

notEqual
```
public final Condition notEqual(Select<? extends Record1<T>> query)
```
Description copied from interface: Field

this != (Select ...).

Specified by:

notEqual in interface Field<T>

notEqual
```
public final Condition notEqual(QuantifiedSelect<? extends Record1<T>> query)
```
Description copied from interface: Field

this != [quantifier] (Select ...).

Specified by:

notEqual in interface Field<T>

See Also:

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

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

this < value.

Specified by:

lessThan in interface Field<T>

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

this < field.

Specified by:

lessThan in interface Field<T>

lessThan
```
public final Condition lessThan(Select<? extends Record1<T>> query)
```
Description copied from interface: Field

this < (Select ...).

Specified by:

lessThan in interface Field<T>

lessThan
```
public final Condition lessThan(QuantifiedSelect<? extends Record1<T>> query)
```
Description copied from interface: Field

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

Specified by:

lessThan in interface Field<T>

See Also:

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

lessOrEqual
```
public final Condition lessOrEqual(T value)
```
Description copied from interface: Field

this <= value.

Specified by:

lessOrEqual in interface Field<T>

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

this <= field.

Specified by:

lessOrEqual in interface Field<T>

lessOrEqual
```
public final Condition lessOrEqual(Select<? extends Record1<T>> query)
```
Description copied from interface: Field

this <= (Select ...).

Specified by:

lessOrEqual in interface Field<T>

lessOrEqual
```
public final Condition lessOrEqual(QuantifiedSelect<? extends Record1<T>> query)
```
Description copied from interface: Field

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

Specified by:

lessOrEqual in interface Field<T>

See Also:

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

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

this > value.

Specified by:

greaterThan in interface Field<T>

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

this > field.

Specified by:

greaterThan in interface Field<T>

greaterThan
```
public final Condition greaterThan(Select<? extends Record1<T>> query)
```
Description copied from interface: Field

this > (Select ...).

Specified by:

greaterThan in interface Field<T>

greaterThan
```
public final Condition greaterThan(QuantifiedSelect<? extends Record1<T>> query)
```
Description copied from interface: Field

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

Specified by:

greaterThan in interface Field<T>

See Also:

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

greaterOrEqual
```
public final Condition greaterOrEqual(T value)
```
Description copied from interface: Field

this >= value.

Specified by:

greaterOrEqual in interface Field<T>

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

this >= field.

Specified by:

greaterOrEqual in interface Field<T>

greaterOrEqual
```
public final Condition greaterOrEqual(Select<? extends Record1<T>> query)
```
Description copied from interface: Field

this >= (Select ...).

Specified by:

greaterOrEqual in interface Field<T>

greaterOrEqual
```
public final Condition greaterOrEqual(QuantifiedSelect<? extends Record1<T>> query)
```
Description copied from interface: Field

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

Specified by:

greaterOrEqual in interface Field<T>

See Also:

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

compare
```
public final Condition compare(Comparator comparator,
                               T value)
```
Description copied from interface: Field

Compare this field with a value using a dynamic comparator.

Specified by:

compare in interface Field<T>

Parameters:

comparator - The comparator to use for comparing this field with a value

value - The value to compare this field with

Returns:

A comparison predicate

compare
```
public final Condition compare(Comparator comparator,
                               Field<T> field)
```
Description copied from interface: Field

Compare this field with another field using a dynamic comparator.

Specified by:

compare in interface Field<T>

Parameters:

comparator - The comparator to use for comparing this field with another field

field - The field to compare this field with

Returns:

A comparison predicate

compare
```
public final Condition compare(Comparator comparator,
                               Select<? extends Record1<T>> query)
```
Description copied from interface: Field

Compare this field with a subselect using a dynamic comparator.
Consider Comparator.supportsSubselect() to assess whether a comparator can be used with this method.

Specified by:

compare in interface Field<T>

Parameters:

comparator - The comparator to use for comparing this field with a subselect

query - The subselect to compare this field with

Returns:

A comparison predicate

compare
```
public final Condition compare(Comparator comparator,
                               QuantifiedSelect<? extends Record1<T>> query)
```
Description copied from interface: Field

Compare this field with a quantified subselect using a dynamic comparator.
Consider Comparator.supportsQuantifier() to assess whether a comparator can be used with this method.

Specified by:

compare in interface Field<T>

Parameters:

comparator - The comparator to use for comparing this field with a quantified subselect

query - The quantified subselect to compare this field with

Returns:

A comparison predicate

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 DSLContext

Specified by:

sign in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

abs in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

round in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

round in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

floor in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

ceil in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

sqrt in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

exp in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

ln in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

log in interface Field<T>

See Also:

DSL.log(Field, int)

pow
```
public final Field<BigDecimal> pow(Number exponent)
```
Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

pow in interface Field<T>

See Also:

DSL.power(Field, Number)

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

Description copied from interface: Field

An alias for Field.power(Number).

Specified by:

power in interface Field<T>

See Also:

Field.power(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 DSLContext

Specified by:

acos in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

asin in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

atan in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

atan2 in interface Field<T>

See Also:

DSL.atan2(Field, Number)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

atan2 in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

cos in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

sin in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

tan in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

cot in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

sinh in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

cosh in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

tanh in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

coth in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

deg in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

rad in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

count in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

countDistinct in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

max in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

min in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

sum in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

avg in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

median in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

stddevPop in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

stddevSamp in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

varPop in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

varSamp in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

countOver in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

maxOver in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

minOver in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

sumOver in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

avgOver in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

firstValue in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

lastValue in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

lead in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

lead in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

lead in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

lead in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

lag in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

lag in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

lag in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

lag in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

stddevPopOver in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

stddevSampOver in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

varPopOver in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

varSampOver in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

upper in interface Field<T>

See Also:

DSL.upper(Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

lower in interface Field<T>

See Also:

DSL.lower(Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

trim in interface Field<T>

See Also:

DSL.trim(Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

rtrim in interface Field<T>

See Also:

DSL.rtrim(Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

ltrim in interface Field<T>

See Also:

DSL.ltrim(Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

rpad in interface Field<T>

See Also:

DSL.rpad(Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

rpad in interface Field<T>

See Also:

DSL.rpad(Field, int)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

rpad in interface Field<T>

See Also:

DSL.rpad(Field, Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

rpad in interface Field<T>

See Also:

DSL.rpad(Field, int, char)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

lpad in interface Field<T>

See Also:

DSL.lpad(Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

lpad in interface Field<T>

See Also:

DSL.lpad(Field, int)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

lpad in interface Field<T>

See Also:

DSL.lpad(Field, Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

lpad in interface Field<T>

See Also:

DSL.lpad(Field, int, char)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

repeat in interface Field<T>

See Also:

DSL.repeat(Field, int)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

repeat in interface Field<T>

See Also:

DSL.repeat(Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

replace in interface Field<T>

See Also:

DSL.replace(Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

replace in interface Field<T>

See Also:

DSL.replace(Field, String)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

replace in interface Field<T>

See Also:

DSL.replace(Field, Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

replace in interface Field<T>

See Also:

DSL.replace(Field, String, String)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

position in interface Field<T>

See Also:

DSL.position(Field, String)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

position in interface Field<T>

See Also:

DSL.position(Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

ascii in interface Field<T>

See Also:

DSL.ascii(Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

concat in interface Field<T>

See Also:

DSL.concat(Field...)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

concat in interface Field<T>

See Also:

DSL.concat(String...)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

substring in interface Field<T>

See Also:

DSL.substring(Field, int)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

substring in interface Field<T>

See Also:

DSL.substring(Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

substring in interface Field<T>

See Also:

DSL.substring(Field, int, int)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

substring in interface Field<T>

See Also:

DSL.substring(Field, Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

length in interface Field<T>

See Also:

DSL.length(Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

charLength in interface Field<T>

See Also:

DSL.charLength(Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

bitLength in interface Field<T>

See Also:

DSL.bitLength(Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

octetLength in interface Field<T>

See Also:

DSL.octetLength(Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

extract in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

greatest in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

greatest in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

least in interface Field<T>

See Also:

DSL.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 DSLContext

Specified by:

least in interface Field<T>

See Also:

DSL.least(Field, Field...)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

nvl in interface Field<T>

See Also:

DSL.nvl(Field, Object)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

nvl in interface Field<T>

See Also:

DSL.nvl(Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

nvl2 in interface Field<T>

See Also:

DSL.nvl2(Field, Object, Object)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

nvl2 in interface Field<T>

See Also:

DSL.nvl2(Field, Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

nullif in interface Field<T>

See Also:

DSL.nullif(Field, Object)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

nullif in interface Field<T>

See Also:

DSL.nullif(Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

decode in interface Field<T>

See Also:

DSL.decode(Object, Object, Object)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

decode in interface Field<T>

See Also:

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

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

decode in interface Field<T>

See Also:

DSL.decode(Field, Field, Field)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

decode in interface Field<T>

See Also:

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

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

coalesce in interface Field<T>

See Also:

DSL.coalesce(Object, Object...)

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

Description copied from interface: Field

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext

Specified by:

coalesce in interface Field<T>

See Also:

DSL.coalesce(Field, Field...)

equals
```
public boolean equals(Object that)
```
Description copied from interface: QueryPart

Check whether this QueryPart can be considered equal to another QueryPart.
In general, QueryPart equality is defined in terms of QueryPart.toString() equality. In other words, two query parts are considered equal if their rendered SQL (with inlined bind variables) is equal. This means that the two query parts do not necessarily have to be of the same type.
Some QueryPart implementations may choose to override this behaviour for improved performance, as QueryPart.toString() is an expensive operation, if called many times.

Specified by:

equals in interface Field<T>

Specified by:

equals in interface QueryPart

Parameters:

that - The other QueryPart

Returns:

Whether the two query parts are equal

hashCode
```
public int hashCode()
```
Description copied from interface: QueryPart

Generate a hash code from this QueryPart.
In general, QueryPart hash codes are the same as the hash codes generated from QueryPart.toString(). This guarantees consistent behaviour with QueryPart.equals(Object)
Some QueryPart implementations may choose to override this behaviour for improved performance, as QueryPart.toString() is an expensive operation, if called many times.

Specified by:

hashCode in interface QueryPart

Returns:

The QueryPart hash code

declaresFields
```
public boolean declaresFields()
```
Subclasses may override this

Specified by:

declaresFields in interface QueryPartInternal

declaresTables
```
public boolean declaresTables()
```
Subclasses may override this

Specified by:

declaresTables in interface QueryPartInternal

declaresWindows
```
public boolean declaresWindows()
```
Subclasses may override this

Specified by:

declaresWindows in interface QueryPartInternal

toString
```
public String toString()
```
Description copied from interface: QueryPart

Render a SQL string of this QueryPart
For improved debugging, this renders a SQL string of this QueryPart with inlined bind variables. If you wish to gain more control over the concrete SQL rendering of this QueryPart, use DSLContext.renderContext() to obtain a configurable render context for SQL rendering.

Specified by:

toString in interface QueryPart

Overrides:

toString in class Object

Returns:

A SQL string representation of this QueryPart

create
```
protected final DSLContext create()
```
Internal convenience method

create

protected final DSLContext create(Configuration configuration)

Internal convenience method

create

protected final DSLContext create(RenderContext ctx)

Internal convenience method

create

protected final DSLContext create(BindContext ctx)

Internal convenience method

translate

protected final DataAccessException translate(String sql,
                                              SQLException e)

Internal convenience method

Class NullIf<T>

Method Summary

Methods inherited from class java.lang.Object

Methods inherited from interface org.jooq.QueryPart

Method Detail

toSQL

bind

clauses

as

getName

getComment

getConverter

getDataType

getDataType

getType

cast

cast

cast

coerce

Bind values

Other Field types

coerce

Bind values

Other Field types

coerce

Bind values

Other Field types

asc

desc

sort

sortAsc

sortAsc

sortDesc

sortDesc

sort

neg

add

add

sub

sub

mul

mul

div

div

mod

mod

plus

plus

subtract

subtract

minus

minus

multiply

multiply

divide

divide

modulo

modulo

bitNot

bitAnd

bitAnd

bitNand

bitNand

bitOr

bitOr

bitNor

bitNor

bitXor

bitXor

bitXNor

bitXNor

shl

shl

shr

shr

isNull

isNotNull

isDistinctFrom

isDistinctFrom

isNotDistinctFrom