- java.lang.Object
-
- org.jooq.impl.ConvertDateTime<T>
-
- All Implemented Interfaces:
Serializable
,Field<T>
,FieldOrConstraint
,FieldOrRow
,GroupField
,Named
,OrderField<T>
,QueryPart
,QueryPartInternal
,SelectField<T>
,SelectFieldOrAsterisk
@Pro public class ConvertDateTime<T> extends Object
- Author:
- Lukas Eder
- See Also:
- Serialized Form
-
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description Field<T>
abs()
Deprecated.void
accept(Context<?> ctx)
Field<BigDecimal>
acos()
Deprecated.Field<T>
add(Number value)
An arithmetic expression adding this to value.Field<T>
add(Field<?> value)
An arithmetic expression to add value to this.Field<T>
as(String alias)
Create an alias for this field.Field<T>
as(Function<? super Field<T>,? extends String> aliasFunction)
Create an alias for this field.Field<T>
as(Field<?> otherField)
Create an alias for this field based on another field's name.Field<T>
as(Name alias)
Create an alias for this field.SortField<T>
asc()
Create an ascending sort field from this field.Field<Integer>
ascii()
Deprecated.Field<BigDecimal>
asin()
Deprecated.Field<BigDecimal>
atan()
Deprecated.Field<BigDecimal>
atan2(Number y)
Deprecated.Field<BigDecimal>
atan2(Field<? extends Number> y)
Deprecated.Field<BigDecimal>
avg()
Deprecated.WindowPartitionByStep<BigDecimal>
avgOver()
Deprecated.BetweenAndStep<T>
between(Field<T> minValue)
Create a condition to check this field against some bounds.Condition
between(Field<T> minValue, Field<T> maxValue)
Create a condition to check this field against some bounds.BetweenAndStep<T>
between(T minValue)
Create a condition to check this field against some bounds.Condition
between(T minValue, T maxValue)
Create a condition to check this field against some bounds.BetweenAndStep<T>
betweenSymmetric(Field<T> minValue)
Create a condition to check this field against some bounds.Condition
betweenSymmetric(Field<T> minValue, Field<T> maxValue)
Create a condition to check this field against some bounds.BetweenAndStep<T>
betweenSymmetric(T minValue)
Create a condition to check this field against some bounds.Condition
betweenSymmetric(T minValue, T maxValue)
Create a condition to check this field against some bounds.void
bind(BindContext context)
Deprecated.- 3.4.0 - [#2694] - UseQueryPartInternal.accept(Context)
instead.Field<T>
bitAnd(Field<T> value)
The bitwise and operator.Field<T>
bitAnd(T value)
The bitwise and operator.Field<Integer>
bitLength()
Deprecated.Field<T>
bitNand(Field<T> value)
The bitwise not and operator.Field<T>
bitNand(T value)
The bitwise not and operator.Field<T>
bitNor(Field<T> value)
The bitwise not or operator.Field<T>
bitNor(T value)
The bitwise not or operator.Field<T>
bitNot()
The bitwise not operator.Field<T>
bitOr(Field<T> value)
The bitwise or operator.Field<T>
bitOr(T value)
The bitwise or operator.Field<T>
bitXNor(Field<T> value)
The bitwise not xor operator.Field<T>
bitXNor(T value)
The bitwise not xor operator.Field<T>
bitXor(Field<T> value)
The bitwise xor operator.Field<T>
bitXor(T value)
The bitwise xor operator.<Z> Field<Z>
cast(Class<Z> type)
Cast this field to another type.<Z> Field<Z>
cast(DataType<Z> type)
Cast this field to a dialect-specific data type.<Z> Field<Z>
cast(Field<Z> field)
Cast this field to the type of another field.Field<T>
ceil()
Deprecated.boolean
changed(Record record)
The inverse operation ofRecord.changed(Field)
.Field<Integer>
charLength()
Deprecated.Clause[]
clauses(Context<?> ctx)
TheClause
s that are represented by this query part.Field<T>
coalesce(Field<T> option, Field<?>... options)
Deprecated.Field<T>
coalesce(T option, T... options)
Deprecated.<Z> Field<Z>
coerce(Class<Z> type)
Coerce this field to another type.<Z> Field<Z>
coerce(DataType<Z> type)
Coerce this field to a dialect-specific data type.<Z> Field<Z>
coerce(Field<Z> field)
Coerce this field to the type of another field.Field<String>
collate(String collation)
Apply a collation operator to this column expression.Field<String>
collate(Collation collation)
Apply a collation operator to this column expression.Field<String>
collate(Name collation)
Apply a collation operator to this column expression.Condition
compare(Comparator comparator, Field<T> field)
Compare this field with another field using a dynamic comparator.Condition
compare(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query)
Compare this field with a quantified subselect using a dynamic comparator.Condition
compare(Comparator comparator, Select<? extends Record1<T>> query)
Compare this field with a subselect using a dynamic comparator.Condition
compare(Comparator comparator, T value)
Compare this field with a value using a dynamic comparator.Field<String>
concat(char... values)
This method is part of the pre-2.0 API.Field<String>
concat(String... values)
Deprecated.Field<String>
concat(Field<?>... fields)
Deprecated.Condition
contains(Field<T> value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.Condition
contains(T value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.Condition
containsIgnoreCase(Field<T> value)
Convenience method forField.likeIgnoreCase(String, char)
including proper adding of wildcards and escaping.Condition
containsIgnoreCase(T value)
Convenience method forField.likeIgnoreCase(String, char)
including proper adding of wildcards and escaping.Field<BigDecimal>
cos()
Deprecated.Field<BigDecimal>
cosh()
Deprecated.Field<BigDecimal>
cot()
Deprecated.Field<BigDecimal>
coth()
Deprecated.Field<Integer>
count()
Deprecated.Field<Integer>
countDistinct()
Deprecated.WindowPartitionByStep<Integer>
countOver()
Deprecated.protected DSLContext
create()
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.protected DSLContext
create(Configuration configuration)
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.protected DSLContext
create(Context<?> ctx)
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.boolean
declaresCTE()
Subclasses may override thisboolean
declaresFields()
Subclasses may override thisboolean
declaresTables()
Subclasses may override thisboolean
declaresWindows()
Subclasses may override this<Z> Field<Z>
decode(Field<T> search, Field<Z> result)
Deprecated.<Z> Field<Z>
decode(Field<T> search, Field<Z> result, Field<?>... more)
Deprecated.<Z> Field<Z>
decode(T search, Z result)
Deprecated.<Z> Field<Z>
decode(T search, Z result, Object... more)
Deprecated.Field<BigDecimal>
deg()
Deprecated.SortField<T>
desc()
Create a descending sort field from this field.Field<T>
div(Number value)
An arithmetic expression dividing this by value.Field<T>
div(Field<? extends Number> value)
An arithmetic expression dividing this by value.Field<T>
divide(Number value)
An alias forField.div(Number)
.Field<T>
divide(Field<? extends Number> value)
An alias forField.div(Field)
.Condition
endsWith(Field<T> value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.Condition
endsWith(T value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.Condition
endsWithIgnoreCase(Field<T> value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.Condition
endsWithIgnoreCase(T value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.Condition
eq(Field<T> field)
this = field
.Condition
eq(QuantifiedSelect<? extends Record1<T>> query)
this = [quantifier] (Select<?> ...)
.Condition
eq(Select<? extends Record1<T>> query)
this = (Select<?> ...)
.Condition
eq(T value)
this = value
.Condition
equal(Field<T> field)
this = field
.Condition
equal(QuantifiedSelect<? extends Record1<T>> query)
this = [quantifier] (Select<?> ...)
.Condition
equal(Select<? extends Record1<T>> query)
this = (Select<?> ...)
.Condition
equal(T value)
this = value
.Condition
equalIgnoreCase(String value)
lower(this) = lower(value)
.Condition
equalIgnoreCase(Field<String> value)
lower(this) = lower(value)
.boolean
equals(Object that)
Check whether thisQueryPart
can be considered equal to anotherQueryPart
.Field<BigDecimal>
exp()
Deprecated.Field<Integer>
extract(DatePart datePart)
Deprecated.Field<T>
field(Record record)
The inverse operation ofRecord.field(Field)
.WindowIgnoreNullsStep<T>
firstValue()
Deprecated.Field<T>
floor()
Deprecated.Record1<T>
from(Record record)
The inverse operation ofRecord.into(Field)
.Condition
ge(Field<T> field)
this >= field
.Condition
ge(QuantifiedSelect<? extends Record1<T>> query)
this >= [quantifier] (Select<?> ...)
.Condition
ge(Select<? extends Record1<T>> query)
this >= (Select<?> ...)
.Condition
ge(T value)
this >= value
.boolean
generatesCast()
Subclasses may override thisT
get(Record record)
The inverse operation ofRecord.get(Field)
.Binding<?,T>
getBinding()
The field's underlyingBinding
.String
getComment()
The comment on this object.Converter<?,T>
getConverter()
The field's underlyingConverter
.DataType<T>
getDataType()
The type of this field (might not be dialect-specific).DataType<T>
getDataType(Configuration configuration)
The dialect-specific type of this field.String
getName()
The unqualified name of this object.Name
getQualifiedName()
The qualified name of this object.Class<T>
getType()
The Java type of the field.Name
getUnqualifiedName()
The unqualified name of this object.T
getValue(Record record)
The inverse operation ofRecord.getValue(Field)
.Condition
greaterOrEqual(Field<T> field)
this >= field
.Condition
greaterOrEqual(QuantifiedSelect<? extends Record1<T>> query)
this >= [quantifier] (Select<?> ...)
.Condition
greaterOrEqual(Select<? extends Record1<T>> query)
this >= (Select<?> ...)
.Condition
greaterOrEqual(T value)
this >= value
.Condition
greaterThan(Field<T> field)
this > field
.Condition
greaterThan(QuantifiedSelect<? extends Record1<T>> query)
this > [quantifier] (Select<?> ...)
.Condition
greaterThan(Select<? extends Record1<T>> query)
this > (Select<?> ...)
.Condition
greaterThan(T value)
this > value
.Field<T>
greatest(Field<?>... others)
Deprecated.Field<T>
greatest(T... others)
Deprecated.Condition
gt(Field<T> field)
this > field
.Condition
gt(QuantifiedSelect<? extends Record1<T>> query)
this > [quantifier] (Select<?> ...)
.Condition
gt(Select<? extends Record1<T>> query)
this > (Select<?> ...)
.Condition
gt(T value)
this > value
.int
hashCode()
Generate a hash code from thisQueryPart
.Condition
in(Collection<?> values)
Create a condition to check this field against several values.Condition
in(Field<?>... values)
Create a condition to check this field against several values.Condition
in(Result<? extends Record1<T>> result)
Create a condition to check this field against several values from a previous query.Condition
in(Select<? extends Record1<T>> query)
Create a condition to check this field against a subquery.Condition
in(T... values)
Create a condition to check this field against several values.Condition
isDistinctFrom(Field<T> field)
Create a condition to check if this field isDISTINCT
from another field.Condition
isDistinctFrom(T value)
Create a condition to check if this field isDISTINCT
from another value.Condition
isFalse()
Create a condition to check this field against known string literals forfalse
.Condition
isJson()
Create a condition to check if this field contains JSON data.Condition
isNotDistinctFrom(Field<T> field)
Create a condition to check if this field isNOT DISTINCT
from another field.Condition
isNotDistinctFrom(T value)
Create a condition to check if this field isNOT DISTINCT
from another value.Condition
isNotJson()
Create a condition to check if this field does not contain JSON data.Condition
isNotNull()
Create a condition to check this field againstnull
.Condition
isNull()
Create a condition to check this field againstnull
.Condition
isTrue()
Create a condition to check this field against known string literals fortrue
.WindowIgnoreNullsStep<T>
lag()
Deprecated.WindowIgnoreNullsStep<T>
lag(int offset)
Deprecated.WindowIgnoreNullsStep<T>
lag(int offset, Field<T> defaultValue)
Deprecated.WindowIgnoreNullsStep<T>
lag(int offset, T defaultValue)
Deprecated.WindowIgnoreNullsStep<T>
lastValue()
Deprecated.Condition
le(Field<T> field)
this <= field
.Condition
le(QuantifiedSelect<? extends Record1<T>> query)
this <= [quantifier] (Select<?> ...)
.Condition
le(Select<? extends Record1<T>> query)
this <= (Select<?> ...)
.Condition
le(T value)
this <= value
.WindowIgnoreNullsStep<T>
lead()
Deprecated.WindowIgnoreNullsStep<T>
lead(int offset)
Deprecated.WindowIgnoreNullsStep<T>
lead(int offset, Field<T> defaultValue)
Deprecated.WindowIgnoreNullsStep<T>
lead(int offset, T defaultValue)
Deprecated.Field<T>
least(Field<?>... others)
Deprecated.Field<T>
least(T... others)
Deprecated.Field<Integer>
length()
Deprecated.Condition
lessOrEqual(Field<T> field)
this <= field
.Condition
lessOrEqual(QuantifiedSelect<? extends Record1<T>> query)
this <= [quantifier] (Select<?> ...)
.Condition
lessOrEqual(Select<? extends Record1<T>> query)
this <= (Select<?> ...)
.Condition
lessOrEqual(T value)
this <= value
.Condition
lessThan(Field<T> field)
this < field
.Condition
lessThan(QuantifiedSelect<? extends Record1<T>> query)
this < [quantifier] (Select<?> ...)
.Condition
lessThan(Select<? extends Record1<T>> query)
this < (Select<?> ...)
.Condition
lessThan(T value)
this < value
.LikeEscapeStep
like(String value)
Create a condition to pattern-check this field against a value.Condition
like(String value, char escape)
Create a condition to pattern-check this field against a value.LikeEscapeStep
like(Field<String> field)
Create a condition to pattern-check this field against a value.Condition
like(Field<String> field, char escape)
Create a condition to pattern-check this field against a value.LikeEscapeStep
like(QuantifiedSelect<Record1<String>> query)
Create a condition to pattern-check this field against a quantified select.LikeEscapeStep
likeIgnoreCase(String value)
Create a condition to case-insensitively pattern-check this field against a value.Condition
likeIgnoreCase(String value, char escape)
Create a condition to case-insensitively pattern-check this field against a value.LikeEscapeStep
likeIgnoreCase(Field<String> field)
Create a condition to case-insensitively pattern-check this field against a field.Condition
likeIgnoreCase(Field<String> field, char escape)
Create a condition to case-insensitively pattern-check this field against a field.Condition
likeRegex(String pattern)
Create a condition to regex-pattern-check this field against a pattern.Condition
likeRegex(Field<String> pattern)
Create a condition to regex-pattern-check this field against a pattern.Field<BigDecimal>
ln()
Deprecated.Field<BigDecimal>
log(int base)
Deprecated.Field<String>
lower()
Deprecated.Field<String>
lpad(int length)
Deprecated.Field<String>
lpad(int length, char character)
Deprecated.Field<String>
lpad(Field<? extends Number> length)
Deprecated.Field<String>
lpad(Field<? extends Number> length, Field<String> character)
Deprecated.Condition
lt(Field<T> field)
this < field
.Condition
lt(QuantifiedSelect<? extends Record1<T>> query)
this < [quantifier] (Select<?> ...)
.Condition
lt(Select<? extends Record1<T>> query)
this < (Select<?> ...)
.Condition
lt(T value)
this < value
.Field<String>
ltrim()
Deprecated.Field<T>
max()
Deprecated.WindowPartitionByStep<T>
maxOver()
Deprecated.Field<BigDecimal>
median()
Deprecated.Field<T>
min()
Deprecated.WindowPartitionByStep<T>
minOver()
Deprecated.Field<T>
minus(Number value)
An alias forField.sub(Number)
.Field<T>
minus(Field<?> value)
An alias forField.sub(Field)
.Field<T>
mod(Number value)
An arithmetic expression getting the modulo of this divided by value.Field<T>
mod(Field<? extends Number> value)
An arithmetic expression getting the modulo of this divided by value.Field<T>
modulo(Number value)
An alias forField.mod(Number)
.Field<T>
modulo(Field<? extends Number> value)
An alias forField.mod(Field)
.Field<T>
mul(Number value)
An arithmetic expression multiplying this with value.Field<T>
mul(Field<? extends Number> value)
This default implementation is known to be overridden byExpression
to generate neater expressionsField<T>
multiply(Number value)
An alias forField.mul(Number)
.Field<T>
multiply(Field<? extends Number> value)
An alias forField.mul(Field)
.Condition
ne(Field<T> field)
this != field
.Condition
ne(QuantifiedSelect<? extends Record1<T>> query)
this != [quantifier] (Select<?> ...)
.Condition
ne(Select<? extends Record1<T>> query)
this != (Select<?> ...)
.Condition
ne(T value)
this != value
.Field<T>
neg()
Negate this field to get its negative value.BetweenAndStep<T>
notBetween(Field<T> minValue)
Create a condition to check this field against some bounds.Condition
notBetween(Field<T> minValue, Field<T> maxValue)
Create a condition to check this field against some bounds.BetweenAndStep<T>
notBetween(T minValue)
Create a condition to check this field against some bounds.Condition
notBetween(T minValue, T maxValue)
Create a condition to check this field against some bounds.BetweenAndStep<T>
notBetweenSymmetric(Field<T> minValue)
Create a condition to check this field against some bounds.Condition
notBetweenSymmetric(Field<T> minValue, Field<T> maxValue)
Create a condition to check this field against some bounds.BetweenAndStep<T>
notBetweenSymmetric(T minValue)
Create a condition to check this field against some bounds.Condition
notBetweenSymmetric(T minValue, T maxValue)
Create a condition to check this field against some bounds.Condition
notContains(Field<T> value)
Inverse ofField.contains(Field)
.Condition
notContains(T value)
Inverse ofField.contains(Object)
.Condition
notContainsIgnoreCase(Field<T> value)
Inverse ofField.containsIgnoreCase(Field)
Condition
notContainsIgnoreCase(T value)
Inverse ofField.containsIgnoreCase(Object)
Condition
notEqual(Field<T> field)
this != field
.Condition
notEqual(QuantifiedSelect<? extends Record1<T>> query)
this != [quantifier] (Select<?> ...)
.Condition
notEqual(Select<? extends Record1<T>> query)
this != (Select<?> ...)
.Condition
notEqual(T value)
this != value
.Condition
notEqualIgnoreCase(String value)
lower(this) != lower(value)
.Condition
notEqualIgnoreCase(Field<String> value)
lower(this) != lower(value)
.Condition
notIn(Collection<?> values)
Create a condition to check this field against several values.Condition
notIn(Field<?>... values)
Create a condition to check this field against several values.Condition
notIn(Result<? extends Record1<T>> result)
Create a condition to check this field against several values from a previous query.Condition
notIn(Select<? extends Record1<T>> query)
Create a condition to check this field against a subquery.Condition
notIn(T... values)
Create a condition to check this field against several values.LikeEscapeStep
notLike(String value)
Create a condition to pattern-check this field against a value.Condition
notLike(String value, char escape)
Create a condition to pattern-check this field against a value.LikeEscapeStep
notLike(Field<String> field)
Create a condition to pattern-check this field against a field.Condition
notLike(Field<String> field, char escape)
Create a condition to pattern-check this field against a field.LikeEscapeStep
notLike(QuantifiedSelect<Record1<String>> query)
Create a condition to pattern-check this field against a quantified select.LikeEscapeStep
notLikeIgnoreCase(String value)
Create a condition to case-insensitively pattern-check this field against a value.Condition
notLikeIgnoreCase(String value, char escape)
Create a condition to case-insensitively pattern-check this field against a value.LikeEscapeStep
notLikeIgnoreCase(Field<String> field)
Create a condition to case-insensitively pattern-check this field against a field.Condition
notLikeIgnoreCase(Field<String> field, char escape)
Create a condition to case-insensitively pattern-check this field against a field.Condition
notLikeRegex(String pattern)
Create a condition to regex-pattern-check this field against a pattern.Condition
notLikeRegex(Field<String> pattern)
Create a condition to regex-pattern-check this field against a pattern.LikeEscapeStep
notSimilarTo(String value)
Create a condition to pattern-check this field against a value.Condition
notSimilarTo(String value, char escape)
Create a condition to pattern-check this field against a value.LikeEscapeStep
notSimilarTo(Field<String> field)
Create a condition to pattern-check this field against a field.Condition
notSimilarTo(Field<String> field, char escape)
Create a condition to pattern-check this field against a field.Field<T>
nullif(Field<T> other)
Deprecated.Field<T>
nullif(T other)
Deprecated.Field<T>
nvl(Field<T> defaultValue)
Deprecated.Field<T>
nvl(T defaultValue)
Deprecated.<Z> Field<Z>
nvl2(Field<Z> valueIfNotNull, Field<Z> valueIfNull)
Deprecated.<Z> Field<Z>
nvl2(Z valueIfNotNull, Z valueIfNull)
Deprecated.Field<Integer>
octetLength()
Deprecated.T
original(Record record)
The inverse operation ofRecord.original(Field)
.Field<T>
plus()
Turn this field into an Oracle-specific field for use in outer-join predicates.Field<T>
plus(Number value)
An alias forField.add(Number)
.Field<T>
plus(Field<?> value)
An alias forField.add(Field)
.Field<Integer>
position(String search)
Deprecated.Field<Integer>
position(Field<String> search)
Deprecated.Field<BigDecimal>
pow(Number exponent)
An arithmetic expression getting this value raised to the power ofexponent
.Field<BigDecimal>
pow(Field<? extends Number> exponent)
An arithmetic expression getting this value raised to the power ofexponent
.Field<BigDecimal>
power(Number exponent)
An alias forField.power(Number)
.Field<BigDecimal>
power(Field<? extends Number> exponent)
An alias forField.power(Field)
.Field<BigDecimal>
rad()
Deprecated.Field<T>
rem(Number value)
An alias forField.mod(Number)
.Field<T>
rem(Field<? extends Number> value)
An alias forField.mod(Field)
.Field<String>
repeat(Number count)
Deprecated.Field<String>
repeat(Field<? extends Number> count)
Deprecated.Field<String>
replace(String search)
Deprecated.Field<String>
replace(String search, String replace)
Deprecated.Field<String>
replace(Field<String> search)
Deprecated.Field<String>
replace(Field<String> search, Field<String> replace)
Deprecated.void
reset(Record record)
The inverse operation ofRecord.reset(Field)
.Field<T>
round()
Deprecated.Field<T>
round(int decimals)
Deprecated.Field<String>
rpad(int length)
Deprecated.Field<String>
rpad(int length, char character)
Deprecated.Field<String>
rpad(Field<? extends Number> length)
Deprecated.Field<String>
rpad(Field<? extends Number> length, Field<String> character)
Deprecated.Field<String>
rtrim()
Deprecated.Field<T>
shl(Number value)
The bitwise left shift operator.Field<T>
shl(Field<? extends Number> value)
The bitwise left shift operator.Field<T>
shr(Number value)
The bitwise right shift operator.Field<T>
shr(Field<? extends Number> value)
The bitwise right shift operator.Field<Integer>
sign()
Deprecated.LikeEscapeStep
similarTo(String value)
Create a condition to pattern-check this field against a value.Condition
similarTo(String value, char escape)
Create a condition to pattern-check this field against a value.LikeEscapeStep
similarTo(Field<String> field)
Create a condition to pattern-check this field against a value.Condition
similarTo(Field<String> field, char escape)
Create a condition to pattern-check this field against a value.Field<BigDecimal>
sin()
Deprecated.Field<BigDecimal>
sinh()
Deprecated.<Z> SortField<Z>
sort(Map<T,Z> sortMap)
Create an indirected sort field.SortField<T>
sort(SortOrder order)
Create an ascending/descending sort field from this field.SortField<Integer>
sortAsc(Collection<T> sortList)
Create an indirected sort field.SortField<Integer>
sortAsc(T... sortList)
Create an indirected sort field.SortField<T>
sortDefault()
Create a default sorted (implicitASC
) from this field.SortField<Integer>
sortDesc(Collection<T> sortList)
Create an indirected sort field.SortField<Integer>
sortDesc(T... sortList)
Create an indirected sort field.Field<BigDecimal>
sqrt()
Deprecated.Condition
startsWith(Field<T> value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.Condition
startsWith(T value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.Condition
startsWithIgnoreCase(Field<T> value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.Condition
startsWithIgnoreCase(T value)
Convenience method forField.like(String, char)
including proper adding of wildcards and escaping.Field<BigDecimal>
stddevPop()
Deprecated.WindowPartitionByStep<BigDecimal>
stddevPopOver()
Deprecated.Field<BigDecimal>
stddevSamp()
Deprecated.WindowPartitionByStep<BigDecimal>
stddevSampOver()
Deprecated.Field<T>
sub(Number value)
An arithmetic expression subtracting value from this.Field<T>
sub(Field<?> value)
An arithmetic expression subtracting value from this.Field<String>
substring(int startingPosition)
Deprecated.Field<String>
substring(int startingPosition, int length)
Deprecated.Field<String>
substring(Field<? extends Number> startingPosition)
Deprecated.Field<String>
substring(Field<? extends Number> startingPosition, Field<? extends Number> length)
Deprecated.Field<T>
subtract(Number value)
An alias forField.sub(Number)
.Field<T>
subtract(Field<?> value)
An alias forField.sub(Field)
.Field<BigDecimal>
sum()
Deprecated.WindowPartitionByStep<BigDecimal>
sumOver()
Deprecated.Field<BigDecimal>
tan()
Deprecated.Field<BigDecimal>
tanh()
Deprecated.Field<T>
times(Number value)
An alias forField.mul(Number)
.Field<T>
times(Field<? extends Number> value)
An alias forField.mul(Field)
.void
toSQL(RenderContext context)
Deprecated.- 3.4.0 - [#2694] - UseQueryPartInternal.accept(Context)
instead.String
toString()
Render a SQL string representation of thisQueryPart
.protected DataAccessException
translate(String sql, SQLException e)
Internal convenience methodField<String>
trim()
Deprecated.Field<T>
unaryMinus()
Negate this field to get its negative value.Field<T>
unaryPlus()
Get this field as its positive value (no effect on SQL).Field<String>
upper()
Deprecated.Field<BigDecimal>
varPop()
Deprecated.WindowPartitionByStep<BigDecimal>
varPopOver()
Deprecated.Field<BigDecimal>
varSamp()
Deprecated.WindowPartitionByStep<BigDecimal>
varSampOver()
Deprecated.-
Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
-
Methods inherited from interface org.jooq.Field
equals, getComment, getName
-
Methods inherited from interface org.jooq.Named
getQualifiedName, getUnqualifiedName
-
-
-
-
Method Detail
-
accept
public final void accept(Context<?> ctx)
Description copied from interface:QueryPartInternal
ThisQueryPart
canaccept
aContext
object in order to render a SQL string or to bind its variables.- Specified by:
accept
in interfaceQueryPartInternal
-
clauses
public Clause[] clauses(Context<?> ctx)
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.
-
field
public final Field<T> field(Record record)
Description copied from interface:Field
The inverse operation ofRecord.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
public final T get(Record record)
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
public final T getValue(Record record)
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
public final T original(Record record)
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
public final boolean changed(Record record)
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
public final void reset(Record record)
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
public final Record1<T> from(Record record)
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);
-
as
public final Field<T> as(String alias)
Description copied from interface:Field
Create an alias for this field.Note that the case-sensitivity of the returned field depends on
Settings.getRenderQuotedNames()
. By default, field aliases are quoted, and thus case-sensitive in many SQL dialects!
-
as
public Field<T> as(Name alias)
Description copied from interface:Field
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.
-
as
public final Field<T> as(Field<?> otherField)
Description copied from interface:Field
Create an alias for this field based on another field's name.
-
as
public final Field<T> as(Function<? super Field<T>,? extends String> aliasFunction)
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
Field.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());
-
getConverter
public final Converter<?,T> getConverter()
Description copied from interface:Field
The field's underlyingConverter
.By default, all fields reference an identity-converter
Converter<T, T>
. Custom data types may be obtained by a customConverter
placed on the generatedTableField
.- Specified by:
getConverter
in interfaceField<T>
- Specified by:
getConverter
in interfaceSelectField<T>
-
getBinding
public final Binding<?,T> getBinding()
Description copied from interface:Field
The field's underlyingBinding
.- Specified by:
getBinding
in interfaceField<T>
- Specified by:
getBinding
in interfaceSelectField<T>
-
getDataType
public final DataType<T> getDataType()
Description copied from interface:Field
The type of this field (might not be dialect-specific).- Specified by:
getDataType
in interfaceField<T>
- Specified by:
getDataType
in interfaceSelectField<T>
-
getDataType
public final DataType<T> getDataType(Configuration configuration)
Description copied from interface:Field
The dialect-specific type of this field.- Specified by:
getDataType
in interfaceField<T>
- Specified by:
getDataType
in interfaceSelectField<T>
-
getType
public final Class<T> getType()
Description copied from interface:Field
The Java type of the field.- Specified by:
getType
in interfaceField<T>
- Specified by:
getType
in interfaceSelectField<T>
-
cast
public final <Z> Field<Z> cast(Field<Z> field)
Description copied from interface:Field
Cast this field to the type of another field.This results in the same as casting this field to
DataType.getCastTypeName()
- Specified by:
cast
in 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
public final <Z> Field<Z> cast(DataType<Z> type)
Description copied from interface:Field
Cast this field to a dialect-specific data type.
-
cast
public final <Z> Field<Z> cast(Class<Z> type)
Description copied from interface:Field
Cast this field to another type.The actual cast may not be accurate as the
DataType
has to be "guessed" from the jOOQ-configured data types. 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
public final <Z> Field<Z> coerce(Field<Z> field)
Description copied from interface:Field
Coerce this field to the type of another field.Unlike with casting, coercing doesn't affect the way the database sees a
Field
's type. This is how coercing affects your SQL:Bind values
// This binds an int value to a JDBC PreparedStatement DSL.val(1).coerce(String.class); // This binds an int value to a JDBC PreparedStatement // and casts it to VARCHAR in SQL DSL.val(1).cast(String.class);
Other Field types
// This fetches a String value for the BOOK.ID field from JDBC BOOK.ID.coerce(String.class); // This fetches a String value for the BOOK.ID field from JDBC // after casting it to VARCHAR in the database BOOK.ID.cast(String.class);
- Specified by:
coerce
in 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
public final <Z> Field<Z> coerce(DataType<Z> type)
Description copied from interface:Field
Coerce this field to a dialect-specific data type.Unlike with casting, coercing doesn't affect the way the database sees a
Field
's type. This is how coercing affects your SQL:Bind values
// This binds an int value to a JDBC PreparedStatement DSL.val(1).coerce(String.class); // This binds an int value to a JDBC PreparedStatement // and casts it to VARCHAR in SQL DSL.val(1).cast(String.class);
Other Field types
// This fetches a String value for the BOOK.ID field from JDBC BOOK.ID.coerce(String.class); // This fetches a String value for the BOOK.ID field from JDBC // after casting it to VARCHAR in the database BOOK.ID.cast(String.class);
- Specified by:
coerce
in 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
public final <Z> Field<Z> coerce(Class<Z> type)
Description copied from interface:Field
Coerce this field to another type.Unlike with casting, coercing doesn't affect the way the database sees a
Field
's type. This is how coercing affects your SQL:Bind values
// This binds an int value to a JDBC PreparedStatement DSL.val(1).coerce(String.class); // This binds an int value to a JDBC PreparedStatement // and casts it to VARCHAR in SQL DSL.val(1).cast(String.class);
Other Field types
// This fetches a String value for the BOOK.ID field from JDBC BOOK.ID.coerce(String.class); // This fetches a String value for the BOOK.ID field from JDBC // after casting it to VARCHAR in the database BOOK.ID.cast(String.class);
- Specified by:
coerce
in 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
public final SortField<T> asc()
Description copied from interface:Field
Create an ascending sort field from this field.This is the same as calling
Field.sort(SortOrder)
withSortOrder.ASC
-
desc
public final SortField<T> desc()
Description copied from interface:Field
Create a descending sort field from this field.This is the same as calling
Field.sort(SortOrder)
withSortOrder.DESC
-
sortDefault
public final SortField<T> 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
public final SortField<T> sort(SortOrder order)
Description copied from interface:Field
Create an ascending/descending sort field from this field.
-
sortAsc
public final SortField<Integer> sortAsc(Collection<T> sortList)
Description copied from interface:Field
Create an indirected sort field.Create a sort field of the form
CASE [this] WHEN [sortList.get(0)] THEN 0 WHEN [sortList.get(1)] THEN 1 ... WHEN [sortList.get(n)] THEN n ELSE null END ASC
Note: You can use this in combination with
SortField.nullsFirst()
orSortField.nullsLast()
to specify whether the default should have highest or lowest priority.
-
sortAsc
@SafeVarargs public final SortField<Integer> sortAsc(T... sortList)
Description copied from interface:Field
Create an indirected sort field.Create a sort field of the form
CASE [this] WHEN [sortList[0]] THEN 0 WHEN [sortList[1]] THEN 1 ... WHEN [sortList[n]] THEN n ELSE null END ASC
Note: You can use this in combination with
SortField.nullsFirst()
orSortField.nullsLast()
to specify whether the default should have highest or lowest priority.
-
sortDesc
public final SortField<Integer> sortDesc(Collection<T> sortList)
Description copied from interface:Field
Create an indirected sort field.Create a sort field of the form
CASE [this] WHEN [sortList.get(0)] THEN 0 WHEN [sortList.get(1)] THEN 1 ... WHEN [sortList.get(n)] THEN n ELSE null END DESC
Note: You can use this in combination with
SortField.nullsFirst()
orSortField.nullsLast()
to specify whether the default should have highest or lowest priority.
-
sortDesc
@SafeVarargs public final SortField<Integer> sortDesc(T... sortList)
Description copied from interface:Field
Create an indirected sort field.Create a sort field of the form
CASE [this] WHEN [sortList[0]] THEN 0 WHEN [sortList[1]] THEN 1 ... WHEN [sortList[n]] THEN n ELSE null END DESC
Note: You can use this in combination with
SortField.nullsFirst()
orSortField.nullsLast()
to specify whether the default should have highest or lowest priority.
-
sort
public final <Z> SortField<Z> sort(Map<T,Z> sortMap)
Description copied from interface:Field
Create an indirected sort field.Create a sort field of the form (in pseudo code)
CASE [this] WHEN [sortMap.key(0)] THEN sortMap.value(0) WHEN [sortMap.key(1)] THEN sortMap.value(1) ... WHEN [sortMap.key(n)] THEN sortMap.value(n) ELSE null END DESC
Note: You can use this in combination with
SortField.nullsFirst()
orSortField.nullsLast()
to specify whether the default should have highest or lowest priority.
-
neg
public final Field<T> neg()
Description copied from interface:Field
Negate this field to get its negative value.This renders the same on all dialects:
-[this]
-
unaryMinus
public final Field<T> 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
public final Field<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
public final Field<T> add(Number value)
Description copied from interface:Field
An arithmetic expression adding this to value.- Specified by:
add
in interfaceField<T>
- See Also:
Field.add(Field)
-
add
public Field<T> add(Field<?> value)
Description copied from interface:Field
An arithmetic expression to add value to this.The behaviour of this operation is as follows:
Operand 1 Operand 2 Result Type Numeric Numeric Numeric Date / Time Numeric Date / Time Date / Time Interval Date / Time Interval Interval Interval
-
sub
public final Field<T> sub(Number value)
Description copied from interface:Field
An arithmetic expression subtracting value from this.- Specified by:
sub
in interfaceField<T>
- See Also:
Field.sub(Field)
-
sub
public final Field<T> sub(Field<?> value)
Description copied from interface:Field
An arithmetic expression subtracting value from this.Operand 1 Operand 2 Result Type Numeric Numeric Numeric Date / Time Numeric Date / Time Date / Time Interval Date / Time Interval Interval Interval In order to subtract one date time field from another, use any of these methods:
-
mul
public final Field<T> mul(Number value)
Description copied from interface:Field
An arithmetic expression multiplying this with value.- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an
INTERVAL
field, then the result is also anINTERVAL
field (seeInterval
)
-
mul
public Field<T> mul(Field<? extends Number> value)
This default implementation is known to be overridden byExpression
to generate neater expressions
-
div
public final Field<T> div(Number value)
Description copied from interface:Field
An arithmetic expression dividing this by value.- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an
INTERVAL
field, then the result is also anINTERVAL
field (seeInterval
)
-
div
public final Field<T> div(Field<? extends Number> value)
Description copied from interface:Field
An arithmetic expression dividing this by value.- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an
INTERVAL
field, then the result is also anINTERVAL
field (seeInterval
)
-
mod
public final Field<T> mod(Number value)
Description copied from interface:Field
An arithmetic expression getting the modulo of this divided by value.This renders the modulo operation where available:
... or the modulo function elsewhere:[this] % [value]
mod([this], [value])
-
mod
public final Field<T> mod(Field<? extends Number> value)
Description copied from interface:Field
An arithmetic expression getting the modulo of this divided by value.This renders the modulo operation where available:
... or the modulo function elsewhere:[this] % [value]
mod([this], [value])
-
plus
public final Field<T> plus(Number value)
Description copied from interface:Field
An alias forField.add(Number)
.- Specified by:
plus
in interfaceField<T>
- See Also:
Field.add(Number)
-
plus
public final Field<T> plus(Field<?> value)
Description copied from interface:Field
An alias forField.add(Field)
.- Specified by:
plus
in interfaceField<T>
- See Also:
Field.add(Field)
-
subtract
public final Field<T> subtract(Number value)
Description copied from interface:Field
An alias forField.sub(Number)
.- Specified by:
subtract
in interfaceField<T>
- See Also:
Field.sub(Number)
-
subtract
public final Field<T> subtract(Field<?> value)
Description copied from interface:Field
An alias forField.sub(Field)
.- Specified by:
subtract
in interfaceField<T>
- See Also:
Field.sub(Field)
-
minus
public final Field<T> minus(Number value)
Description copied from interface:Field
An alias forField.sub(Number)
.- Specified by:
minus
in interfaceField<T>
- See Also:
Field.sub(Number)
-
minus
public final Field<T> minus(Field<?> value)
Description copied from interface:Field
An alias forField.sub(Field)
.- Specified by:
minus
in interfaceField<T>
- See Also:
Field.sub(Field)
-
multiply
public final Field<T> multiply(Number value)
Description copied from interface:Field
An alias forField.mul(Number)
.- Specified by:
multiply
in interfaceField<T>
- See Also:
Field.mul(Number)
-
multiply
public final Field<T> multiply(Field<? extends Number> value)
Description copied from interface:Field
An alias forField.mul(Field)
.- Specified by:
multiply
in interfaceField<T>
- See Also:
Field.mul(Field)
-
times
public final Field<T> times(Number value)
Description copied from interface:Field
An alias forField.mul(Number)
.- Specified by:
times
in interfaceField<T>
- See Also:
Field.mul(Number)
-
times
public final Field<T> times(Field<? extends Number> value)
Description copied from interface:Field
An alias forField.mul(Field)
.- Specified by:
times
in interfaceField<T>
- See Also:
Field.mul(Field)
-
divide
public final Field<T> divide(Number value)
Description copied from interface:Field
An alias forField.div(Number)
.- Specified by:
divide
in interfaceField<T>
- See Also:
Field.div(Number)
-
divide
public final Field<T> divide(Field<? extends Number> value)
Description copied from interface:Field
An alias forField.div(Field)
.- Specified by:
divide
in interfaceField<T>
- See Also:
Field.div(Field)
-
modulo
public final Field<T> modulo(Number value)
Description copied from interface:Field
An alias forField.mod(Number)
.- Specified by:
modulo
in interfaceField<T>
- See Also:
Field.mod(Number)
-
modulo
public final Field<T> modulo(Field<? extends Number> value)
Description copied from interface:Field
An alias forField.mod(Field)
.- Specified by:
modulo
in interfaceField<T>
- See Also:
Field.mod(Field)
-
rem
public final Field<T> rem(Number value)
Description copied from interface:Field
An alias forField.mod(Number)
.- Specified by:
rem
in interfaceField<T>
- See Also:
Field.mod(Number)
-
rem
public final Field<T> rem(Field<? extends Number> value)
Description copied from interface:Field
An alias forField.mod(Field)
.- Specified by:
rem
in interfaceField<T>
- See Also:
Field.mod(Field)
-
bitNot
public final Field<T> bitNot()
Description copied from interface:Field
The bitwise not operator.- Specified by:
bitNot
in interfaceField<T>
- See Also:
DSL.bitNot(Field)
-
bitAnd
public final Field<T> bitAnd(T value)
Description copied from interface:Field
The bitwise and operator.- Specified by:
bitAnd
in interfaceField<T>
- See Also:
DSL.bitAnd(Field, Field)
-
bitAnd
public final Field<T> bitAnd(Field<T> value)
Description copied from interface:Field
The bitwise and operator.- Specified by:
bitAnd
in interfaceField<T>
- See Also:
DSL.bitAnd(Field, Field)
-
bitNand
public final Field<T> bitNand(T value)
Description copied from interface:Field
The bitwise not and operator.- Specified by:
bitNand
in interfaceField<T>
- See Also:
DSL.bitNand(Field, Field)
,DSL.bitNot(Field)
-
bitNand
public final Field<T> bitNand(Field<T> value)
Description copied from interface:Field
The bitwise not and operator.- Specified by:
bitNand
in interfaceField<T>
- See Also:
DSL.bitNand(Field, Field)
,DSL.bitNot(Field)
-
bitOr
public final Field<T> bitOr(T value)
Description copied from interface:Field
The bitwise or operator.- Specified by:
bitOr
in interfaceField<T>
- See Also:
DSL.bitOr(Field, Field)
-
bitOr
public final Field<T> bitOr(Field<T> value)
Description copied from interface:Field
The bitwise or operator.- Specified by:
bitOr
in interfaceField<T>
- See Also:
DSL.bitOr(Field, Field)
-
bitNor
public final Field<T> bitNor(T value)
Description copied from interface:Field
The bitwise not or operator.- Specified by:
bitNor
in interfaceField<T>
- See Also:
DSL.bitNor(Field, Field)
,DSL.bitNot(Field)
-
bitNor
public final Field<T> bitNor(Field<T> value)
Description copied from interface:Field
The bitwise not or operator.- Specified by:
bitNor
in interfaceField<T>
- See Also:
DSL.bitNor(Field, Field)
,DSL.bitNot(Field)
-
bitXor
public final Field<T> bitXor(T value)
Description copied from interface:Field
The bitwise xor operator.- Specified by:
bitXor
in interfaceField<T>
- See Also:
DSL.bitXor(Field, Field)
-
bitXor
public final Field<T> bitXor(Field<T> value)
Description copied from interface:Field
The bitwise xor operator.- Specified by:
bitXor
in interfaceField<T>
- See Also:
DSL.bitXor(Field, Field)
-
bitXNor
public final Field<T> bitXNor(T value)
Description copied from interface:Field
The bitwise not xor operator.- Specified by:
bitXNor
in interfaceField<T>
- See Also:
DSL.bitXNor(Field, Field)
,DSL.bitNot(Field)
-
bitXNor
public final Field<T> bitXNor(Field<T> value)
Description copied from interface:Field
The bitwise not xor operator.- Specified by:
bitXNor
in interfaceField<T>
- See Also:
DSL.bitXNor(Field, Field)
,DSL.bitNot(Field)
-
shl
public final Field<T> shl(Number value)
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
public final Field<T> shl(Field<? extends Number> value)
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
public final Field<T> shr(Number value)
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
public final Field<T> shr(Field<? extends Number> value)
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)
-
isJson
public final Condition isJson()
Description copied from interface:Field
Create a condition to check if this field contains JSON data.
-
isNotJson
public final Condition isNotJson()
Description copied from interface:Field
Create a condition to check if this field does not contain JSON data.
-
isNull
public final Condition isNull()
Description copied from interface:Field
Create a condition to check this field againstnull
.SQL:
this is null
-
isNotNull
public final Condition isNotNull()
Description copied from interface:Field
Create a condition to check this field againstnull
.SQL:
this is not null
-
isDistinctFrom
public final Condition isDistinctFrom(T value)
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
public final Condition isDistinctFrom(Field<T> field)
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
public final Condition isNotDistinctFrom(T value)
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
public final Condition isNotDistinctFrom(Field<T> field)
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
public final Condition 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
public final Condition 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
public final LikeEscapeStep similarTo(String value)
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this similar to value
-
similarTo
public final Condition similarTo(String value, char escape)
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
public final LikeEscapeStep similarTo(Field<String> field)
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this similar to value
-
similarTo
public final Condition similarTo(Field<String> field, char escape)
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
public final LikeEscapeStep notSimilarTo(String value)
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
public final Condition notSimilarTo(String value, char escape)
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
public final LikeEscapeStep notSimilarTo(Field<String> field)
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
public final Condition notSimilarTo(Field<String> field, char escape)
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
public final LikeEscapeStep like(String value)
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this like value
-
like
public final Condition like(String value, char escape)
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this like value escape 'e'
- Specified by:
like
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
like
public final LikeEscapeStep like(Field<String> field)
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this like value
-
like
public final Condition like(Field<String> field, char escape)
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this like value escape 'e'
- Specified by:
like
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
like
public LikeEscapeStep like(QuantifiedSelect<Record1<String>> query)
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
public final LikeEscapeStep likeIgnoreCase(String value)
Description copied from interface:Field
Create a condition to case-insensitively pattern-check this field against a value.This translates to
this ilike value
inSQLDialect.POSTGRES
, or tolower(this) like lower(value)
in all other dialects.- Specified by:
likeIgnoreCase
in interfaceField<T>
-
likeIgnoreCase
public final Condition likeIgnoreCase(String value, char escape)
Description copied from interface:Field
Create a condition to case-insensitively pattern-check this field against a value.This translates to
this ilike value
inSQLDialect.POSTGRES
, or tolower(this) like lower(value)
in all other dialects.- Specified by:
likeIgnoreCase
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
likeIgnoreCase
public final LikeEscapeStep likeIgnoreCase(Field<String> field)
Description copied from interface:Field
Create a condition to case-insensitively pattern-check this field against a field.This translates to
this ilike field
inSQLDialect.POSTGRES
, or tolower(this) like lower(field)
in all other dialects.- Specified by:
likeIgnoreCase
in interfaceField<T>
-
likeIgnoreCase
public final Condition likeIgnoreCase(Field<String> field, char escape)
Description copied from interface:Field
Create a condition to case-insensitively pattern-check this field against a field.This translates to
this ilike field
inSQLDialect.POSTGRES
, or tolower(this) like lower(field)
in all other dialects.- Specified by:
likeIgnoreCase
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
likeRegex
public final Condition likeRegex(String pattern)
Description copied from interface:Field
Create a condition to regex-pattern-check this field against a pattern.The SQL:2008 standard specifies a
<regex like predicate>
of the following form:<regex like predicate> ::= <row value predicand> <regex like predicate part 2> <regex like predicate part 2> ::= [ NOT ] LIKE_REGEX <XQuery pattern> [ FLAG <XQuery option flag> ]
This particular
LIKE_REGEX
operator comes in several flavours for various databases. jOOQ supports regular expressions as follows:- Specified by:
likeRegex
in interfaceField<T>
- See Also:
Field.likeRegex(String)
-
likeRegex
public final Condition likeRegex(Field<String> pattern)
Description copied from interface:Field
Create a condition to regex-pattern-check this field against a pattern.See
Field.likeRegex(String)
for more details- Specified by:
likeRegex
in interfaceField<T>
- See Also:
Field.likeRegex(String)
-
notLike
public final LikeEscapeStep notLike(String value)
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this not like value
-
notLike
public final Condition notLike(String value, char escape)
Description copied from interface:Field
Create a condition to pattern-check this field against a value.SQL:
this not like value escape 'e'
- Specified by:
notLike
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
notLike
public final LikeEscapeStep notLike(Field<String> field)
Description copied from interface:Field
Create a condition to pattern-check this field against a field.SQL:
this not like field
-
notLike
public final Condition notLike(Field<String> field, char escape)
Description copied from interface:Field
Create a condition to pattern-check this field against a field.SQL:
this not like field escape 'e'
- Specified by:
notLike
in interfaceField<T>
- See Also:
LikeEscapeStep.escape(char)
-
notLike
public LikeEscapeStep notLike(QuantifiedSelect<Record1<String>> query)
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
public final LikeEscapeStep notLikeIgnoreCase(String value)
Description copied from interface:Field
Create a condition to case-insensitively pattern-check this field against a value.This translates to
this not ilike value
inSQLDialect.POSTGRES
, or tolower(this) not like lower(value)
in all other dialects.- Specified by:
notLikeIgnoreCase
in interfaceField<T>
-
notLikeIgnoreCase
public final Condition notLikeIgnoreCase(String value, char escape)
Description copied from interface:Field
Create a condition to case-insensitively pattern-check this field against a value.This translates to
this not ilike value
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
public final LikeEscapeStep notLikeIgnoreCase(Field<String> field)
Description copied from interface:Field
Create a condition to case-insensitively pattern-check this field against a field.This translates to
this not ilike field
inSQLDialect.POSTGRES
, or tolower(this) not like lower(field)
in all other dialects.- Specified by:
notLikeIgnoreCase
in interfaceField<T>
-
notLikeIgnoreCase
public final Condition notLikeIgnoreCase(Field<String> field, char escape)
Description copied from interface:Field
Create a condition to case-insensitively pattern-check this field against a field.This translates to
this not ilike field
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
public final Condition notLikeRegex(String pattern)
Description copied from interface:Field
Create a condition to regex-pattern-check this field against a pattern.See
Field.likeRegex(String)
for more details- Specified by:
notLikeRegex
in interfaceField<T>
- See Also:
Field.likeRegex(String)
-
notLikeRegex
public final Condition notLikeRegex(Field<String> pattern)
Description copied from interface:Field
Create a condition to regex-pattern-check this field against a pattern.See
Field.likeRegex(String)
for more details- Specified by:
notLikeRegex
in interfaceField<T>
- See Also:
Field.likeRegex(Field)
-
contains
public final Condition contains(T value)
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
public final Condition contains(Field<T> value)
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
public final Condition notContains(T value)
Description copied from interface:Field
Inverse ofField.contains(Object)
.- Specified by:
notContains
in interfaceField<T>
-
notContains
public final Condition notContains(Field<T> value)
Description copied from interface:Field
Inverse ofField.contains(Field)
.- Specified by:
notContains
in interfaceField<T>
-
containsIgnoreCase
public final Condition containsIgnoreCase(T value)
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
public final Condition containsIgnoreCase(Field<T> value)
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
public final Condition notContainsIgnoreCase(T value)
Description copied from interface:Field
Inverse ofField.containsIgnoreCase(Object)
- Specified by:
notContainsIgnoreCase
in interfaceField<T>
-
notContainsIgnoreCase
public final Condition notContainsIgnoreCase(Field<T> value)
Description copied from interface:Field
Inverse ofField.containsIgnoreCase(Field)
- Specified by:
notContainsIgnoreCase
in interfaceField<T>
-
startsWith
public final Condition startsWith(T value)
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
public final Condition startsWith(Field<T> value)
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
public final Condition startsWithIgnoreCase(T value)
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
public final Condition startsWithIgnoreCase(Field<T> value)
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
public final Condition endsWith(T value)
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
public final Condition endsWith(Field<T> value)
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
public final Condition endsWithIgnoreCase(T value)
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
public final Condition endsWithIgnoreCase(Field<T> value)
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
public final Condition in(T... values)
Description copied from interface:Field
Create a condition to check this field against several values.SQL:
this in (values...)
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
public final Condition in(Field<?>... values)
Description copied from interface:Field
Create a condition to check this field against several values.SQL:
this in (values...)
-
in
public final Condition in(Collection<?> values)
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
public final Condition in(Result<? extends Record1<T>> result)
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
public final Condition in(Select<? extends Record1<T>> query)
Description copied from interface:Field
Create a condition to check this field against a subquery.Note that the subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.
SQL:
this in (select...)
-
notIn
public final Condition notIn(T... values)
Description copied from interface:Field
Create a condition to check this field against several values.Note that if any of the passed values is
NULL
, then the condition will 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
public final Condition notIn(Field<?>... values)
Description copied from interface:Field
Create a condition to check this field against several values.Note that if any of the passed values is
NULL
, then the condition will beNULL
(orfalse
, depending on the dialect) as well. This is standard SQL behaviour.SQL:
this not in (values...)
-
notIn
public final Condition notIn(Collection<?> values)
Description copied from interface:Field
Create a condition to check this field against several values.Note that if any of the passed values is
NULL
, then the condition will 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
public final Condition notIn(Result<? extends Record1<T>> result)
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
public final Condition notIn(Select<? extends Record1<T>> query)
Description copied from interface:Field
Create a condition to check this field against a subquery.Note that the subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.
Note that if any of the passed values is
NULL
, then the condition will beNULL
(orfalse
, depending on the dialect) as well. This is standard SQL behaviour.SQL:
this not in (select...)
-
between
public final Condition between(T minValue, T maxValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.This is the same as calling
between(minValue).and(maxValue)
SQL:
this between minValue and maxValue
-
between
public final Condition between(Field<T> minValue, Field<T> maxValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.This is the same as calling
between(minValue).and(maxValue)
SQL:
this between minValue and maxValue
-
betweenSymmetric
public final Condition betweenSymmetric(T minValue, T maxValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.This is the same as calling
betweenSymmetric(minValue).and(maxValue)
SQL:
this between symmetric minValue and maxValue
- Specified by:
betweenSymmetric
in interfaceField<T>
-
betweenSymmetric
public final Condition betweenSymmetric(Field<T> minValue, Field<T> maxValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.This is the same as calling
betweenSymmetric(minValue).and(maxValue)
SQL:
this between symmetric minValue and maxValue
- Specified by:
betweenSymmetric
in interfaceField<T>
-
notBetween
public final Condition notBetween(T minValue, T maxValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.This is the same as calling
notBetween(minValue).and(maxValue)
SQL:
this not between minValue and maxValue
- Specified by:
notBetween
in interfaceField<T>
-
notBetween
public final Condition notBetween(Field<T> minValue, Field<T> maxValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.This is the same as calling
notBetween(minValue).and(maxValue)
SQL:
this not between minValue and maxValue
- Specified by:
notBetween
in interfaceField<T>
-
notBetweenSymmetric
public final Condition notBetweenSymmetric(T minValue, T maxValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.This is the same as calling
notBetweenSymmetric(minValue).and(maxValue)
SQL:
this not between symmetric minValue and maxValue
- Specified by:
notBetweenSymmetric
in interfaceField<T>
-
notBetweenSymmetric
public final Condition notBetweenSymmetric(Field<T> minValue, Field<T> maxValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.This is the same as calling
notBetweenSymmetric(minValue).and(maxValue)
SQL:
this not between symmetric minValue and maxValue
- Specified by:
notBetweenSymmetric
in interfaceField<T>
-
between
public final BetweenAndStep<T> between(T minValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.SQL:
this between minValue and maxValue
-
between
public final BetweenAndStep<T> between(Field<T> minValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.SQL:
this between minValue and maxValue
-
betweenSymmetric
public final BetweenAndStep<T> betweenSymmetric(T minValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.SQL:
this between symmetric minValue and maxValue
- Specified by:
betweenSymmetric
in interfaceField<T>
-
betweenSymmetric
public final BetweenAndStep<T> betweenSymmetric(Field<T> minValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.SQL:
this between symmetric minValue and maxValue
- Specified by:
betweenSymmetric
in interfaceField<T>
-
notBetween
public final BetweenAndStep<T> notBetween(T minValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.SQL:
this not between minValue and maxValue
- Specified by:
notBetween
in interfaceField<T>
-
notBetween
public final BetweenAndStep<T> notBetween(Field<T> minValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.SQL:
this not between minValue and maxValue
- Specified by:
notBetween
in interfaceField<T>
-
notBetweenSymmetric
public final BetweenAndStep<T> notBetweenSymmetric(T minValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.SQL:
this not between symmetric minValue and maxValue
- Specified by:
notBetweenSymmetric
in interfaceField<T>
-
notBetweenSymmetric
public final BetweenAndStep<T> notBetweenSymmetric(Field<T> minValue)
Description copied from interface:Field
Create a condition to check this field against some bounds.SQL:
this not between symmetric minValue and maxValue
- Specified by:
notBetweenSymmetric
in interfaceField<T>
-
eq
public final Condition eq(T value)
Description copied from interface:Field
this = value
.- Specified by:
eq
in interfaceField<T>
- See Also:
Field.equal(Object)
-
eq
public final Condition eq(Field<T> field)
Description copied from interface:Field
this = field
.- Specified by:
eq
in interfaceField<T>
- See Also:
Field.equal(Field)
-
eq
public final Condition eq(Select<? extends Record1<T>> query)
Description copied from interface:Field
this = (Select<?> ...)
.- Specified by:
eq
in interfaceField<T>
- See Also:
Field.equal(Select)
-
eq
public final Condition eq(QuantifiedSelect<? extends Record1<T>> query)
Description copied from interface:Field
this = [quantifier] (Select<?> ...)
.- Specified by:
eq
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
ne
public final Condition ne(T value)
Description copied from interface:Field
this != value
.- Specified by:
ne
in interfaceField<T>
- See Also:
Field.notEqual(Object)
-
ne
public final Condition ne(Field<T> field)
Description copied from interface:Field
this != field
.- Specified by:
ne
in interfaceField<T>
- See Also:
Field.notEqual(Field)
-
ne
public final Condition ne(Select<? extends Record1<T>> query)
Description copied from interface:Field
this != (Select<?> ...)
.- Specified by:
ne
in interfaceField<T>
- See Also:
Field.notEqual(Select)
-
ne
public final Condition ne(QuantifiedSelect<? extends Record1<T>> query)
Description copied from interface:Field
this != [quantifier] (Select<?> ...)
.- Specified by:
ne
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
lt
public final Condition lt(T value)
Description copied from interface:Field
this < value
.- Specified by:
lt
in interfaceField<T>
- See Also:
Field.lessThan(Object)
-
lt
public final Condition lt(Field<T> field)
Description copied from interface:Field
this < field
.- Specified by:
lt
in interfaceField<T>
- See Also:
Field.lessThan(Field)
-
lt
public final Condition lt(Select<? extends Record1<T>> query)
Description copied from interface:Field
this < (Select<?> ...)
.- Specified by:
lt
in interfaceField<T>
- See Also:
Field.lessThan(Select)
-
lt
public final Condition lt(QuantifiedSelect<? extends Record1<T>> query)
Description copied from interface:Field
this < [quantifier] (Select<?> ...)
.- Specified by:
lt
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
le
public final Condition le(T value)
Description copied from interface:Field
this <= value
.- Specified by:
le
in interfaceField<T>
- See Also:
Field.lessOrEqual(Object)
-
le
public final Condition le(Field<T> field)
Description copied from interface:Field
this <= field
.- Specified by:
le
in interfaceField<T>
- See Also:
Field.lessOrEqual(Field)
-
le
public final Condition le(Select<? extends Record1<T>> query)
Description copied from interface:Field
this <= (Select<?> ...)
.- Specified by:
le
in interfaceField<T>
- See Also:
Field.lessOrEqual(Select)
-
le
public final Condition le(QuantifiedSelect<? extends Record1<T>> query)
Description copied from interface:Field
this <= [quantifier] (Select<?> ...)
.- Specified by:
le
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
gt
public final Condition gt(T value)
Description copied from interface:Field
this > value
.- Specified by:
gt
in interfaceField<T>
- See Also:
Field.greaterThan(Object)
-
gt
public final Condition gt(Field<T> field)
Description copied from interface:Field
this > field
.- Specified by:
gt
in interfaceField<T>
- See Also:
Field.greaterThan(Field)
-
gt
public final Condition gt(Select<? extends Record1<T>> query)
Description copied from interface:Field
this > (Select<?> ...)
.- Specified by:
gt
in interfaceField<T>
- See Also:
Field.greaterThan(Select)
-
gt
public final Condition gt(QuantifiedSelect<? extends Record1<T>> query)
Description copied from interface:Field
this > [quantifier] (Select<?> ...)
.- Specified by:
gt
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
ge
public final Condition ge(T value)
Description copied from interface:Field
this >= value
.- Specified by:
ge
in interfaceField<T>
- See Also:
Field.greaterOrEqual(Object)
-
ge
public final Condition ge(Field<T> field)
Description copied from interface:Field
this >= field
.- Specified by:
ge
in interfaceField<T>
- See Also:
Field.greaterOrEqual(Field)
-
ge
public final Condition ge(Select<? extends Record1<T>> query)
Description copied from interface:Field
this >= (Select<?> ...)
.- Specified by:
ge
in interfaceField<T>
- See Also:
Field.greaterOrEqual(Select)
-
ge
public final Condition ge(QuantifiedSelect<? extends Record1<T>> query)
Description copied from interface:Field
this >= [quantifier] (Select<?> ...)
.- Specified by:
ge
in interfaceField<T>
- See Also:
DSL.all(Field)
,DSL.all(Select)
,DSL.all(Object...)
,DSL.any(Field)
,DSL.any(Select)
,DSL.any(Object...)
-
equal
public final Condition equal(Field<T> field)
Description copied from interface:Field
this = field
.
-
equalIgnoreCase
public final Condition equalIgnoreCase(String value)
Description copied from interface:Field
lower(this) = lower(value)
.- Specified by:
equalIgnoreCase
in interfaceField<T>
-
equalIgnoreCase
public final Condition equalIgnoreCase(Field<String> value)
Description copied from interface:Field
lower(this) = lower(value)
.- Specified by:
equalIgnoreCase
in interfaceField<T>
-
equal
public final Condition equal(Select<? extends Record1<T>> query)
Description copied from interface:Field
this = (Select<?> ...)
.
-
equal
public final Condition equal(QuantifiedSelect<? extends Record1<T>> query)
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
public final Condition notEqual(T value)
Description copied from interface:Field
this != value
.
-
notEqual
public final Condition notEqual(Field<T> field)
Description copied from interface:Field
this != field
.
-
notEqualIgnoreCase
public final Condition notEqualIgnoreCase(String value)
Description copied from interface:Field
lower(this) != lower(value)
.- Specified by:
notEqualIgnoreCase
in interfaceField<T>
-
notEqualIgnoreCase
public final Condition notEqualIgnoreCase(Field<String> value)
Description copied from interface:Field
lower(this) != lower(value)
.- Specified by:
notEqualIgnoreCase
in interfaceField<T>
-
notEqual
public final Condition notEqual(Select<? extends Record1<T>> query)
Description copied from interface:Field
this != (Select<?> ...)
.
-
notEqual
public final Condition notEqual(QuantifiedSelect<? extends Record1<T>> query)
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
public final Condition lessThan(T value)
Description copied from interface:Field
this < value
.
-
lessThan
public final Condition lessThan(Field<T> field)
Description copied from interface:Field
this < field
.
-
lessThan
public final Condition lessThan(Select<? extends Record1<T>> query)
Description copied from interface:Field
this < (Select<?> ...)
.
-
lessThan
public final Condition lessThan(QuantifiedSelect<? extends Record1<T>> query)
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
public final Condition lessOrEqual(T value)
Description copied from interface:Field
this <= value
.- Specified by:
lessOrEqual
in interfaceField<T>
-
lessOrEqual
public final Condition lessOrEqual(Field<T> field)
Description copied from interface:Field
this <= field
.- Specified by:
lessOrEqual
in interfaceField<T>
-
lessOrEqual
public final Condition lessOrEqual(Select<? extends Record1<T>> query)
Description copied from interface:Field
this <= (Select<?> ...)
.- Specified by:
lessOrEqual
in interfaceField<T>
-
lessOrEqual
public final Condition lessOrEqual(QuantifiedSelect<? extends Record1<T>> query)
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
public final Condition greaterThan(T value)
Description copied from interface:Field
this > value
.- Specified by:
greaterThan
in interfaceField<T>
-
greaterThan
public final Condition greaterThan(Field<T> field)
Description copied from interface:Field
this > field
.- Specified by:
greaterThan
in interfaceField<T>
-
greaterThan
public final Condition greaterThan(Select<? extends Record1<T>> query)
Description copied from interface:Field
this > (Select<?> ...)
.- Specified by:
greaterThan
in interfaceField<T>
-
greaterThan
public final Condition greaterThan(QuantifiedSelect<? extends Record1<T>> query)
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
public final Condition greaterOrEqual(T value)
Description copied from interface:Field
this >= value
.- Specified by:
greaterOrEqual
in interfaceField<T>
-
greaterOrEqual
public final Condition greaterOrEqual(Field<T> field)
Description copied from interface:Field
this >= field
.- Specified by:
greaterOrEqual
in interfaceField<T>
-
greaterOrEqual
public final Condition greaterOrEqual(Select<? extends Record1<T>> query)
Description copied from interface:Field
this >= (Select<?> ...)
.- Specified by:
greaterOrEqual
in interfaceField<T>
-
greaterOrEqual
public final Condition greaterOrEqual(QuantifiedSelect<? extends Record1<T>> query)
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
public final Condition compare(Comparator comparator, T value)
Description copied from interface:Field
Compare this field with a value using a dynamic comparator.
-
compare
public final Condition compare(Comparator comparator, Field<T> field)
Description copied from interface:Field
Compare this field with another field using a dynamic comparator.
-
compare
public final Condition compare(Comparator comparator, Select<? extends Record1<T>> query)
Description copied from interface:Field
Compare this field with a subselect using a dynamic comparator.Consider
Comparator.supportsSubselect()
to assess whether a comparator can be used with this method.
-
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
@Pro public final Field<T> plus()
Description copied from interface:Field
Turn this field into an Oracle-specific field for use in outer-join predicates.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 public final Field<Integer> sign()
Deprecated.- Specified by:
sign
in interfaceField<T>
- See Also:
DSL.sign(Field)
-
abs
@Deprecated public final Field<T> abs()
Deprecated.- Specified by:
abs
in interfaceField<T>
- See Also:
DSL.abs(Field)
-
round
@Deprecated public final Field<T> round()
Deprecated.- Specified by:
round
in interfaceField<T>
- See Also:
DSL.round(Field)
-
round
@Deprecated public final Field<T> round(int decimals)
Deprecated.- Specified by:
round
in interfaceField<T>
- See Also:
DSL.round(Field, int)
-
floor
@Deprecated public final Field<T> floor()
Deprecated.- Specified by:
floor
in interfaceField<T>
- See Also:
DSL.floor(Field)
-
ceil
@Deprecated public final Field<T> ceil()
Deprecated.- Specified by:
ceil
in interfaceField<T>
- See Also:
DSL.ceil(Field)
-
sqrt
@Deprecated public final Field<BigDecimal> sqrt()
Deprecated.- Specified by:
sqrt
in interfaceField<T>
- See Also:
DSL.sqrt(Field)
-
exp
@Deprecated public final Field<BigDecimal> exp()
Deprecated.- Specified by:
exp
in interfaceField<T>
- See Also:
DSL.exp(Field)
-
ln
@Deprecated public final Field<BigDecimal> ln()
Deprecated.- Specified by:
ln
in interfaceField<T>
- See Also:
DSL.ln(Field)
-
log
@Deprecated public final Field<BigDecimal> log(int base)
Deprecated.- Specified by:
log
in interfaceField<T>
- See Also:
DSL.log(Field, int)
-
pow
public final Field<BigDecimal> pow(Number exponent)
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
public final Field<BigDecimal> power(Number exponent)
Description copied from interface:Field
An alias forField.power(Number)
.- Specified by:
power
in interfaceField<T>
- See Also:
Field.power(Number)
-
pow
public final Field<BigDecimal> pow(Field<? extends Number> exponent)
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
public final Field<BigDecimal> power(Field<? extends Number> exponent)
Description copied from interface:Field
An alias forField.power(Field)
.- Specified by:
power
in interfaceField<T>
- See Also:
Field.power(Field)
-
acos
@Deprecated public final Field<BigDecimal> acos()
Deprecated.- Specified by:
acos
in interfaceField<T>
- See Also:
DSL.acos(Field)
-
asin
@Deprecated public final Field<BigDecimal> asin()
Deprecated.- Specified by:
asin
in interfaceField<T>
- See Also:
DSL.asin(Field)
-
atan
@Deprecated public final Field<BigDecimal> atan()
Deprecated.- Specified by:
atan
in interfaceField<T>
- See Also:
DSL.atan(Field)
-
atan2
@Deprecated public final Field<BigDecimal> atan2(Number y)
Deprecated.- Specified by:
atan2
in interfaceField<T>
- See Also:
DSL.atan2(Field, Number)
-
atan2
@Deprecated public final Field<BigDecimal> atan2(Field<? extends Number> y)
Deprecated.- Specified by:
atan2
in interfaceField<T>
- See Also:
DSL.atan2(Field, Field)
-
cos
@Deprecated public final Field<BigDecimal> cos()
Deprecated.- Specified by:
cos
in interfaceField<T>
- See Also:
DSL.cos(Field)
-
sin
@Deprecated public final Field<BigDecimal> sin()
Deprecated.- Specified by:
sin
in interfaceField<T>
- See Also:
DSL.sin(Field)
-
tan
@Deprecated public final Field<BigDecimal> tan()
Deprecated.- Specified by:
tan
in interfaceField<T>
- See Also:
DSL.tan(Field)
-
cot
@Deprecated public final Field<BigDecimal> cot()
Deprecated.- Specified by:
cot
in interfaceField<T>
- See Also:
DSL.cot(Field)
-
sinh
@Deprecated public final Field<BigDecimal> sinh()
Deprecated.- Specified by:
sinh
in interfaceField<T>
- See Also:
DSL.sinh(Field)
-
cosh
@Deprecated public final Field<BigDecimal> cosh()
Deprecated.- Specified by:
cosh
in interfaceField<T>
- See Also:
DSL.cosh(Field)
-
tanh
@Deprecated public final Field<BigDecimal> tanh()
Deprecated.- Specified by:
tanh
in interfaceField<T>
- See Also:
DSL.tanh(Field)
-
coth
@Deprecated public final Field<BigDecimal> coth()
Deprecated.- Specified by:
coth
in interfaceField<T>
- See Also:
DSL.coth(Field)
-
deg
@Deprecated public final Field<BigDecimal> deg()
Deprecated.- Specified by:
deg
in interfaceField<T>
- See Also:
DSL.deg(Field)
-
rad
@Deprecated public final Field<BigDecimal> rad()
Deprecated.- Specified by:
rad
in interfaceField<T>
- See Also:
DSL.rad(Field)
-
count
@Deprecated public final Field<Integer> count()
Deprecated.- Specified by:
count
in interfaceField<T>
- See Also:
DSL.count(Field)
-
countDistinct
@Deprecated public final Field<Integer> countDistinct()
Deprecated.- Specified by:
countDistinct
in interfaceField<T>
- See Also:
DSL.countDistinct(Field)
-
max
@Deprecated public final Field<T> max()
Deprecated.- Specified by:
max
in interfaceField<T>
- See Also:
DSL.max(Field)
-
min
@Deprecated public final Field<T> min()
Deprecated.- Specified by:
min
in interfaceField<T>
- See Also:
DSL.min(Field)
-
sum
@Deprecated public final Field<BigDecimal> sum()
Deprecated.- Specified by:
sum
in interfaceField<T>
- See Also:
DSL.sum(Field)
-
avg
@Deprecated public final Field<BigDecimal> avg()
Deprecated.- Specified by:
avg
in interfaceField<T>
- See Also:
DSL.avg(Field)
-
median
@Deprecated public final Field<BigDecimal> median()
Deprecated.- Specified by:
median
in interfaceField<T>
- See Also:
DSL.median(Field)
-
stddevPop
@Deprecated public final Field<BigDecimal> stddevPop()
Deprecated.- Specified by:
stddevPop
in interfaceField<T>
- See Also:
DSL.stddevPop(Field)
-
stddevSamp
@Deprecated public final Field<BigDecimal> stddevSamp()
Deprecated.- Specified by:
stddevSamp
in interfaceField<T>
- See Also:
DSL.stddevSamp(Field)
-
varPop
@Deprecated public final Field<BigDecimal> varPop()
Deprecated.- Specified by:
varPop
in interfaceField<T>
- See Also:
DSL.varPop(Field)
-
varSamp
@Deprecated public final Field<BigDecimal> varSamp()
Deprecated.- Specified by:
varSamp
in interfaceField<T>
- See Also:
DSL.varSamp(Field)
-
countOver
@Deprecated public final WindowPartitionByStep<Integer> countOver()
Deprecated.- Specified by:
countOver
in interfaceField<T>
- See Also:
DSL.count(Field)
,WindowOverStep.over()
-
maxOver
@Deprecated public final WindowPartitionByStep<T> maxOver()
Deprecated.- Specified by:
maxOver
in interfaceField<T>
- See Also:
DSL.max(Field)
,WindowOverStep.over()
-
minOver
@Deprecated public final WindowPartitionByStep<T> minOver()
Deprecated.- Specified by:
minOver
in interfaceField<T>
- See Also:
DSL.min(Field)
,WindowOverStep.over()
-
sumOver
@Deprecated public final WindowPartitionByStep<BigDecimal> sumOver()
Deprecated.- Specified by:
sumOver
in interfaceField<T>
- See Also:
DSL.sum(Field)
,WindowOverStep.over()
-
avgOver
@Deprecated public final WindowPartitionByStep<BigDecimal> avgOver()
Deprecated.- Specified by:
avgOver
in interfaceField<T>
- See Also:
DSL.avg(Field)
,WindowOverStep.over()
-
firstValue
@Deprecated public final WindowIgnoreNullsStep<T> firstValue()
Deprecated.- Specified by:
firstValue
in interfaceField<T>
- See Also:
DSL.firstValue(Field)
,WindowOverStep.over()
-
lastValue
@Deprecated public final WindowIgnoreNullsStep<T> lastValue()
Deprecated.- Specified by:
lastValue
in interfaceField<T>
- See Also:
DSL.lastValue(Field)
,WindowOverStep.over()
-
lead
@Deprecated public final WindowIgnoreNullsStep<T> lead()
Deprecated.- Specified by:
lead
in interfaceField<T>
- See Also:
DSL.lead(Field)
,WindowOverStep.over()
-
lead
@Deprecated public final WindowIgnoreNullsStep<T> lead(int offset)
Deprecated.- Specified by:
lead
in interfaceField<T>
- See Also:
DSL.lead(Field, int)
,WindowOverStep.over()
-
lead
@Deprecated public final WindowIgnoreNullsStep<T> lead(int offset, T defaultValue)
Deprecated.- Specified by:
lead
in interfaceField<T>
- See Also:
DSL.lead(Field, int, Object)
,WindowOverStep.over()
-
lead
@Deprecated public final WindowIgnoreNullsStep<T> lead(int offset, Field<T> defaultValue)
Deprecated.- Specified by:
lead
in interfaceField<T>
- See Also:
DSL.lead(Field, int, Field)
,WindowOverStep.over()
-
lag
@Deprecated public final WindowIgnoreNullsStep<T> lag()
Deprecated.- Specified by:
lag
in interfaceField<T>
- See Also:
DSL.lag(Field)
,WindowOverStep.over()
-
lag
@Deprecated public final WindowIgnoreNullsStep<T> lag(int offset)
Deprecated.- Specified by:
lag
in interfaceField<T>
- See Also:
DSL.lag(Field, int)
,WindowOverStep.over()
-
lag
@Deprecated public final WindowIgnoreNullsStep<T> lag(int offset, T defaultValue)
Deprecated.- Specified by:
lag
in interfaceField<T>
- See Also:
DSL.lag(Field, int, Object)
,WindowOverStep.over()
-
lag
@Deprecated public final WindowIgnoreNullsStep<T> lag(int offset, Field<T> defaultValue)
Deprecated.- Specified by:
lag
in interfaceField<T>
- See Also:
DSL.lag(Field, int, Field)
,WindowOverStep.over()
-
stddevPopOver
@Deprecated public final WindowPartitionByStep<BigDecimal> stddevPopOver()
Deprecated.- Specified by:
stddevPopOver
in interfaceField<T>
- See Also:
DSL.stddevPop(Field)
,WindowOverStep.over()
-
stddevSampOver
@Deprecated public final WindowPartitionByStep<BigDecimal> stddevSampOver()
Deprecated.- Specified by:
stddevSampOver
in interfaceField<T>
- See Also:
DSL.stddevSamp(Field)
,WindowOverStep.over()
-
varPopOver
@Deprecated public final WindowPartitionByStep<BigDecimal> varPopOver()
Deprecated.- Specified by:
varPopOver
in interfaceField<T>
- See Also:
DSL.varPop(Field)
,WindowOverStep.over()
-
varSampOver
@Deprecated public final WindowPartitionByStep<BigDecimal> varSampOver()
Deprecated.- Specified by:
varSampOver
in interfaceField<T>
- See Also:
DSL.varSamp(Field)
,WindowOverStep.over()
-
upper
@Deprecated public final Field<String> upper()
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
upper
in interfaceField<T>
- See Also:
DSL.upper(Field)
-
lower
@Deprecated public final Field<String> lower()
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
lower
in interfaceField<T>
- See Also:
DSL.lower(Field)
-
trim
@Deprecated public final Field<String> trim()
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
trim
in interfaceField<T>
- See Also:
DSL.trim(Field)
-
rtrim
@Deprecated public final Field<String> rtrim()
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
rtrim
in interfaceField<T>
- See Also:
DSL.rtrim(Field)
-
ltrim
@Deprecated public final Field<String> ltrim()
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
ltrim
in interfaceField<T>
- See Also:
DSL.ltrim(Field)
-
rpad
@Deprecated public final Field<String> rpad(Field<? extends Number> length)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
rpad
in interfaceField<T>
- See Also:
DSL.rpad(Field, Field)
-
rpad
@Deprecated public final Field<String> rpad(int length)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods 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 public final Field<String> rpad(int length, char character)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
rpad
in interfaceField<T>
- See Also:
DSL.rpad(Field, int, char)
-
lpad
@Deprecated public final Field<String> lpad(Field<? extends Number> length)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
lpad
in interfaceField<T>
- See Also:
DSL.lpad(Field, Field)
-
lpad
@Deprecated public final Field<String> lpad(int length)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods 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 public final Field<String> lpad(int length, char character)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
lpad
in interfaceField<T>
- See Also:
DSL.lpad(Field, int, char)
-
repeat
@Deprecated public final Field<String> repeat(Number count)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
repeat
in interfaceField<T>
- See Also:
DSL.repeat(Field, int)
-
repeat
@Deprecated public final Field<String> repeat(Field<? extends Number> count)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
repeat
in interfaceField<T>
- See Also:
DSL.repeat(Field, Field)
-
replace
@Deprecated public final Field<String> replace(Field<String> search)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
replace
in interfaceField<T>
- See Also:
DSL.replace(Field, Field)
-
replace
@Deprecated public final Field<String> replace(String search)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
replace
in interfaceField<T>
- See Also:
DSL.replace(Field, String)
-
replace
@Deprecated public final Field<String> replace(Field<String> search, Field<String> replace)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
replace
in interfaceField<T>
- See Also:
DSL.replace(Field, Field, Field)
-
replace
@Deprecated public final Field<String> replace(String search, String replace)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
replace
in interfaceField<T>
- See Also:
DSL.replace(Field, String, String)
-
position
@Deprecated public final Field<Integer> position(String search)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
position
in interfaceField<T>
- See Also:
DSL.position(Field, String)
-
position
@Deprecated public final Field<Integer> position(Field<String> search)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
position
in interfaceField<T>
- See Also:
DSL.position(Field, Field)
-
ascii
@Deprecated public final Field<Integer> ascii()
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
ascii
in interfaceField<T>
- See Also:
DSL.ascii(Field)
-
collate
public final Field<String> collate(String collation)
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
public final Field<String> collate(Name collation)
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
public final Field<String> collate(Collation collation)
Description copied from interface:Field
Apply a collation operator to this column expression.
-
concat
@Deprecated public final Field<String> concat(Field<?>... fields)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
concat
in interfaceField<T>
- See Also:
DSL.concat(Field...)
-
concat
@Deprecated public final Field<String> concat(String... values)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
concat
in interfaceField<T>
- See Also:
DSL.concat(String...)
-
concat
public final Field<String> concat(char... values)
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 public final Field<String> substring(int startingPosition)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
substring
in interfaceField<T>
- See Also:
DSL.substring(Field, int)
-
substring
@Deprecated public final Field<String> substring(Field<? extends Number> startingPosition)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
substring
in interfaceField<T>
- See Also:
DSL.substring(Field, Field)
-
substring
@Deprecated public final Field<String> substring(int startingPosition, int length)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods 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 public final Field<Integer> length()
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
length
in interfaceField<T>
- See Also:
DSL.length(Field)
-
charLength
@Deprecated public final Field<Integer> charLength()
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
charLength
in interfaceField<T>
- See Also:
DSL.charLength(Field)
-
bitLength
@Deprecated public final Field<Integer> bitLength()
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
bitLength
in interfaceField<T>
- See Also:
DSL.bitLength(Field)
-
octetLength
@Deprecated public final Field<Integer> octetLength()
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
octetLength
in interfaceField<T>
- See Also:
DSL.octetLength(Field)
-
extract
@Deprecated public final Field<Integer> extract(DatePart datePart)
Deprecated.- Specified by:
extract
in interfaceField<T>
- See Also:
DSL.extract(Field, DatePart)
-
greatest
@Deprecated @SafeVarargs public final Field<T> greatest(T... others)
Deprecated.- Specified by:
greatest
in interfaceField<T>
- See Also:
DSL.greatest(Field, Field...)
-
greatest
@Deprecated public final Field<T> greatest(Field<?>... others)
Deprecated.- Specified by:
greatest
in interfaceField<T>
- See Also:
DSL.greatest(Field, Field...)
-
least
@Deprecated @SafeVarargs public final Field<T> least(T... others)
Deprecated.- Specified by:
least
in interfaceField<T>
- See Also:
DSL.least(Field, Field...)
-
least
@Deprecated public final Field<T> least(Field<?>... others)
Deprecated.- Specified by:
least
in interfaceField<T>
- See Also:
DSL.least(Field, Field...)
-
nvl
@Deprecated public final Field<T> nvl(T defaultValue)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
nvl
in interfaceField<T>
- See Also:
DSL.nvl(Field, Object)
-
nvl
@Deprecated public final Field<T> nvl(Field<T> defaultValue)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
nvl
in interfaceField<T>
- See Also:
DSL.nvl(Field, Field)
-
nvl2
@Deprecated public final <Z> Field<Z> nvl2(Z valueIfNotNull, Z valueIfNull)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
nvl2
in interfaceField<T>
- See Also:
DSL.nvl2(Field, Object, Object)
-
nvl2
@Deprecated public final <Z> Field<Z> nvl2(Field<Z> valueIfNotNull, Field<Z> valueIfNull)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
nvl2
in interfaceField<T>
- See Also:
DSL.nvl2(Field, Field, Field)
-
nullif
@Deprecated public final Field<T> nullif(T other)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
nullif
in interfaceField<T>
- See Also:
DSL.nullif(Field, Object)
-
nullif
@Deprecated public final Field<T> nullif(Field<T> other)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
nullif
in interfaceField<T>
- See Also:
DSL.nullif(Field, Field)
-
decode
@Deprecated public final <Z> Field<Z> decode(T search, Z result)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
decode
in interfaceField<T>
- See Also:
DSL.decode(Object, Object, Object)
-
decode
@Deprecated public final <Z> Field<Z> decode(T search, Z result, Object... more)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
decode
in interfaceField<T>
- See Also:
DSL.decode(Object, Object, Object, Object...)
-
decode
@Deprecated public final <Z> Field<Z> decode(Field<T> search, Field<Z> result)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
decode
in interfaceField<T>
- See Also:
DSL.decode(Field, Field, Field)
-
decode
@Deprecated public final <Z> Field<Z> decode(Field<T> search, Field<Z> result, Field<?>... more)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
decode
in interfaceField<T>
- See Also:
DSL.decode(Field, Field, Field, Field...)
-
coalesce
@Deprecated @SafeVarargs public final Field<T> coalesce(T option, T... options)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
coalesce
in interfaceField<T>
- See Also:
DSL.coalesce(Object, Object...)
-
coalesce
@Deprecated public final Field<T> coalesce(Field<T> option, Field<?>... options)
Deprecated.Description copied from interface:Field
This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods fromDSLContext
- Specified by:
coalesce
in interfaceField<T>
- See Also:
DSL.coalesce(Field, Field...)
-
getName
public final String getName()
Description copied from interface:Named
The unqualified name of this object.
-
getQualifiedName
public Name getQualifiedName()
Description copied from interface:Named
The qualified name of this object.- Specified by:
getQualifiedName
in interfaceNamed
-
getUnqualifiedName
public final Name getUnqualifiedName()
Description copied from interface:Named
The unqualified name of this object.- Specified by:
getUnqualifiedName
in interfaceNamed
-
getComment
public final String getComment()
Description copied from interface:Named
The comment on this object.- Specified by:
getComment
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
public boolean equals(Object that)
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.
-
toSQL
@Deprecated public final void toSQL(RenderContext context)
Deprecated.- 3.4.0 - [#2694] - UseQueryPartInternal.accept(Context)
instead.Description copied from interface:QueryPartInternal
Render thisQueryPart
to a SQL string contained incontext.sql()
. Thecontext
will contain additional information about how to render thisQueryPart
, e.g. whether thisQueryPart
should be rendered as a declaration or reference, whether thisQueryPart
's contained bind variables should be inlined or replaced by'?'
, etc.- Specified by:
toSQL
in interfaceQueryPartInternal
-
bind
@Deprecated public final void bind(BindContext context) throws DataAccessException
Deprecated.- 3.4.0 - [#2694] - UseQueryPartInternal.accept(Context)
instead.Description copied from interface:QueryPartInternal
Bind all parameters of thisQueryPart
to a PreparedStatementThis method is for JOOQ INTERNAL USE only. Do not reference directly
- Specified by:
bind
in interfaceQueryPartInternal
- Parameters:
context
- The context holding the next bind index and other information for variable binding- Throws:
DataAccessException
- If something went wrong while binding a variable
-
declaresFields
public boolean declaresFields()
Subclasses may override this- Specified by:
declaresFields
in interfaceQueryPartInternal
-
declaresTables
public boolean declaresTables()
Subclasses may override this- Specified by:
declaresTables
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
-
generatesCast
public boolean generatesCast()
Subclasses may override this- Specified by:
generatesCast
in interfaceQueryPartInternal
-
toString
public String 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 protected final DSLContext create()
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.Internal convenience method
-
create
@Deprecated protected final DSLContext create(Configuration configuration)
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.Internal convenience method
-
create
@Deprecated protected final DSLContext create(Context<?> ctx)
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.Internal convenience method
-
translate
protected final DataAccessException translate(String sql, SQLException e)
Internal convenience method
-
-