- All Implemented Interfaces:
Serializable
,Field<T>
,FieldOrConstraint
,FieldOrRow
,GroupField
,Named
,OrderField<T>
,QueryPart
,QueryPartInternal
,SelectField<T>
,SelectFieldOrAsterisk
,Typed<T>
Field
implementations in client code.
Client code may provide proper Condition
implementations extending
this useful base class. All necessary parts of the Condition
interface are already implemented. Only this method needs further
implementation: accept(Context)
.
Refer to that methods' Javadoc for further details about their expected behaviour.
- Author:
- Lukas Eder
- See Also:
- Serialized Form
-
Constructor Summary
ModifierConstructorDescriptionprotected
CustomField(String name, DataType<T> type)
protected
CustomField(Name name, DataType<T> type)
-
Method Summary
Modifier and TypeMethodDescriptionabs()
Deprecated.abstract void
Subclasses must implement this method.acos()
Deprecated.An arithmetic expression adding this to value.An arithmetic expression to add value to this.Create an alias for this field.Create an alias for this field.Create an alias for this field based on another field's name.Create an alias for this field.asc()
Create an ascending sort field from this field.ascii()
Deprecated.asin()
Deprecated.atan()
Deprecated.Deprecated.Deprecated.avg()
Deprecated.avgOver()
Deprecated.Create a condition to check this field against some bounds.Create a condition to check this field against some bounds.Create a condition to check this field against some bounds.Create a condition to check this field against some bounds.betweenSymmetric(Field<T> minValue)
Create a condition to check this field against some bounds.betweenSymmetric(Field<T> minValue, Field<T> maxValue)
Create a condition to check this field against some bounds.betweenSymmetric(T minValue)
Create a condition to check this field against some bounds.betweenSymmetric(T minValue, T maxValue)
Create a condition to check this field against some bounds.The bitwise and operator.The bitwise and operator.Deprecated.The bitwise not and operator.The bitwise not and operator.The bitwise not or operator.The bitwise not or operator.bitNot()
The bitwise not operator.The bitwise or operator.The bitwise or operator.The bitwise not xor operator.The bitwise not xor operator.The bitwise xor operator.The bitwise xor operator.<Z> Field<Z>
Cast this field to another type.<Z> Field<Z>
Cast this field to a dialect-specific data type.<Z> Field<Z>
Cast this field to the type of another field.ceil()
Deprecated.boolean
The inverse operation ofRecord.changed(Field)
.Deprecated.Clause[]
TheClause
s that are represented by this query part.Deprecated.Deprecated.<Z> Field<Z>
Coerce this field to another type.<Z> Field<Z>
Coerce this field to a dialect-specific data type.<Z> Field<Z>
Coerce this field to the type of another field.Apply a collation operator to this column expression.Apply a collation operator to this column expression.Apply a collation operator to this column expression.compare(Comparator comparator, Field<T> field)
Compare this field with another field using a dynamic comparator.compare(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query)
Compare this field with a quantified subselect using a dynamic comparator.compare(Comparator comparator, Select<? extends Record1<T>> query)
Compare this field with a subselect using a dynamic comparator.compare(Comparator comparator, T value)
Compare this field with a value using a dynamic comparator.concat(char... values)
This method is part of the pre-2.0 API.Deprecated.Deprecated.Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.containsIgnoreCase(Field<T> value)
Convenience method forField.likeIgnoreCase(String, char)
including proper adding of wildcards and escaping.containsIgnoreCase(T value)
Convenience method forField.likeIgnoreCase(String, char)
including proper adding of wildcards and escaping.<U> Field<U>
convert(Class<U> toType, Function<? super T,? extends U> from, Function<? super U,? extends T> to)
Apply an ad-hoc data typeConverter
to this field expression.<U> Field<U>
Apply an ad-hoc data typeBinding
to this field expression.<U> Field<U>
Apply an ad-hoc data typeConverter
to this field expression.<U> Field<U>
convertFrom(Class<U> toType, Function<? super T,? extends U> from)
Apply an ad-hoc read-only data typeConverter
to this field expression.<U> Field<U>
convertFrom(Function<? super T,? extends U> from)
Apply an ad-hoc read-only data typeConverter
to this field expression.<U> Field<U>
Apply an ad-hoc write-only data typeConverter
to this field expression.<U> Field<U>
Apply an ad-hoc write-only data typeConverter
to this field expression.cos()
Deprecated.cosh()
Deprecated.cot()
Deprecated.coth()
Deprecated.count()
Deprecated.Deprecated.Deprecated.protected DSLContext
create()
Deprecated.protected DSLContext
create(Configuration configuration)
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.protected DSLContext
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.boolean
Subclasses may override thisboolean
Subclasses may override thisboolean
Subclasses may override thisboolean
Subclasses may override thisboolean
Subclasses may override this<Z> Field<Z>
Deprecated.<Z> Field<Z>
Deprecated.<Z> Field<Z>
Deprecated.<Z> Field<Z>
Deprecated.deg()
Deprecated.desc()
Create a descending sort field from this field.An arithmetic expression dividing this by value.An arithmetic expression dividing this by value.An alias forField.div(Number)
.An alias forField.div(Field)
.Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.endsWithIgnoreCase(Field<T> value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.endsWithIgnoreCase(T value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.this = field
.eq(QuantifiedSelect<? extends Record1<T>> query)
this = [quantifier] (Select<?> ...)
.this = (Select<?> ...)
.this = value
.this = field
.equal(QuantifiedSelect<? extends Record1<T>> query)
this = [quantifier] (Select<?> ...)
.this = (Select<?> ...)
.this = value
.equalIgnoreCase(String value)
lower(this) = lower(value)
.equalIgnoreCase(Field<String> value)
lower(this) = lower(value)
.boolean
Check whether thisQueryPart
can be considered equal to anotherQueryPart
.exp()
Deprecated.Deprecated.The inverse operation ofFields.field(Field)
.Deprecated.floor()
Deprecated.The inverse operation ofRecord.into(Field)
.this >= field
.ge(QuantifiedSelect<? extends Record1<T>> query)
this >= [quantifier] (Select<?> ...)
.this >= (Select<?> ...)
.this >= value
.boolean
Subclasses may override thisThe inverse operation ofRecord.get(Field)
.The object's underlyingBinding
.The comment on this object.The comment on this object as aQueryPart
.The object's underlyingConverter
.The type of this object (might not be dialect-specific).getDataType(Configuration configuration)
The dialect-specific type of this object.getName()
The unqualified name of this object.The qualified name of this object.getType()
The Java type of the object.The unqualified name of this object.The inverse operation ofRecord.getValue(Field)
.greaterOrEqual(Field<T> field)
this >= field
.greaterOrEqual(QuantifiedSelect<? extends Record1<T>> query)
this >= [quantifier] (Select<?> ...)
.greaterOrEqual(Select<? extends Record1<T>> query)
this >= (Select<?> ...)
.greaterOrEqual(T value)
this >= value
.greaterThan(Field<T> field)
this > field
.greaterThan(QuantifiedSelect<? extends Record1<T>> query)
this > [quantifier] (Select<?> ...)
.greaterThan(Select<? extends Record1<T>> query)
this > (Select<?> ...)
.greaterThan(T value)
this > value
.Deprecated.Deprecated.this > field
.gt(QuantifiedSelect<? extends Record1<T>> query)
this > [quantifier] (Select<?> ...)
.this > (Select<?> ...)
.this > value
.int
hashCode()
Generate a hash code from thisQueryPart
.in(Collection<?> values)
Create a condition to check this field against several values.Create a condition to check this field against several values.Create a condition to check this field against several values from a previous query.Create a condition to check this field against a subquery.Create a condition to check this field against several values.isDistinctFrom(Field<T> field)
Create a condition to check if this field isDISTINCT
from another field.isDistinctFrom(Select<? extends Record1<T>> select)
Create a condition to check if this field isDISTINCT
from another field.isDistinctFrom(T value)
Create a condition to check if this field isDISTINCT
from another value.Create a condition to check if this field contains XML data.isFalse()
Create a condition to check this field against known string literals forfalse
.isJson()
Create a condition to check if this field contains JSON data.isNotDistinctFrom(Field<T> field)
Create a condition to check if this field isNOT DISTINCT
from another field.isNotDistinctFrom(Select<? extends Record1<T>> select)
Create a condition to check if this field isNOT DISTINCT
from another field.isNotDistinctFrom(T value)
Create a condition to check if this field isNOT DISTINCT
from another value.Create a condition to check if this field does not contain XML data.Create a condition to check if this field does not contain JSON data.Create a condition to check this field againstnull
.isNull()
Create a condition to check this field againstnull
.isTrue()
Create a condition to check this field against known string literals fortrue
.lag()
Deprecated.lag(int offset)
Deprecated.Deprecated.Deprecated.Deprecated.this <= field
.le(QuantifiedSelect<? extends Record1<T>> query)
this <= [quantifier] (Select<?> ...)
.this <= (Select<?> ...)
.this <= value
.lead()
Deprecated.lead(int offset)
Deprecated.Deprecated.Deprecated.Deprecated.Deprecated.length()
Deprecated.lessOrEqual(Field<T> field)
this <= field
.lessOrEqual(QuantifiedSelect<? extends Record1<T>> query)
this <= [quantifier] (Select<?> ...)
.lessOrEqual(Select<? extends Record1<T>> query)
this <= (Select<?> ...)
.lessOrEqual(T value)
this <= value
.this < field
.lessThan(QuantifiedSelect<? extends Record1<T>> query)
this < [quantifier] (Select<?> ...)
.this < (Select<?> ...)
.this < value
.Create a condition to pattern-check this field against a value.Create a condition to pattern-check this field against a value.Create a condition to pattern-check this field against a value.Create a condition to pattern-check this field against a value.like(QuantifiedSelect<Record1<String>> query)
Create a condition to pattern-check this field against a quantified select.likeIgnoreCase(String value)
Create a condition to case-insensitively pattern-check this field against a value.likeIgnoreCase(String value, char escape)
Create a condition to case-insensitively pattern-check this field against a value.likeIgnoreCase(Field<String> field)
Create a condition to case-insensitively pattern-check this field against a field.likeIgnoreCase(Field<String> field, char escape)
Create a condition to case-insensitively pattern-check this field against a field.Create a condition to regex-pattern-check this field against a pattern.Create a condition to regex-pattern-check this field against a pattern.ln()
Deprecated.log(int base)
Deprecated.lower()
Deprecated.lpad(int length)
Deprecated.lpad(int length, char character)
Deprecated.Deprecated.Deprecated.this < field
.lt(QuantifiedSelect<? extends Record1<T>> query)
this < [quantifier] (Select<?> ...)
.this < (Select<?> ...)
.this < value
.ltrim()
Deprecated.max()
Deprecated.maxOver()
Deprecated.median()
Deprecated.min()
Deprecated.minOver()
Deprecated.An alias forField.sub(Number)
.An alias forField.sub(Field)
.An arithmetic expression getting the modulo of this divided by value.An arithmetic expression getting the modulo of this divided by value.An alias forField.mod(Number)
.An alias forField.mod(Field)
.An arithmetic expression multiplying this with value.An arithmetic expression multiplying this with value.An alias forField.mul(Number)
.An alias forField.mul(Field)
.this != field
.ne(QuantifiedSelect<? extends Record1<T>> query)
this != [quantifier] (Select<?> ...)
.this != (Select<?> ...)
.this != value
.neg()
Negate this field to get its negative value.notBetween(Field<T> minValue)
Create a condition to check this field against some bounds.notBetween(Field<T> minValue, Field<T> maxValue)
Create a condition to check this field against some bounds.notBetween(T minValue)
Create a condition to check this field against some bounds.notBetween(T minValue, T maxValue)
Create a condition to check this field against some bounds.notBetweenSymmetric(Field<T> minValue)
Create a condition to check this field against some bounds.notBetweenSymmetric(Field<T> minValue, Field<T> maxValue)
Create a condition to check this field against some bounds.notBetweenSymmetric(T minValue)
Create a condition to check this field against some bounds.notBetweenSymmetric(T minValue, T maxValue)
Create a condition to check this field against some bounds.notContains(Field<T> value)
Inverse ofField.contains(Field)
.notContains(T value)
Inverse ofField.contains(Object)
.notContainsIgnoreCase(Field<T> value)
Inverse ofField.containsIgnoreCase(Field)
notContainsIgnoreCase(T value)
Inverse ofField.containsIgnoreCase(Object)
this != field
.notEqual(QuantifiedSelect<? extends Record1<T>> query)
this != [quantifier] (Select<?> ...)
.this != (Select<?> ...)
.this != value
.notEqualIgnoreCase(String value)
lower(this) != lower(value)
.notEqualIgnoreCase(Field<String> value)
lower(this) != lower(value)
.notIn(Collection<?> values)
Create a condition to check this field against several values.Create a condition to check this field against several values.Create a condition to check this field against several values from a previous query.Create a condition to check this field against a subquery.Create a condition to check this field against several values.Create a condition to pattern-check this field against a value.Create a condition to pattern-check this field against a value.Create a condition to pattern-check this field against a field.Create a condition to pattern-check this field against a field.notLike(QuantifiedSelect<Record1<String>> query)
Create a condition to pattern-check this field against a quantified select.notLikeIgnoreCase(String value)
Create a condition to case-insensitively pattern-check this field against a value.notLikeIgnoreCase(String value, char escape)
Create a condition to case-insensitively pattern-check this field against a value.notLikeIgnoreCase(Field<String> field)
Create a condition to case-insensitively pattern-check this field against a field.notLikeIgnoreCase(Field<String> field, char escape)
Create a condition to case-insensitively pattern-check this field against a field.notLikeRegex(String pattern)
Create a condition to regex-pattern-check this field against a pattern.notLikeRegex(Field<String> pattern)
Create a condition to regex-pattern-check this field against a pattern.notSimilarTo(String value)
Create a condition to pattern-check this field against a value.notSimilarTo(String value, char escape)
Create a condition to pattern-check this field against a value.notSimilarTo(Field<String> field)
Create a condition to pattern-check this field against a field.notSimilarTo(Field<String> field, char escape)
Create a condition to pattern-check this field against a field.Deprecated.Deprecated.Deprecated.Deprecated.<Z> Field<Z>
Deprecated.<Z> Field<Z>
nvl2(Z valueIfNotNull, Z valueIfNull)
Deprecated.Deprecated.static <T> CustomField<T>
Create aCustomField
from a lambda expression.static <T> CustomField<T>
Create aCustomField
from a lambda expression.The inverse operation ofRecord.original(Field)
.plus()
Turn this field into an Oracle-specific field for use in outer-join predicates.An alias forField.add(Number)
.An alias forField.add(Field)
.Deprecated.Deprecated.An arithmetic expression getting this value raised to the power ofexponent
.An arithmetic expression getting this value raised to the power ofexponent
.An alias forField.power(Number)
.An alias forField.power(Field)
.rad()
Deprecated.An alias forField.mod(Number)
.An alias forField.mod(Field)
.boolean
rendersContent(Context<?> ctx)
Subclasses may override thisDeprecated.Deprecated.Deprecated.Deprecated.Deprecated.Deprecated.void
The inverse operation ofRecord.reset(Field)
.round()
Deprecated.round(int decimals)
Deprecated.rpad(int length)
Deprecated.rpad(int length, char character)
Deprecated.Deprecated.Deprecated.rtrim()
Deprecated.The bitwise left shift operator.The bitwise left shift operator.The bitwise right shift operator.The bitwise right shift operator.sign()
Deprecated.Create a condition to pattern-check this field against a value.Create a condition to pattern-check this field against a value.Create a condition to pattern-check this field against a value.Create a condition to pattern-check this field against a value.sin()
Deprecated.sinh()
Deprecated.<Z> SortField<Z>
Create an indirected sort field.Create an ascending/descending sort field from this field.sortAsc(Collection<T> sortList)
Create an indirected sort field.Create an indirected sort field.Create a default sorted (implicitASC
) from this field.sortDesc(Collection<T> sortList)
Create an indirected sort field.Create an indirected sort field.sqrt()
Deprecated.startsWith(Field<T> value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.startsWith(T value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.startsWithIgnoreCase(Field<T> value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.startsWithIgnoreCase(T value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.Deprecated.Deprecated.Deprecated.Deprecated.An arithmetic expression subtracting value from this.An arithmetic expression subtracting value from this.substring(int startingPosition)
Deprecated.substring(int startingPosition, int length)
Deprecated.Deprecated.Deprecated.An alias forField.sub(Number)
.An alias forField.sub(Field)
.sum()
Deprecated.sumOver()
Deprecated.tan()
Deprecated.tanh()
Deprecated.An alias forField.mul(Number)
.An alias forField.mul(Field)
.toString()
Render a SQL string representation of thisQueryPart
.protected DataAccessException
translate(String sql, SQLException e)
Internal convenience methodtrim()
Deprecated.Negate this field to get its negative value.Get this field as its positive value (no effect on SQL).upper()
Deprecated.varPop()
Deprecated.Deprecated.varSamp()
Deprecated.Deprecated.Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
Methods inherited from interface org.jooq.Field
equals, getComment, getName
Methods inherited from interface org.jooq.Named
getCommentPart, getQualifiedName, getUnqualifiedName
Methods inherited from interface org.jooq.QueryPartInternal
declaresCTE, declaresParameters, declaresWindows, generatesCast, rendersContent
Methods inherited from interface org.jooq.Typed
getBinding, getConverter, getDataType, getDataType, getType
-
Constructor Details
-
CustomField
-
CustomField
-
-
Method Details
-
of
public static final <T> CustomField<T> of(String name, DataType<T> type, Consumer<? super Context<?>> consumer)Create aCustomField
from a lambda expression. -
of
public static final <T> CustomField<T> of(Name name, DataType<T> type, Consumer<? super Context<?>> consumer)Create aCustomField
from a lambda expression. -
accept
Subclasses must implement this method.
ThisQueryPart
canaccept
aContext
object in order to render a SQL string or to bind its variables.- Specified by:
accept
in interfaceQueryPartInternal
-
clauses
Description copied from interface:QueryPartInternal
TheClause
s that are represented by this query part.QueryPart
s can specify severalClause
s for which an event will be emittedbefore
(in forward order) andafter
(in reverse order) visiting the the query part throughContext.visit(QueryPart)
This method is for JOOQ INTERNAL USE only. Do not reference directly
- Specified by:
clauses
in interfaceQueryPartInternal
- Returns:
- The
Clause
s represented by this query part ornull
or an empty array if this query part does not represent a clause.
-
as
Description copied from interface:SelectField
Create an alias for this field.Note that the case-sensitivity of the returned field depends on
Settings.getRenderQuotedNames()
and theName
. By default, field aliases are quoted, and thus case-sensitive in many SQL dialects - useDSL.unquotedName(String...)
for case-insensitive aliases.If the argument
Name.getName()
is qualified, then theName.last()
part will be used.- Specified by:
as
in interfaceSelectField<T>
- Parameters:
alias
- The alias name- Returns:
- The field alias
-
declaresFields
public final boolean declaresFields()Subclasses may override this- Specified by:
declaresFields
in interfaceQueryPartInternal
-
declaresTables
public final boolean declaresTables()Subclasses may override this- Specified by:
declaresTables
in interfaceQueryPartInternal
-
field
Description copied from interface:Field
The inverse operation ofFields.field(Field)
.This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream.
-
get
Description copied from interface:Field
The inverse operation ofRecord.get(Field)
.This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream:
DSL.using(configuration) .fetch("select * from t") .stream() .map(MY_TABLE.ID::get) .forEach(System.out::println);
-
getValue
Description copied from interface:Field
The inverse operation ofRecord.getValue(Field)
.This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream:
DSL.using(configuration) .fetch("select * from t") .stream() .map(MY_TABLE.ID::getValue) .forEach(System.out::println);
-
original
Description copied from interface:Field
The inverse operation ofRecord.original(Field)
.This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream:
DSL.using(configuration) .fetch("select * from t") .stream() .map(MY_TABLE.ID::original) .forEach(System.out::println);
-
changed
Description copied from interface:Field
The inverse operation ofRecord.changed(Field)
.This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream:
DSL.using(configuration) .fetch("select * from t") .stream() .map(MY_TABLE.ID::changed) .forEach(System.out::println);
-
reset
Description copied from interface:Field
The inverse operation ofRecord.reset(Field)
.This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream:
DSL.using(configuration) .fetch("select * from t") .stream() .forEach(MY_TABLE.ID::reset);
-
from
Description copied from interface:Field
The inverse operation ofRecord.into(Field)
.This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream:
DSL.using(configuration) .fetch("select * from t") .stream() .map(MY_TABLE.ID::from) .forEach(System.out::println);
-
convert
Description copied from interface:Field
Apply an ad-hoc data typeBinding
to this field expression.Rather than attaching data type bindings at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataType(Binding)
, this method allows for creating a derived field expression with an ad-hoc data type binding for single query usage. -
convert
Description copied from interface:Field
Apply an ad-hoc data typeConverter
to this field expression.Rather than attaching data type converters at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataType(Converter)
, this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage. -
convert
public final <U> Field<U> convert(Class<U> toType, Function<? super T,? extends U> from, Function<? super U,? extends T> to)Description copied from interface:Field
Apply an ad-hoc data typeConverter
to this field expression.Rather than attaching data type converters at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataType(Class, Function, Function)
, this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage. -
convertFrom
Description copied from interface:Field
Apply an ad-hoc read-only data typeConverter
to this field expression.Rather than attaching data type converters at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataTypeFrom(Class, Function)
, this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.- Specified by:
convertFrom
in interfaceField<T>
- Type Parameters:
U
- The user type.- Returns:
- A derived field expression using a new converter.
-
convertFrom
Description copied from interface:Field
Apply an ad-hoc read-only data typeConverter
to this field expression.Rather than attaching data type converters at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataTypeFrom(Class, Function)
, this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.EXPERIMENTAL. Unlike
Field.convertFrom(Class, Function)
, this method attempts to work without an explicitClass
reference for the underlyingConverter.toType()
. There may be some edge cases where this doesn't work. Please report any bugs here: https://github.com/jOOQ/jOOQ/issues/new/choose- Specified by:
convertFrom
in interfaceField<T>
- Type Parameters:
U
- The user type.- Returns:
- A derived field expression using a new converter.
-
convertTo
Description copied from interface:Field
Apply an ad-hoc write-only data typeConverter
to this field expression.Rather than attaching data type converters at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataTypeTo(Class, Function)
, this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage. -
convertTo
Description copied from interface:Field
Apply an ad-hoc write-only data typeConverter
to this field expression.Rather than attaching data type converters at code generation time, or creating cumbersome expressions using
DataType.asConvertedDataTypeTo(Class, Function)
, this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.EXPERIMENTAL. Unlike
Field.convertTo(Class, Function)
, this method attempts to work without an explicitClass
reference for the underlyingConverter.toType()
. There may be some edge cases where this doesn't work. Please report any bugs here: https://github.com/jOOQ/jOOQ/issues/new/choose -
as
Description copied from interface:SelectField
Create an alias for this field.Note that the case-sensitivity of the returned field depends on
Settings.getRenderQuotedNames()
. By default, field aliases are quoted, and thus case-sensitive in many SQL dialects!- Specified by:
as
in interfaceSelectField<T>
- Parameters:
alias
- The alias name- Returns:
- The field alias
-
as
Description copied from interface:SelectField
Create an alias for this field based on another field's name.- Specified by:
as
in interfaceSelectField<T>
- Parameters:
otherField
- The other field whose name this field is aliased with.- Returns:
- The field alias.
-
as
Description copied from interface:Field
Create an alias for this field.Note that the case-sensitivity of the returned field depends on
Settings.getRenderQuotedNames()
. By default, field aliases are quoted, and thus case-sensitive in many SQL dialects!This works like
SelectField.as(String)
, except that field aliases are provided by a function. This is useful, for instance, to prefix all columns with a common prefix (onTable.as(String, Function)
):MY_TABLE.as("t1", f -> "prefix_" + f.getName());
And then to use the same function also for individual fields:
MY_TABLE.MY_COLUMN.as(f -> "prefix_" + f.getName());
-
cast
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 interfaceField<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
Description copied from interface:Field
Cast this field to a dialect-specific data type. -
cast
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. UseField.cast(DataType)
for more accurate casts.- Specified by:
cast
in interfaceField<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
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 interfaceField<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
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 interfaceField<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
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 interfaceField<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
Description copied from interface:Field
Create an ascending sort field from this field.This is the same as calling
Field.sort(SortOrder)
withSortOrder.ASC
-
desc
Description copied from interface:Field
Create a descending sort field from this field.This is the same as calling
Field.sort(SortOrder)
withSortOrder.DESC
-
sortDefault
Description copied from interface:Field
Create a default sorted (implicitASC
) from this field.This is the same as calling
Field.sort(SortOrder)
withSortOrder.DEFAULT
- Specified by:
sortDefault
in interfaceField<T>
- Returns:
- This field as a default sorted sort field
-
sort
Description copied from interface:Field
Create an ascending/descending sort field from this field. -
sortAsc
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()
orSortField.nullsLast()
to specify whether the default should have highest or lowest priority. -
sortAsc
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()
orSortField.nullsLast()
to specify whether the default should have highest or lowest priority. -
sortDesc
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()
orSortField.nullsLast()
to specify whether the default should have highest or lowest priority. -
sortDesc
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()
orSortField.nullsLast()
to specify whether the default should have highest or lowest priority. -
sort
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()
orSortField.nullsLast()
to specify whether the default should have highest or lowest priority. -
neg
Description copied from interface:Field
Negate this field to get its negative value.This renders the same on all dialects:
-[this]
-
unaryMinus
Description copied from interface:Field
Negate this field to get its negative value.This is an alias for
Field.neg()
, which can be recognised by the Kotlin language for operator overloading.- Specified by:
unaryMinus
in interfaceField<T>
-
unaryPlus
Description copied from interface:Field
Get this field as its positive value (no effect on SQL).This can be recognised by the Kotlin language for operator overloading.
-
add
Description copied from interface:Field
An arithmetic expression adding this to value.- Specified by:
add
in interfaceField<T>
- See Also:
Field.add(Field)
-
add
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 -
sub
Description copied from interface:Field
An arithmetic expression subtracting value from this.- Specified by:
sub
in interfaceField<T>
- See Also:
Field.sub(Field)
-
sub
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:
-
mul
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 anINTERVAL
field (seeInterval
)
-
mul
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 anINTERVAL
field (seeInterval
)
-
div
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 anINTERVAL
field (seeInterval
)
-
div
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 anINTERVAL
field (seeInterval
)
-
mod
Description copied from interface:Field
An arithmetic expression getting the modulo of this divided by value.This renders the modulo operation where available:
... or the modulo function elsewhere:[this] % [value]
mod([this], [value])
-
mod
Description copied from interface:Field
An arithmetic expression getting the modulo of this divided by value.This renders the modulo operation where available:
... or the modulo function elsewhere:[this] % [value]
mod([this], [value])
-
plus
Description copied from interface:Field
An alias forField.add(Number)
.- Specified by:
plus
in interfaceField<T>
- See Also:
Field.add(Number)
-
plus
Description copied from interface:Field
An alias forField.add(Field)
.- Specified by:
plus
in interfaceField<T>
- See Also:
Field.add(Field)
-
subtract
Description copied from interface:Field
An alias forField.sub(Number)
.- Specified by:
subtract
in interfaceField<T>
- See Also:
Field.sub(Number)
-
subtract
Description copied from interface:Field
An alias forField.sub(Field)
.- Specified by:
subtract
in interfaceField<T>
- See Also:
Field.sub(Field)
-
minus
Description copied from interface:Field
An alias forField.sub(Number)
.- Specified by:
minus
in interfaceField<T>
- See Also:
Field.sub(Number)
-
minus
Description copied from interface:Field
An alias forField.sub(Field)
.- Specified by:
minus
in interfaceField<T>
- See Also:
Field.sub(Field)
-
multiply
Description copied from interface:Field
An alias forField.mul(Number)
.- Specified by:
multiply
in interfaceField<T>
- See Also:
Field.mul(Number)
-
multiply
Description copied from interface:Field
An alias forField.mul(Field)
.- Specified by:
multiply
in interfaceField<T>
- See Also:
Field.mul(Field)
-
times
Description copied from interface:Field
An alias forField.mul(Number)
.- Specified by:
times
in interfaceField<T>
- See Also:
Field.mul(Number)
-
times
Description copied from interface:Field
An alias forField.mul(Field)
.- Specified by:
times
in interfaceField<T>
- See Also:
Field.mul(Field)
-
divide
Description copied from interface:Field
An alias forField.div(Number)
.- Specified by:
divide
in interfaceField<T>
- See Also:
Field.div(Number)
-
divide
Description copied from interface:Field
An alias forField.div(Field)
.- Specified by:
divide
in interfaceField<T>
- See Also:
Field.div(Field)
-
modulo
Description copied from interface:Field
An alias forField.mod(Number)
.- Specified by:
modulo
in interfaceField<T>
- See Also:
Field.mod(Number)
-
modulo
Description copied from interface:Field
An alias forField.mod(Field)
.- Specified by:
modulo
in interfaceField<T>
- See Also:
Field.mod(Field)
-
rem
Description copied from interface:Field
An alias forField.mod(Number)
.- Specified by:
rem
in interfaceField<T>
- See Also:
Field.mod(Number)
-
rem
Description copied from interface:Field
An alias forField.mod(Field)
.- Specified by:
rem
in interfaceField<T>
- See Also:
Field.mod(Field)
-
bitNot
Description copied from interface:Field
The bitwise not operator.- Specified by:
bitNot
in interfaceField<T>
- See Also:
DSL.bitNot(Field)
-
bitAnd
Description copied from interface:Field
The bitwise and operator.- Specified by:
bitAnd
in interfaceField<T>
- See Also:
DSL.bitAnd(Field, Field)
-
bitAnd
Description copied from interface:Field
The bitwise and operator.- Specified by:
bitAnd
in interfaceField<T>
- See Also:
DSL.bitAnd(Field, Field)
-
bitNand
Description copied from interface:Field
The bitwise not and operator.- Specified by:
bitNand
in interfaceField<T>
- See Also:
DSL.bitNand(Field, Field)
,DSL.bitNot(Field)
-
bitNand
Description copied from interface:Field
The bitwise not and operator.- Specified by:
bitNand
in interfaceField<T>
- See Also:
DSL.bitNand(Field, Field)
,DSL.bitNot(Field)
-
bitOr
Description copied from interface:Field
The bitwise or operator.- Specified by:
bitOr
in interfaceField<T>
- See Also:
DSL.bitOr(Field, Field)
-
bitOr
Description copied from interface:Field
The bitwise or operator.- Specified by:
bitOr
in interfaceField<T>
- See Also:
DSL.bitOr(Field, Field)
-
bitNor
Description copied from interface:Field
The bitwise not or operator.- Specified by:
bitNor
in interfaceField<T>
- See Also:
DSL.bitNor(Field, Field)
,DSL.bitNot(Field)
-
bitNor
Description copied from interface:Field
The bitwise not or operator.- Specified by:
bitNor
in interfaceField<T>
- See Also:
DSL.bitNor(Field, Field)
,DSL.bitNot(Field)
-
bitXor
Description copied from interface:Field
The bitwise xor operator.- Specified by:
bitXor
in interfaceField<T>
- See Also:
DSL.bitXor(Field, Field)
-
bitXor
Description copied from interface:Field
The bitwise xor operator.- Specified by:
bitXor
in interfaceField<T>
- See Also:
DSL.bitXor(Field, Field)
-
bitXNor
Description copied from interface:Field
The bitwise not xor operator.- Specified by:
bitXNor
in interfaceField<T>
- See Also:
DSL.bitXNor(Field, Field)
,DSL.bitNot(Field)
-
bitXNor
Description copied from interface:Field
The bitwise not xor operator.- Specified by:
bitXNor
in interfaceField<T>
- See Also:
DSL.bitXNor(Field, Field)
,DSL.bitNot(Field)
-
shl
Description copied from interface:Field
The bitwise left shift operator.- Specified by:
shl
in interfaceField<T>
- See Also:
DSL.shl(Field, Field)
,DSL.power(Field, Number)
-
shl
Description copied from interface:Field
The bitwise left shift operator.- Specified by:
shl
in interfaceField<T>
- See Also:
DSL.shl(Field, Field)
,DSL.power(Field, Number)
-
shr
Description copied from interface:Field
The bitwise right shift operator.- Specified by:
shr
in interfaceField<T>
- See Also:
DSL.shr(Field, Field)
,DSL.power(Field, Number)
-
shr
Description copied from interface:Field
The bitwise right shift operator.- Specified by:
shr
in interfaceField<T>
- See Also:
DSL.shr(Field, Field)
,DSL.power(Field, Number)
-
isDocument
Description copied from interface:Field
Create a condition to check if this field contains XML data.- Specified by:
isDocument
in interfaceField<T>
-
isNotDocument
Description copied from interface:Field
Create a condition to check if this field does not contain XML data.- Specified by:
isNotDocument
in interfaceField<T>
-
isJson
Description copied from interface:Field
Create a condition to check if this field contains JSON data. -
isNotJson
Description copied from interface:Field
Create a condition to check if this field does not contain JSON data. -
isNull
Description copied from interface:Field
Create a condition to check this field againstnull
.SQL:
this is null
-
isNotNull
Description copied from interface:Field
Create a condition to check this field againstnull
.SQL:
this is not null
-
isDistinctFrom
Description copied from interface:Field
Create a condition to check if this field isDISTINCT
from another value.In
SQLDialect.MYSQL
andSQLDialect.MARIADB
, this can be emulated throughnot([this] <=> [value])
In
SQLDialect.SQLITE
, this can be emulated through[this] IS NOT [value]
In databases that support
INTERSECT
(seeSelect.intersect(Select)
, this predicate can be emulated as follows:NOT EXISTS (SELECT [this] INTERSECT SELECT [value])
If this is not supported by the underlying database, jOOQ will render this instead:
SQL: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
this is distinct from value
- Specified by:
isDistinctFrom
in interfaceField<T>
-
isDistinctFrom
Description copied from interface:Field
Create a condition to check if this field isDISTINCT
from another field.In
SQLDialect.MYSQL
andSQLDialect.MARIADB
, this can be emulated throughnot([this] <=> [value])
In
SQLDialect.SQLITE
, this can be emulated through[this] IS NOT [value]
In databases that support
INTERSECT
(seeSelect.intersect(Select)
, this predicate can be emulated as follows:NOT EXISTS (SELECT [this] INTERSECT SELECT [value])
If this is not supported by the underlying database, jOOQ will render this instead:
SQL: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
this is distinct from field
- Specified by:
isDistinctFrom
in interfaceField<T>
-
isDistinctFrom
Description copied from interface:Field
Create a condition to check if this field isDISTINCT
from another field.In
SQLDialect.MYSQL
andSQLDialect.MARIADB
, this can be emulated throughnot([this] <=> [value])
In
SQLDialect.SQLITE
, this can be emulated through[this] IS NOT [value]
In databases that support
INTERSECT
(seeSelect.intersect(Select)
, this predicate can be emulated as follows:NOT EXISTS (SELECT [this] INTERSECT SELECT [value])
If this is not supported by the underlying database, jOOQ will render this instead:
SQL: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
this is distinct from field
- Specified by:
isDistinctFrom
in interfaceField<T>
-
isNotDistinctFrom
Description copied from interface:Field
Create a condition to check if this field isNOT DISTINCT
from another value.In
SQLDialect.MYSQL
andSQLDialect.MARIADB
, this can be emulated through[this] <=> [value]
In
SQLDialect.SQLITE
, this can be emulated through[this] IS [value]
In databases that support
INTERSECT
(seeSelect.intersect(Select)
, this predicate can be emulated as follows:EXISTS (SELECT [this] INTERSECT SELECT [value])
If this is not supported by the underlying database, jOOQ will render this instead:
SQL: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
this is not distinct from value
- Specified by:
isNotDistinctFrom
in interfaceField<T>
-
isNotDistinctFrom
Description copied from interface:Field
Create a condition to check if this field isNOT DISTINCT
from another field.In
SQLDialect.MYSQL
andSQLDialect.MARIADB
, this can be emulated through[this] <=> [value]
In
SQLDialect.SQLITE
, this can be emulated through[this] IS [value]
In databases that support
INTERSECT
(seeSelect.intersect(Select)
, this predicate can be emulated as follows:EXISTS (SELECT [this] INTERSECT SELECT [value])
If this is not supported by the underlying database, jOOQ will render this instead:
SQL: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
this is not distinct from field
- Specified by:
isNotDistinctFrom
in interfaceField<T>
-
isNotDistinctFrom
Description copied from interface:Field
Create a condition to check if this field isNOT DISTINCT
from another field.In
SQLDialect.MYSQL
andSQLDialect.MARIADB
, this can be emulated through[this] <=> [value]
In
SQLDialect.SQLITE
, this can be emulated through[this] IS [value]
In databases that support
INTERSECT
(seeSelect.intersect(Select)
, this predicate can be emulated as follows:EXISTS (SELECT [this] INTERSECT SELECT [value])
If this is not supported by the underlying database, jOOQ will render this instead:
SQL: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
this is not distinct from field
- Specified by:
isNotDistinctFrom
in interfaceField<T>
-
isTrue
Description copied from interface:Field
Create a condition to check this field against known string literals fortrue
.SQL:
lcase(this) in ("1", "y", "yes", "true", "on", "enabled")
-
isFalse
Description copied from interface:Field
Create a condition to check this field against known string literals forfalse
.SQL:
lcase(this) in ("0", "n", "no", "false", "off", "disabled")
-
similarTo
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this similar to value
-
similarTo
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this similar to value escape 'e'
- Specified by:
similarTo
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
similarTo
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this similar to value
-
similarTo
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this similar to value escape 'e'
- Specified by:
similarTo
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
notSimilarTo
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this not similar to value
- Specified by:
notSimilarTo
in interfaceField<T>
-
notSimilarTo
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this not similar to value escape 'e'
- Specified by:
notSimilarTo
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
notSimilarTo
Description copied from interface:Field
Create a condition to pattern-check this field against a field.SQL:
this not similar to field
- Specified by:
notSimilarTo
in interfaceField<T>
-
notSimilarTo
Description copied from interface:Field
Create a condition to pattern-check this field against a field.SQL:
this not similar to field escape 'e'
- Specified by:
notSimilarTo
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
like
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this like value
-
like
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 interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
like
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this like value
-
like
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 interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
like
Description copied from interface:Field
Create a condition to pattern-check this field against a quantified select.For example a query like
field.like(any("a%", "b%"))
translates into the SQL(field like 'a%' or field like 'b%')
.- Specified by:
like
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Field...)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Field...)
,DSL.any(Select)
,DSL.any(Object...)
,LikeEscapeStep.escape(char)
-
likeIgnoreCase
Description copied from interface:Field
Create a condition to case-insensitively pattern-check this field against a value.This translates to
this ilike value
inSQLDialect.POSTGRES
, or tolower(this) like lower(value)
in all other dialects.- Specified by:
likeIgnoreCase
in interfaceField<T>
-
likeIgnoreCase
Description copied from interface:Field
Create a condition to case-insensitively pattern-check this field against a value.This translates to
this ilike value
inSQLDialect.POSTGRES
, or tolower(this) like lower(value)
in all other dialects.- Specified by:
likeIgnoreCase
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
likeIgnoreCase
Description copied from interface:Field
Create a condition to case-insensitively pattern-check this field against a field.This translates to
this ilike field
inSQLDialect.POSTGRES
, or tolower(this) like lower(field)
in all other dialects.- Specified by:
likeIgnoreCase
in interfaceField<T>
-
likeIgnoreCase
Description copied from interface:Field
Create a condition to case-insensitively pattern-check this field against a field.This translates to
this ilike field
inSQLDialect.POSTGRES
, or tolower(this) like lower(field)
in all other dialects.- Specified by:
likeIgnoreCase
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
likeRegex
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:- Specified by:
likeRegex
in interfaceField<T>
- See Also:
Field.likeRegex(String)
-
likeRegex
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 interfaceField<T>
- See Also:
Field.likeRegex(String)
-
notLike
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this not like value
-
notLike
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 interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
notLike
Description copied from interface:Field
Create a condition to pattern-check this field against a field.SQL:
this not like field
-
notLike
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 interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
notLike
Description copied from interface:Field
Create a condition to pattern-check this field against a quantified select.For example a query like
field.notLike(any("a%", "b%"))
translates into the SQL(field not like 'a%' or field not like 'b%')
.- Specified by:
notLike
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Field...)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Field...)
,DSL.any(Select)
,DSL.any(Object...)
,LikeEscapeStep.escape(char)
-
notLikeIgnoreCase
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
inSQLDialect.POSTGRES
, or tolower(this) not like lower(value)
in all other dialects.- Specified by:
notLikeIgnoreCase
in interfaceField<T>
-
notLikeIgnoreCase
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
inSQLDialect.POSTGRES
, or tolower(this) not like lower(value)
in all other dialects.- Specified by:
notLikeIgnoreCase
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
notLikeIgnoreCase
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
inSQLDialect.POSTGRES
, or tolower(this) not like lower(field)
in all other dialects.- Specified by:
notLikeIgnoreCase
in interfaceField<T>
-
notLikeIgnoreCase
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
inSQLDialect.POSTGRES
, or tolower(this) not like lower(field)
in all other dialects.- Specified by:
notLikeIgnoreCase
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
notLikeRegex
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 interfaceField<T>
- See Also:
Field.likeRegex(String)
-
notLikeRegex
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 interfaceField<T>
- See Also:
Field.likeRegex(Field)
-
contains
Description copied from interface:Field
Convenience method forField.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 toOracleDSL.contains(Field, String)
instead.- Specified by:
contains
in interfaceField<T>
- See Also:
DSL.escape(String, char)
,Field.like(String, char)
-
contains
Description copied from interface:Field
Convenience method forField.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 toOracleDSL.contains(Field, String)
instead.- Specified by:
contains
in interfaceField<T>
- See Also:
DSL.escape(Field, char)
,Field.like(Field, char)
-
notContains
Description copied from interface:Field
Inverse ofField.contains(Object)
.- Specified by:
notContains
in interfaceField<T>
-
notContains
Description copied from interface:Field
Inverse ofField.contains(Field)
.- Specified by:
notContains
in interfaceField<T>
-
containsIgnoreCase
Description copied from interface:Field
Convenience method forField.likeIgnoreCase(String, char)
including proper adding of wildcards and escaping.This translates to
this ilike ('%' || escape(value, '\') || '%') escape '\'
inSQLDialect.POSTGRES
, or tolower(this) not like lower(('%' || escape(value, '\') || '%') escape '\')
in all other dialects.- Specified by:
containsIgnoreCase
in interfaceField<T>
- See Also:
DSL.escape(Field, char)
,Field.likeIgnoreCase(String, char)
,Field.contains(Object)
-
containsIgnoreCase
Description copied from interface:Field
Convenience method forField.likeIgnoreCase(String, char)
including proper adding of wildcards and escaping.This translates to
this ilike ('%' || escape(value, '\') || '%') escape '\'
inSQLDialect.POSTGRES
, or tolower(this) like lower(('%' || escape(value, '\') || '%') escape '\')
in all other dialects.- Specified by:
containsIgnoreCase
in interfaceField<T>
- See Also:
DSL.escape(Field, char)
,Field.likeIgnoreCase(Field, char)
,Field.contains(Field)
-
notContainsIgnoreCase
Description copied from interface:Field
Inverse ofField.containsIgnoreCase(Object)
- Specified by:
notContainsIgnoreCase
in interfaceField<T>
-
notContainsIgnoreCase
Description copied from interface:Field
Inverse ofField.containsIgnoreCase(Field)
- Specified by:
notContainsIgnoreCase
in interfaceField<T>
-
startsWith
Description copied from interface:Field
Convenience method forField.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 interfaceField<T>
- See Also:
DSL.escape(String, char)
,Field.like(String, char)
-
startsWith
Description copied from interface:Field
Convenience method forField.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 interfaceField<T>
- See Also:
DSL.escape(Field, char)
,Field.like(Field, char)
-
startsWithIgnoreCase
Description copied from interface:Field
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.SQL:
lower(this) like (lower(escape(value, '\')) || '%') escape '\'
Note: This also works with numbers, for instance
val(1133).startsWithIgnoreCase(11)
- Specified by:
startsWithIgnoreCase
in interfaceField<T>
- See Also:
DSL.escape(String, char)
,Field.like(String, char)
-
startsWithIgnoreCase
Description copied from interface:Field
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.SQL:
lower(this) like (lower(escape(value, '\')) || '%') escape '\'
Note: This also works with numbers, for instance
val(1133).startsWithIgnoreCase(11)
- Specified by:
startsWithIgnoreCase
in interfaceField<T>
- See Also:
DSL.escape(Field, char)
,Field.like(Field, char)
-
endsWith
Description copied from interface:Field
Convenience method forField.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 interfaceField<T>
- See Also:
DSL.escape(String, char)
,Field.like(String, char)
-
endsWith
Description copied from interface:Field
Convenience method forField.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 interfaceField<T>
- See Also:
DSL.escape(Field, char)
,Field.like(Field, char)
-
endsWithIgnoreCase
Description copied from interface:Field
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.SQL:
lower(this) like ('%' || lower(escape(value, '\'))) escape '\'
Note: This also works with numbers, for instance
val(1133).endsWithIgnoreCase(33)
- Specified by:
endsWithIgnoreCase
in interfaceField<T>
- See Also:
DSL.escape(String, char)
,Field.like(String, char)
-
endsWithIgnoreCase
Description copied from interface:Field
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.SQL:
this like ('%' || lower(escape(value, '\'))) escape '\'
Note: This also works with numbers, for instance
val(1133).endsWithIgnoreCase(33)
- Specified by:
endsWithIgnoreCase
in interfaceField<T>
- See Also:
DSL.escape(Field, char)
,Field.like(Field, char)
-
in
Description copied from interface:Field
Create a condition to check this field against several values.SQL:
this in (values...)
Note that generating dynamic SQL with arbitrary-length
IN
predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE
). In order to prevent such problems, you could useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables
-
in
Description copied from interface:Field
Create a condition to check this field against several values.SQL:
this in (values...)
-
in
Description copied from interface:Field
Create a condition to check this field against several values.SQL:
this in (values...)
Note that generating dynamic SQL with arbitrary-length
IN
predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE
). In order to prevent such problems, you could useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables
-
in
Description copied from interface:Field
Create a condition to check this field against several values from a previous query.SQL:
this in (values...)
Note that generating dynamic SQL with arbitrary-length
IN
predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE
). In order to prevent such problems, you could useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables
-
in
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...)
-
notIn
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 beNULL
(orfalse
, depending on the dialect) as well. This is standard SQL behaviour.SQL:
this not in (values...)
Note that generating dynamic SQL with arbitrary-length
NOT IN
predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE
). In order to prevent such problems, you could useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables
-
notIn
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 beNULL
(orfalse
, depending on the dialect) as well. This is standard SQL behaviour.SQL:
this not in (values...)
-
notIn
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 beNULL
(orfalse
, depending on the dialect) as well. This is standard SQL behaviour.SQL:
this not in (values...)
Note that generating dynamic SQL with arbitrary-length
NOT IN
predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE
). In order to prevent such problems, you could useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables
-
notIn
Description copied from interface:Field
Create a condition to check this field against several values from a previous query.Note that if any of the passed values is
NULL
, then the condition will beNULL
(orfalse
, depending on the dialect) as well. This is standard SQL behaviour.SQL:
this in (values...)
Note that generating dynamic SQL with arbitrary-length
NOT IN
predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE
). In order to prevent such problems, you could useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables
-
notIn
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 beNULL
(orfalse
, depending on the dialect) as well. This is standard SQL behaviour.SQL:
this not in (select...)
-
between
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
-
between
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
-
betweenSymmetric
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 interfaceField<T>
-
betweenSymmetric
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 interfaceField<T>
-
notBetween
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 interfaceField<T>
-
notBetween
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 interfaceField<T>
-
notBetweenSymmetric
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 interfaceField<T>
-
notBetweenSymmetric
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 interfaceField<T>
-
between
Description copied from interface:Field
Create a condition to check this field against some bounds.SQL:
this between minValue and maxValue
-
between
Description copied from interface:Field
Create a condition to check this field against some bounds.SQL:
this between minValue and maxValue
-
betweenSymmetric
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 interfaceField<T>
-
betweenSymmetric
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 interfaceField<T>
-
notBetween
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 interfaceField<T>
-
notBetween
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 interfaceField<T>
-
notBetweenSymmetric
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 interfaceField<T>
-
notBetweenSymmetric
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 interfaceField<T>
-
eq
Description copied from interface:Field
this = value
.- Specified by:
eq
in interfaceField<T>
- See Also:
Field.equal(Object)
-
eq
Description copied from interface:Field
this = field
.- Specified by:
eq
in interfaceField<T>
- See Also:
Field.equal(Field)
-
eq
Description copied from interface:Field
this = (Select<?> ...)
.- Specified by:
eq
in interfaceField<T>
- See Also:
Field.equal(Select)
-
eq
Description copied from interface:Field
this = [quantifier] (Select<?> ...)
.- Specified by:
eq
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
ne
Description copied from interface:Field
this != value
.- Specified by:
ne
in interfaceField<T>
- See Also:
Field.notEqual(Object)
-
ne
Description copied from interface:Field
this != field
.- Specified by:
ne
in interfaceField<T>
- See Also:
Field.notEqual(Field)
-
ne
Description copied from interface:Field
this != (Select<?> ...)
.- Specified by:
ne
in interfaceField<T>
- See Also:
Field.notEqual(Select)
-
ne
Description copied from interface:Field
this != [quantifier] (Select<?> ...)
.- Specified by:
ne
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
lt
Description copied from interface:Field
this < value
.- Specified by:
lt
in interfaceField<T>
- See Also:
Field.lessThan(Object)
-
lt
Description copied from interface:Field
this < field
.- Specified by:
lt
in interfaceField<T>
- See Also:
Field.lessThan(Field)
-
lt
Description copied from interface:Field
this < (Select<?> ...)
.- Specified by:
lt
in interfaceField<T>
- See Also:
Field.lessThan(Select)
-
lt
Description copied from interface:Field
this < [quantifier] (Select<?> ...)
.- Specified by:
lt
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
le
Description copied from interface:Field
this <= value
.- Specified by:
le
in interfaceField<T>
- See Also:
Field.lessOrEqual(Object)
-
le
Description copied from interface:Field
this <= field
.- Specified by:
le
in interfaceField<T>
- See Also:
Field.lessOrEqual(Field)
-
le
Description copied from interface:Field
this <= (Select<?> ...)
.- Specified by:
le
in interfaceField<T>
- See Also:
Field.lessOrEqual(Select)
-
le
Description copied from interface:Field
this <= [quantifier] (Select<?> ...)
.- Specified by:
le
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
gt
Description copied from interface:Field
this > value
.- Specified by:
gt
in interfaceField<T>
- See Also:
Field.greaterThan(Object)
-
gt
Description copied from interface:Field
this > field
.- Specified by:
gt
in interfaceField<T>
- See Also:
Field.greaterThan(Field)
-
gt
Description copied from interface:Field
this > (Select<?> ...)
.- Specified by:
gt
in interfaceField<T>
- See Also:
Field.greaterThan(Select)
-
gt
Description copied from interface:Field
this > [quantifier] (Select<?> ...)
.- Specified by:
gt
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
ge
Description copied from interface:Field
this >= value
.- Specified by:
ge
in interfaceField<T>
- See Also:
Field.greaterOrEqual(Object)
-
ge
Description copied from interface:Field
this >= field
.- Specified by:
ge
in interfaceField<T>
- See Also:
Field.greaterOrEqual(Field)
-
ge
Description copied from interface:Field
this >= (Select<?> ...)
.- Specified by:
ge
in interfaceField<T>
- See Also:
Field.greaterOrEqual(Select)
-
ge
Description copied from interface:Field
this >= [quantifier] (Select<?> ...)
.- Specified by:
ge
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
equal
Description copied from interface:Field
this = value
. -
equal
Description copied from interface:Field
this = field
. -
equalIgnoreCase
Description copied from interface:Field
lower(this) = lower(value)
.- Specified by:
equalIgnoreCase
in interfaceField<T>
-
equalIgnoreCase
Description copied from interface:Field
lower(this) = lower(value)
.- Specified by:
equalIgnoreCase
in interfaceField<T>
-
equal
Description copied from interface:Field
this = (Select<?> ...)
. -
equal
Description copied from interface:Field
this = [quantifier] (Select<?> ...)
.- Specified by:
equal
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
notEqual
Description copied from interface:Field
this != value
. -
notEqual
Description copied from interface:Field
this != field
. -
notEqualIgnoreCase
Description copied from interface:Field
lower(this) != lower(value)
.- Specified by:
notEqualIgnoreCase
in interfaceField<T>
-
notEqualIgnoreCase
Description copied from interface:Field
lower(this) != lower(value)
.- Specified by:
notEqualIgnoreCase
in interfaceField<T>
-
notEqual
Description copied from interface:Field
this != (Select<?> ...)
. -
notEqual
Description copied from interface:Field
this != [quantifier] (Select<?> ...)
.- Specified by:
notEqual
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
lessThan
Description copied from interface:Field
this < value
. -
lessThan
Description copied from interface:Field
this < field
. -
lessThan
Description copied from interface:Field
this < (Select<?> ...)
. -
lessThan
Description copied from interface:Field
this < [quantifier] (Select<?> ...)
.- Specified by:
lessThan
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
lessOrEqual
Description copied from interface:Field
this <= value
.- Specified by:
lessOrEqual
in interfaceField<T>
-
lessOrEqual
Description copied from interface:Field
this <= field
.- Specified by:
lessOrEqual
in interfaceField<T>
-
lessOrEqual
Description copied from interface:Field
this <= (Select<?> ...)
.- Specified by:
lessOrEqual
in interfaceField<T>
-
lessOrEqual
Description copied from interface:Field
this <= [quantifier] (Select<?> ...)
.- Specified by:
lessOrEqual
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
greaterThan
Description copied from interface:Field
this > value
.- Specified by:
greaterThan
in interfaceField<T>
-
greaterThan
Description copied from interface:Field
this > field
.- Specified by:
greaterThan
in interfaceField<T>
-
greaterThan
Description copied from interface:Field
this > (Select<?> ...)
.- Specified by:
greaterThan
in interfaceField<T>
-
greaterThan
Description copied from interface:Field
this > [quantifier] (Select<?> ...)
.- Specified by:
greaterThan
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
greaterOrEqual
Description copied from interface:Field
this >= value
.- Specified by:
greaterOrEqual
in interfaceField<T>
-
greaterOrEqual
Description copied from interface:Field
this >= field
.- Specified by:
greaterOrEqual
in interfaceField<T>
-
greaterOrEqual
Description copied from interface:Field
this >= (Select<?> ...)
.- Specified by:
greaterOrEqual
in interfaceField<T>
-
greaterOrEqual
Description copied from interface:Field
this >= [quantifier] (Select<?> ...)
.- Specified by:
greaterOrEqual
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
compare
Description copied from interface:Field
Compare this field with a value using a dynamic comparator. -
compare
Description copied from interface:Field
Compare this field with another field using a dynamic comparator. -
compare
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. -
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. -
plus
Description copied from interface:Field
Turn this field into an Oracle-specific field for use in outer-join predicates. It can be emulated usingSettings.isTransformTableListsToAnsiJoin()
.Example:
TABLE1.COL.plus().eq(TABLE2.COL); TABLE1.COL.eq(TABLE2.COL.plus());
The above will generate
TABLE1.COL(+) = TABLE2.COL TABLE1.COL = TABLE2.COL(+)
-
sign
Deprecated.- Specified by:
sign
in interfaceField<T>
- See Also:
DSL.sign(Field)
-
abs
Deprecated.- Specified by:
abs
in interfaceField<T>
- See Also:
DSL.abs(Field)
-
round
Deprecated.- Specified by:
round
in interfaceField<T>
- See Also:
DSL.round(Field)
-
round
Deprecated.- Specified by:
round
in interfaceField<T>
- See Also:
DSL.round(Field, int)
-
floor
Deprecated.- Specified by:
floor
in interfaceField<T>
- See Also:
DSL.floor(Field)
-
ceil
Deprecated.- Specified by:
ceil
in interfaceField<T>
- See Also:
DSL.ceil(Field)
-
sqrt
Deprecated.- Specified by:
sqrt
in interfaceField<T>
- See Also:
DSL.sqrt(Field)
-
exp
Deprecated.- Specified by:
exp
in interfaceField<T>
- See Also:
DSL.exp(Field)
-
ln
Deprecated.- Specified by:
ln
in interfaceField<T>
- See Also:
DSL.ln(Field)
-
log
Deprecated.- Specified by:
log
in interfaceField<T>
- See Also:
DSL.log(Field, int)
-
pow
Description copied from interface:Field
An arithmetic expression getting this value raised to the power ofexponent
.This renders the power operation where available:
... or the power function elsewhere:[this] ^ [value]
power([this], [value])
- Specified by:
pow
in interfaceField<T>
- See Also:
DSL.power(Field, Number)
-
power
Description copied from interface:Field
An alias forField.power(Number)
.- Specified by:
power
in interfaceField<T>
- See Also:
Field.power(Number)
-
pow
Description copied from interface:Field
An arithmetic expression getting this value raised to the power ofexponent
.This renders the power operation where available:
... or the power function elsewhere:[this] ^ [value]
power([this], [value])
- Specified by:
pow
in interfaceField<T>
- See Also:
DSL.power(Field, Field)
-
power
Description copied from interface:Field
An alias forField.power(Field)
.- Specified by:
power
in interfaceField<T>
- See Also:
Field.power(Field)
-
acos
Deprecated.- Specified by:
acos
in interfaceField<T>
- See Also:
DSL.acos(Field)
-
asin
Deprecated.- Specified by:
asin
in interfaceField<T>
- See Also:
DSL.asin(Field)
-
atan
Deprecated.- Specified by:
atan
in interfaceField<T>
- See Also:
DSL.atan(Field)
-
atan2
Deprecated.- Specified by:
atan2
in interfaceField<T>
- See Also:
DSL.atan2(Field, Number)
-
atan2
Deprecated.- Specified by:
atan2
in interfaceField<T>
- See Also:
DSL.atan2(Field, Field)
-
cos
Deprecated.- Specified by:
cos
in interfaceField<T>
- See Also:
DSL.cos(Field)
-
sin
Deprecated.- Specified by:
sin
in interfaceField<T>
- See Also:
DSL.sin(Field)
-
tan
Deprecated.- Specified by:
tan
in interfaceField<T>
- See Also:
DSL.tan(Field)
-
cot
Deprecated.- Specified by:
cot
in interfaceField<T>
- See Also:
DSL.cot(Field)
-
sinh
Deprecated.- Specified by:
sinh
in interfaceField<T>
- See Also:
DSL.sinh(Field)
-
cosh
Deprecated.- Specified by:
cosh
in interfaceField<T>
- See Also:
DSL.cosh(Field)
-
tanh
Deprecated.- Specified by:
tanh
in interfaceField<T>
- See Also:
DSL.tanh(Field)
-
coth
Deprecated.- Specified by:
coth
in interfaceField<T>
- See Also:
DSL.coth(Field)
-
deg
Deprecated.- Specified by:
deg
in interfaceField<T>
- See Also:
DSL.deg(Field)
-
rad
Deprecated.- Specified by:
rad
in interfaceField<T>
- See Also:
DSL.rad(Field)
-
count
Deprecated.- Specified by:
count
in interfaceField<T>
- See Also:
DSL.count(Field)
-
countDistinct
Deprecated.- Specified by:
countDistinct
in interfaceField<T>
- See Also:
DSL.countDistinct(Field)
-
max
Deprecated.- Specified by:
max
in interfaceField<T>
- See Also:
DSL.max(Field)
-
min
Deprecated.- Specified by:
min
in interfaceField<T>
- See Also:
DSL.min(Field)
-
sum
Deprecated.- Specified by:
sum
in interfaceField<T>
- See Also:
DSL.sum(Field)
-
avg
Deprecated.- Specified by:
avg
in interfaceField<T>
- See Also:
DSL.avg(Field)
-
median
Deprecated.- Specified by:
median
in interfaceField<T>
- See Also:
DSL.median(Field)
-
stddevPop
Deprecated.- Specified by:
stddevPop
in interfaceField<T>
- See Also:
DSL.stddevPop(Field)
-
stddevSamp
Deprecated.- Specified by:
stddevSamp
in interfaceField<T>
- See Also:
DSL.stddevSamp(Field)
-
varPop
Deprecated.- Specified by:
varPop
in interfaceField<T>
- See Also:
DSL.varPop(Field)
-
varSamp
Deprecated.- Specified by:
varSamp
in interfaceField<T>
- See Also:
DSL.varSamp(Field)
-
countOver
Deprecated.- Specified by:
countOver
in interfaceField<T>
- See Also:
DSL.count(Field)
,WindowOverStep.over()
-
maxOver
Deprecated.- Specified by:
maxOver
in interfaceField<T>
- See Also:
DSL.max(Field)
,WindowOverStep.over()
-
minOver
Deprecated.- Specified by:
minOver
in interfaceField<T>
- See Also:
DSL.min(Field)
,WindowOverStep.over()
-
sumOver
Deprecated.- Specified by:
sumOver
in interfaceField<T>
- See Also:
DSL.sum(Field)
,WindowOverStep.over()
-
avgOver
Deprecated.- Specified by:
avgOver
in interfaceField<T>
- See Also:
DSL.avg(Field)
,WindowOverStep.over()
-
firstValue
Deprecated.- Specified by:
firstValue
in interfaceField<T>
- See Also:
DSL.firstValue(Field)
,WindowOverStep.over()
-
lastValue
Deprecated.- Specified by:
lastValue
in interfaceField<T>
- See Also:
DSL.lastValue(Field)
,WindowOverStep.over()
-
lead
Deprecated.- Specified by:
lead
in interfaceField<T>
- See Also:
DSL.lead(Field)
,WindowOverStep.over()
-
lead
Deprecated.- Specified by:
lead
in interfaceField<T>
- See Also:
DSL.lead(Field, int)
,WindowOverStep.over()
-
lead
Deprecated.- Specified by:
lead
in interfaceField<T>
- See Also:
DSL.lead(Field, int, Object)
,WindowOverStep.over()
-
lead
Deprecated.- Specified by:
lead
in interfaceField<T>
- See Also:
DSL.lead(Field, int, Field)
,WindowOverStep.over()
-
lag
Deprecated.- Specified by:
lag
in interfaceField<T>
- See Also:
DSL.lag(Field)
,WindowOverStep.over()
-
lag
Deprecated.- Specified by:
lag
in interfaceField<T>
- See Also:
DSL.lag(Field, int)
,WindowOverStep.over()
-
lag
Deprecated.- Specified by:
lag
in interfaceField<T>
- See Also:
DSL.lag(Field, int, Object)
,WindowOverStep.over()
-
lag
Deprecated.- Specified by:
lag
in interfaceField<T>
- See Also:
DSL.lag(Field, int, Field)
,WindowOverStep.over()
-
stddevPopOver
Deprecated.- Specified by:
stddevPopOver
in interfaceField<T>
- See Also:
DSL.stddevPop(Field)
,WindowOverStep.over()
-
stddevSampOver
Deprecated.- Specified by:
stddevSampOver
in interfaceField<T>
- See Also:
DSL.stddevSamp(Field)
,WindowOverStep.over()
-
varPopOver
Deprecated.- Specified by:
varPopOver
in interfaceField<T>
- See Also:
DSL.varPop(Field)
,WindowOverStep.over()
-
varSampOver
Deprecated.- Specified by:
varSampOver
in interfaceField<T>
- See Also:
DSL.varSamp(Field)
,WindowOverStep.over()
-
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 fromDSLContext
- Specified by:
upper
in interfaceField<T>
- See Also:
DSL.upper(Field)
-
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 fromDSLContext
- Specified by:
lower
in interfaceField<T>
- See Also:
DSL.lower(Field)
-
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 fromDSLContext
- Specified by:
trim
in interfaceField<T>
- See Also:
DSL.trim(Field)
-
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 fromDSLContext
- Specified by:
rtrim
in interfaceField<T>
- See Also:
DSL.rtrim(Field)
-
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 fromDSLContext
- Specified by:
ltrim
in interfaceField<T>
- See Also:
DSL.ltrim(Field)
-
rpad
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
rpad
in interfaceField<T>
- See Also:
DSL.rpad(Field, Field)
-
rpad
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
rpad
in interfaceField<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 fromDSLContext
- Specified by:
rpad
in interfaceField<T>
- See Also:
DSL.rpad(Field, Field, Field)
-
rpad
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
rpad
in interfaceField<T>
- See Also:
DSL.rpad(Field, int, char)
-
lpad
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
lpad
in interfaceField<T>
- See Also:
DSL.lpad(Field, Field)
-
lpad
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
lpad
in interfaceField<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 fromDSLContext
- Specified by:
lpad
in interfaceField<T>
- See Also:
DSL.lpad(Field, Field, Field)
-
lpad
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
lpad
in interfaceField<T>
- See Also:
DSL.lpad(Field, int, char)
-
repeat
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
repeat
in interfaceField<T>
- See Also:
DSL.repeat(Field, int)
-
repeat
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
repeat
in interfaceField<T>
- See Also:
DSL.repeat(Field, Field)
-
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 fromDSLContext
- Specified by:
replace
in interfaceField<T>
- See Also:
DSL.replace(Field, Field)
-
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 fromDSLContext
- Specified by:
replace
in interfaceField<T>
- See Also:
DSL.replace(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 fromDSLContext
- Specified by:
replace
in interfaceField<T>
- See Also:
DSL.replace(Field, Field, Field)
-
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 fromDSLContext
- Specified by:
replace
in interfaceField<T>
- See Also:
DSL.replace(Field, String, String)
-
position
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
position
in interfaceField<T>
- See Also:
DSL.position(Field, String)
-
position
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
position
in interfaceField<T>
- See Also:
DSL.position(Field, Field)
-
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 fromDSLContext
- Specified by:
ascii
in interfaceField<T>
- See Also:
DSL.ascii(Field)
-
collate
Description copied from interface:Field
Apply a collation operator to this column expression.- Specified by:
collate
in interfaceField<T>
- See Also:
DSL.collation(String)
-
collate
Description copied from interface:Field
Apply a collation operator to this column expression.- Specified by:
collate
in interfaceField<T>
- See Also:
DSL.collation(Name)
-
collate
Description copied from interface:Field
Apply a collation operator to this column expression. -
concat
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
concat
in interfaceField<T>
- See Also:
DSL.concat(Field...)
-
concat
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
concat
in interfaceField<T>
- See Also:
DSL.concat(String...)
-
concat
Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
concat
in interfaceField<T>
- See Also:
DSL.concat(String...)
-
substring
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
substring
in interfaceField<T>
- See Also:
DSL.substring(Field, int)
-
substring
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
substring
in interfaceField<T>
- See Also:
DSL.substring(Field, Field)
-
substring
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
substring
in interfaceField<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 fromDSLContext
- Specified by:
substring
in interfaceField<T>
- See Also:
DSL.substring(Field, Field, Field)
-
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 fromDSLContext
- Specified by:
length
in interfaceField<T>
- See Also:
DSL.length(Field)
-
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 fromDSLContext
- Specified by:
charLength
in interfaceField<T>
- See Also:
DSL.charLength(Field)
-
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 fromDSLContext
- Specified by:
bitLength
in interfaceField<T>
- See Also:
DSL.bitLength(Field)
-
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 fromDSLContext
- Specified by:
octetLength
in interfaceField<T>
- See Also:
DSL.octetLength(Field)
-
extract
Deprecated.- Specified by:
extract
in interfaceField<T>
- See Also:
DSL.extract(Field, DatePart)
-
greatest
Deprecated.- Specified by:
greatest
in interfaceField<T>
- See Also:
DSL.greatest(Field, Field...)
-
greatest
Deprecated.- Specified by:
greatest
in interfaceField<T>
- See Also:
DSL.greatest(Field, Field...)
-
least
Deprecated.- Specified by:
least
in interfaceField<T>
- See Also:
DSL.least(Field, Field...)
-
least
Deprecated.- Specified by:
least
in interfaceField<T>
- See Also:
DSL.least(Field, Field...)
-
nvl
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
nvl
in interfaceField<T>
- See Also:
DSL.nvl(Field, Object)
-
nvl
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
nvl
in interfaceField<T>
- See Also:
DSL.nvl(Field, Field)
-
nvl2
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
nvl2
in interfaceField<T>
- See Also:
DSL.nvl2(Field, Object, Object)
-
nvl2
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
nvl2
in interfaceField<T>
- See Also:
DSL.nvl2(Field, Field, Field)
-
nullif
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
nullif
in interfaceField<T>
- See Also:
DSL.nullif(Field, Object)
-
nullif
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
nullif
in interfaceField<T>
- See Also:
DSL.nullif(Field, Field)
-
decode
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
decode
in interfaceField<T>
- See Also:
DSL.decode(Object, Object, Object)
-
decode
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
decode
in interfaceField<T>
- See Also:
DSL.decode(Object, Object, Object, Object...)
-
decode
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
decode
in interfaceField<T>
- See Also:
DSL.decode(Field, Field, Field)
-
decode
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
decode
in interfaceField<T>
- See Also:
DSL.decode(Field, Field, Field, Field...)
-
coalesce
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
coalesce
in interfaceField<T>
- See Also:
DSL.coalesce(Object, Object...)
-
coalesce
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
coalesce
in interfaceField<T>
- See Also:
DSL.coalesce(Field, Field...)
-
getConverter
Description copied from interface:Typed
The object's underlyingConverter
.By default, all typed objects reference an identity-converter
Converter<T, T>
. If an implementation is generated, custom data types may be obtained by a customConverter
placed on the generated object.- Specified by:
getConverter
in interfaceTyped<T>
-
getBinding
Description copied from interface:Typed
The object's underlyingBinding
.- Specified by:
getBinding
in interfaceTyped<T>
-
getType
Description copied from interface:Typed
The Java type of the object. -
getDataType
Description copied from interface:Typed
The type of this object (might not be dialect-specific).- Specified by:
getDataType
in interfaceTyped<T>
-
getDataType
Description copied from interface:Typed
The dialect-specific type of this object.- Specified by:
getDataType
in interfaceTyped<T>
-
getName
Description copied from interface:Named
The unqualified name of this object. -
getQualifiedName
Description copied from interface:Named
The qualified name of this object.- Specified by:
getQualifiedName
in interfaceNamed
-
getUnqualifiedName
Description copied from interface:Named
The unqualified name of this object.- Specified by:
getUnqualifiedName
in interfaceNamed
-
getComment
Description copied from interface:Named
The comment on this object.This is the same as calling
Named.getCommentPart()
and thenComment.getComment()
.- Specified by:
getComment
in interfaceNamed
-
getCommentPart
Description copied from interface:Named
The comment on this object as aQueryPart
.- Specified by:
getCommentPart
in interfaceNamed
-
hashCode
public int hashCode()Description copied from interface:QueryPart
Generate a hash code from thisQueryPart
.In general,
QueryPart
hash codes are the same as the hash codes generated fromQueryPart.toString()
. This guarantees consistent behaviour withQueryPart.equals(Object)
Some
QueryPart
implementations may choose to override this behaviour for improved performance, asQueryPart.toString()
is an expensive operation, if called many times. -
equals
Description copied from interface:QueryPart
Check whether thisQueryPart
can be considered equal to anotherQueryPart
.In general,
QueryPart
equality is defined in terms ofQueryPart.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, asQueryPart.toString()
is an expensive operation, if called many times. -
rendersContent
Subclasses may override this- Specified by:
rendersContent
in interfaceQueryPartInternal
-
declaresWindows
public boolean declaresWindows()Subclasses may override this- Specified by:
declaresWindows
in interfaceQueryPartInternal
-
declaresCTE
public boolean declaresCTE()Subclasses may override this- Specified by:
declaresCTE
in interfaceQueryPartInternal
-
declaresParameters
Subclasses may override this- Specified by:
declaresParameters
in interfaceQueryPartInternal
-
generatesCast
public boolean generatesCast()Subclasses may override this- Specified by:
generatesCast
in interfaceQueryPartInternal
-
toString
Description copied from interface:QueryPart
Render a SQL string representation of thisQueryPart
.For improved debugging, this renders a SQL string of this
QueryPart
with inlined bind variables. If thisQueryPart
isAttachable
, then the attachedConfiguration
may be used for rendering the SQL string, includingSQLDialect
andSettings
. Do note that mostQueryPart
instances are not attached to aConfiguration
, and thus there is no guarantee that the SQL string will make sense in the context of a specific database. -
create
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.Internal convenience method -
create
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.Internal convenience method -
create
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.Internal convenience method -
translate
Internal convenience method
-
Attachable.configuration()
andConfiguration.dsl()
instead.