Type Parameters:: T - The field type

All Superinterfaces:: FieldOrConstraint, FieldOrRow, FieldOrRowOrSelect, GroupField, Named, OrderField<T>, QueryPart, SelectField<T>, SelectFieldOrAsterisk, Serializable, TableElement, Typed<T>

All Known Subinterfaces:: AggregateFilterStep<T>, AggregateFunction<T>, ArrayAggOrderByStep<T>, CaseConditionStep<T>, CaseWhenStep<V,T>, Condition, False, GroupConcatOrderByStep, GroupConcatSeparatorStep, JSONArrayAggNullStep<T>, JSONArrayAggOrderByStep<J>, JSONArrayAggReturningStep<T>, JSONArrayNullStep<T>, JSONArrayReturningStep<T>, JSONExistsOnStep, JSONObjectAggNullStep<T>, JSONObjectAggReturningStep<T>, JSONObjectNullStep<T>, JSONObjectReturningStep<T>, JSONValueOnStep<J>, JSONValueReturningStep<T>, LikeEscapeStep, Null, OptionallyOrderedAggregateFunction<T>, Param<T>, Parameter<T>, ParamOrVariable<T>, QOM.Abs<T>, QOM.Acos, QOM.Acosh, QOM.Acoth, QOM.Add<T>, QOM.And, QOM.AnyValue<T>, QOM.Array<T>, QOM.ArrayAgg<T>, QOM.ArrayAllMatch<T>, QOM.ArrayAnyMatch<T>, QOM.ArrayAppend<T>, QOM.ArrayConcat<T>, QOM.ArrayFilter<T>, QOM.ArrayGet<T>, QOM.ArrayMap<T,U>, QOM.ArrayNoneMatch<T>, QOM.ArrayOverlap<T>, QOM.ArrayPrepend<T>, QOM.ArrayQuery<T>, QOM.ArrayRemove<T>, QOM.ArrayReplace<T>, QOM.ArrayToString<T>, QOM.Ascii, QOM.Asin, QOM.Asinh, QOM.Atan, QOM.Atan2, QOM.Atanh, QOM.Avg, QOM.Between<T>, QOM.BinaryBitLength, QOM.BinaryConcat, QOM.BinaryLength, QOM.BinaryLike, QOM.BinaryLikeQuantified, QOM.BinaryLtrim, QOM.BinaryMd5, QOM.BinaryOctetLength, QOM.BinaryOverlay, QOM.BinaryPosition, QOM.BinaryRtrim, QOM.BinarySubstring, QOM.BinaryTrim, QOM.BinToUuid, QOM.BitAnd<T>, QOM.BitAndAgg<T>, QOM.BitCount, QOM.BitGet<T>, QOM.BitLength, QOM.BitNand<T>, QOM.BitNandAgg<T>, QOM.BitNor<T>, QOM.BitNorAgg<T>, QOM.BitNot<T>, QOM.BitOr<T>, QOM.BitOrAgg<T>, QOM.BitSet<T>, QOM.BitXNor<T>, QOM.BitXNorAgg<T>, QOM.BitXor<T>, QOM.BitXorAgg<T>, QOM.BoolAnd, QOM.BoolOr, QOM.Cardinality, QOM.CaseSearched<T>, QOM.CaseSimple<V,T>, QOM.Cast<T>, QOM.Cbrt, QOM.Ceil<T>, QOM.CharLength, QOM.Choose<T>, QOM.Chr, QOM.Coalesce<T>, QOM.Coerce<T>, QOM.Collated, QOM.Collect<T,A>, QOM.CombinedCondition<R>, QOM.CompareCondition<T,R>, QOM.Concat, QOM.ConditionAsField, QOM.ConnectByIsCycle, QOM.ConnectByIsLeaf, QOM.ConnectByRoot<T>, QOM.Contains<T>, QOM.ContainsIgnoreCase<T>, QOM.Convert<T>, QOM.Corr, QOM.Cos, QOM.Cosh, QOM.Cot, QOM.Coth, QOM.Count, QOM.CountTable, QOM.CovarPop, QOM.CovarSamp, QOM.CumeDist, QOM.CurrentCatalog, QOM.CurrentDate<T>, QOM.CurrentSchema, QOM.CurrentTime<T>, QOM.CurrentTimestamp<T>, QOM.CurrentUser, QOM.DateAdd<T>, QOM.Decode<V,T>, QOM.Default<T>, QOM.Degrees, QOM.Deleting, QOM.DenseRank, QOM.Digits, QOM.Div<T>, QOM.EndsWith<T>, QOM.EndsWithIgnoreCase<T>, QOM.Eq<T>, QOM.EqQuantified<T>, QOM.Euler, QOM.Excluded<T>, QOM.Exists, QOM.Exp, QOM.Extract, QOM.False, QOM.FieldAlias<T>, QOM.FieldCondition, QOM.FieldFunction<T>, QOM.FirstValue<T>, QOM.Floor<T>, QOM.Function<T>, QOM.Ge<T>, QOM.GeQuantified<T>, QOM.Greatest<T>, QOM.Gt<T>, QOM.GtQuantified<T>, QOM.Iif<T>, QOM.In<T>, QOM.InList<T>, QOM.Inserting, QOM.IsDistinctFrom<T>, QOM.IsDocument, QOM.IsJson, QOM.IsNotDistinctFrom<T>, QOM.IsNotDocument, QOM.IsNotJson, QOM.IsNotNull, QOM.IsNull, QOM.JSONArray<T>, QOM.JSONArrayAgg<J>, QOM.JSONArrayLength, QOM.JSONBArrayLength, QOM.JSONBGetAttribute, QOM.JSONBGetAttributeAsText, QOM.JSONBGetElement, QOM.JSONBGetElementAsText, QOM.JSONBInsert, QOM.JSONBKeyExists, QOM.JSONBKeys, QOM.JSONBRemove, QOM.JSONBReplace, QOM.JSONBSet, QOM.JSONGetAttribute, QOM.JSONGetAttributeAsText, QOM.JSONGetElement, QOM.JSONGetElementAsText, QOM.JSONInsert, QOM.JSONKeyExists, QOM.JSONKeys, QOM.JSONObject<T>, QOM.JSONObjectAgg<J>, QOM.JSONRemove, QOM.JSONReplace, QOM.JSONSet, QOM.Lag<T>, QOM.LastValue<T>, QOM.Le<T>, QOM.Lead<T>, QOM.Least<T>, QOM.Left, QOM.LeQuantified<T>, QOM.Level, QOM.Like, QOM.LikeIgnoreCase, QOM.LikeQuantified, QOM.Ln, QOM.Log, QOM.Log10, QOM.Lower, QOM.Lpad, QOM.Lt<T>, QOM.LtQuantified<T>, QOM.Ltrim, QOM.Max<T>, QOM.MaxBy<T>, QOM.Md5, QOM.Median, QOM.Min<T>, QOM.MinBy<T>, QOM.Mod<T>, QOM.Mode<T>, QOM.Mul<T>, QOM.Multiset<R>, QOM.MultisetAgg<R>, QOM.Ne<T>, QOM.Neg<T>, QOM.NeQuantified<T>, QOM.Not, QOM.NotBinaryLike, QOM.NotBinaryLikeQuantified, QOM.NotField, QOM.NotIn<T>, QOM.NotInList<T>, QOM.NotLike, QOM.NotLikeIgnoreCase, QOM.NotLikeQuantified, QOM.NotSimilarTo, QOM.NotSimilarToQuantified, QOM.NthValue<T>, QOM.Ntile, QOM.Null, QOM.Nullif<T>, QOM.Nvl<T>, QOM.Nvl2<T>, QOM.OctetLength, QOM.Or, QOM.Overlay, QOM.PercentRank, QOM.Pi, QOM.PlusJoin<T>, QOM.Position, QOM.Power, QOM.Prior<T>, QOM.Product, QOM.QualifiedRowid, QOM.Radians, QOM.Rand, QOM.Rank, QOM.RatioToReport, QOM.RegexpLike, QOM.RegrAvgX, QOM.RegrAvgY, QOM.RegrCount, QOM.RegrIntercept, QOM.RegrR2, QOM.RegrSlope, QOM.RegrSxx, QOM.RegrSxy, QOM.RegrSyy, QOM.Repeat, QOM.Replace, QOM.Reverse, QOM.Right, QOM.Root, QOM.Round<T>, QOM.RowAsField<R>, QOM.RowEq<T>, QOM.RowGe<T>, QOM.RowGt<T>, QOM.RowIsNotNull, QOM.RowIsNull, QOM.RowLe<T>, QOM.RowLt<T>, QOM.RowNe<T>, QOM.Rownum, QOM.RowNumber, QOM.RowOverlaps, QOM.Rpad, QOM.Rtrim, QOM.ScalarSubquery<T>, QOM.SelectIsNotNull, QOM.SelectIsNull, QOM.Shl<T>, QOM.Shr<T>, QOM.Sign, QOM.SimilarTo, QOM.SimilarToQuantified, QOM.Sin, QOM.Sinh, QOM.Space, QOM.SplitPart, QOM.Sqrt, QOM.Square<T>, QOM.StArea, QOM.StartsWith<T>, QOM.StartsWithIgnoreCase<T>, QOM.StAsBinary, QOM.StAsText, QOM.StBoundary<T>, QOM.StCentroid, QOM.StContains<T>, QOM.StCoveredBy<T>, QOM.StCovers<T>, QOM.StCrosses, QOM.StddevPop, QOM.StddevSamp, QOM.StDifference<T>, QOM.StDimension, QOM.StDisjoint<T>, QOM.StDistance<T>, QOM.StEndPoint<T>, QOM.StEquals<T>, QOM.StExteriorRing, QOM.StGeometryN<T>, QOM.StGeometryType, QOM.StGeomFromText, QOM.StGeomFromWKB, QOM.StInteriorRingN, QOM.StIntersection<T>, QOM.StIntersects<T>, QOM.StIsClosed, QOM.StIsEmpty, QOM.StIsRing, QOM.StIsSimple, QOM.StIsValid, QOM.StLength, QOM.StNumGeometries, QOM.StNumInteriorRings, QOM.StNumPoints, QOM.StOverlaps<T>, QOM.StPerimeter<T>, QOM.StPointN<T>, QOM.StringToArray, QOM.StSrid, QOM.StStartPoint<T>, QOM.StTouches<T>, QOM.StTransform<T>, QOM.StUnion<T>, QOM.StWithin<T>, QOM.StX, QOM.StXMax, QOM.StXMin, QOM.StY, QOM.StYMax, QOM.StYMin, QOM.StZ, QOM.StZMax, QOM.StZMin, QOM.Sub<T>, QOM.Substring, QOM.SubstringIndex, QOM.Sum, QOM.SysConnectByPath, QOM.TableAsField<R>, QOM.TableEq<R>, QOM.TableNe<R>, QOM.Tan, QOM.Tanh, QOM.Tau, QOM.TimestampDiff<T>, QOM.ToChar, QOM.ToDate, QOM.ToHex, QOM.ToTimestamp, QOM.Translate, QOM.Trim, QOM.True, QOM.Trunc<T>, QOM.TryCast<T>, QOM.Unique, QOM.Updating, QOM.Upper, QOM.Uuid, QOM.UuidToBin, QOM.VarPop, QOM.VarSamp, QOM.WidthBucket<T>, QOM.WindowFunction<T>, QOM.XMLAgg, QOM.XMLComment, QOM.XMLConcat, QOM.XMLDocument, QOM.XMLElement, QOM.XMLExists, QOM.XMLForest, QOM.XMLParse, QOM.XMLPi, QOM.XMLQuery, QOM.XMLSerialize<T>, QOM.Xor, TableField<R,T>, True, UDTField<R,T>, UDTPathField<R,U,T>, UDTPathTableField<R,U,T>, Variable<T>, WindowBeforeOverStep<T>, WindowExcludeStep<T>, WindowFinalStep<T>, WindowOrderByStep<T>, WindowPartitionByStep<T>, WindowRowsStep<T>, XMLAggOrderByStep<T>

All Known Implementing Classes:: CustomCondition, CustomField, UDTPathFieldImpl, UDTPathTableFieldImpl

public interface Field<T> extends SelectField<T>, GroupField, OrderField<T>, FieldOrRow, FieldOrRowOrSelect, FieldOrConstraint, TableElement

A column expression.

Column expressions or fields can be used in a variety of SQL statements and clauses, including (non-exhaustive list):

SELECT clause, e.g. through DSL.select(SelectField) (every Field is a subtype of SelectField)
WHERE clause, e.g. through SelectWhereStep.where(Field) (Field<Boolean> can behave like a Condition, regardless if your RDBMS supports the BOOLEAN type)
GROUP BY clause, e.g. through SelectGroupByStep.groupBy(GroupField...) (every Field is a subtype of GroupField)
HAVING clause, e.g. through SelectHavingStep.having(Field)
ORDER BY clause, e.g. through SelectOrderByStep.orderBy(OrderField) (every Field is a subtype of OrderField)
When creating a Condition, e.g. through eq(Field)
As a function argument, e.g. through DSL.abs(Field)
Many more...

Example:

 
 // Assuming import static org.jooq.impl.DSL.*;

 using(configuration)
    .select(ACTOR.LAST_NAME)  // Field reference
    .from(ACTOR)
    .groupBy(ACTOR.LAST_NAME) // Field reference
    .orderBy(ACTOR.LAST_NAME) // Field reference
    .fetch();

Instances can be created using a variety of ways, including:

DSL.field(String) and overloads for plain SQL field expression.
DSL.field(Name) and overloads for field identifier references.
DSL.field(Condition) for predicates as fields.
DSL.field(Select) for correlated subqueries.
TableField referenced from generated tables
DSL.val(Object) and overloads to create bind variables explicitly
DSL.inline(Object) and overloads to create inline values (constants, literals) explicitly

Author:: Lukas Eder

Method Summary

Modifier and Type

Method

Description

@NotNull Field<T>

abs()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.abs(Field) instead.

@NotNull Field<BigDecimal>

acos()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.acos(Field) instead.

@NotNull Field<T>

add(Number value)

An arithmetic expression adding this to value.

@NotNull Field<T>

add(Field<?> value)

An arithmetic expression to add value to this.

@NotNull Field<T>

as(String alias)

Create an alias for this field.

@NotNull Field<T>

as(Function<? super Field<T>,? extends String> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Field<T>

as(Field<?> otherField)

Create an alias for this field based on another field's name.

@NotNull Field<T>

as(Name alias)

Create an alias for this field.

@NotNull SortField<T>

asc()

Create an ascending sort field from this field.

@NotNull Field<Integer>

ascii()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.ascii(Field) instead.

@NotNull Field<BigDecimal>

asin()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.asin(Field) instead.

@NotNull Field<BigDecimal>

atan()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.atan(Field) instead.

@NotNull Field<BigDecimal>

atan2(Number y)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.atan2(Field, Number) instead.

@NotNull Field<BigDecimal>

atan2(Field<? extends Number> y)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.atan2(Field, Field) instead.

@NotNull Field<BigDecimal>

avg()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.avg(Field) instead.

@NotNull WindowPartitionByStep<BigDecimal>

avgOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.avg(Field) instead.

@NotNull BetweenAndStep<T>

between(Field<T> minValue)

Create a condition to check this field against some bounds.

@NotNull Condition

between(Field<T> minValue, Field<T> maxValue)

Create a condition to check this field against some bounds.

@NotNull BetweenAndStep<T>

between(T minValue)

Create a condition to check this field against some bounds.

@NotNull Condition

between(T minValue, T maxValue)

Create a condition to check this field against some bounds.

@NotNull BetweenAndStep<T>

betweenSymmetric(Field<T> minValue)

Create a condition to check this field against some bounds.

@NotNull Condition

betweenSymmetric(Field<T> minValue, Field<T> maxValue)

Create a condition to check this field against some bounds.

@NotNull BetweenAndStep<T>

betweenSymmetric(T minValue)

Create a condition to check this field against some bounds.

@NotNull Condition

betweenSymmetric(T minValue, T maxValue)

Create a condition to check this field against some bounds.

@NotNull Condition

binaryLike(byte[] pattern)

The BINARY_LIKE operator.

@NotNull Condition

binaryLike(Field<byte[]> pattern)

The BINARY_LIKE operator.

@NotNull Condition

binaryLike(QuantifiedSelect<? extends Record1<byte[]>> pattern)

The BINARY_LIKE operator.

@NotNull Field<T>

bitAnd(Field<T> arg2)

The BIT_AND operator.

@NotNull Field<T>

bitAnd(T arg2)

The BIT_AND operator.

@NotNull Field<Integer>

bitLength()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.bitLength(Field) instead.

@NotNull Field<T>

bitNand(Field<T> arg2)

The BIT_NAND operator.

@NotNull Field<T>

bitNand(T arg2)

The BIT_NAND operator.

@NotNull Field<T>

bitNor(Field<T> arg2)

The BIT_NOR operator.

@NotNull Field<T>

bitNor(T arg2)

The BIT_NOR operator.

@NotNull Field<T>

bitNot()

The BIT_NOT operator.

@NotNull Field<T>

bitOr(Field<T> arg2)

The BIT_OR operator.

@NotNull Field<T>

bitOr(T arg2)

The BIT_OR operator.

@NotNull Field<T>

bitXNor(Field<T> arg2)

The BIT_XNOR operator.

@NotNull Field<T>

bitXNor(T arg2)

The BIT_XNOR operator.

@NotNull Field<T>

bitXor(Field<T> arg2)

The BIT_XOR operator.

@NotNull Field<T>

bitXor(T arg2)

The BIT_XOR operator.

<Z> @NotNull Field<Z>

cast(Class<Z> type)

Cast this field to another type.

<Z> @NotNull Field<Z>

cast(DataType<Z> type)

Cast this field to a dialect-specific data type.

<Z> @NotNull Field<Z>

cast(Field<Z> field)

Cast this field to the type of another field.

@NotNull Field<T>

ceil()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.ceil(Field) instead.

boolean

changed(Record record)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#12494] - 3.20.0 - Use touched(Record) instead.

@NotNull Field<Integer>

charLength()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.charLength(Field) instead.

@NotNull Field<T>

coalesce(Field<T> option, Field<?>... options)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.coalesce(Field, Field...) instead.

@NotNull Field<T>

coalesce(T option, T... options)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.coalesce(Object, Object...) instead.

<Z> @NotNull Field<Z>

coerce(Class<Z> type)

Coerce this field to another type.

<Z> @NotNull Field<Z>

coerce(DataType<Z> type)

Coerce this field to a dialect-specific data type.

<Z> @NotNull Field<Z>

coerce(Field<Z> field)

Coerce this field to the type of another field.

@NotNull Field<String>

collate(String collation)

Apply a collation operator to this column expression.

@NotNull Field<String>

collate(Collation collation)

Apply a collation operator to this column expression.

@NotNull Field<String>

collate(Name collation)

Apply a collation operator to this column expression.

@NotNull Field<T>

comment(String comment)

Attach a Comment to this field, for use in DDL statements, such as DSLContext.createTable(Table).

@NotNull Field<T>

comment(Comment comment)

Attach a Comment to this field, for use in DDL statements, such as DSLContext.createTable(Table).

@NotNull Condition

compare(Comparator comparator, Field<T> field)

Compare this field with another field using a dynamic comparator.

@NotNull Condition

compare(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query)

Compare this field with a quantified subselect using a dynamic comparator.

@NotNull Condition

compare(Comparator comparator, Select<? extends Record1<T>> query)

Compare this field with a subselect using a dynamic comparator.

@NotNull Condition

compare(Comparator comparator, T value)

Compare this field with a value using a dynamic comparator.

@NotNull Field<String>

concat(char... values)

This method is part of the pre-2.0 API.

@NotNull Field<String>

concat(String... values)

This method is part of the pre-2.0 API.

@NotNull Field<String>

concat(Field<?>... fields)

This method is part of the pre-2.0 API.

@NotNull Condition

contains(Field<T> content)

The CONTAINS operator.

@NotNull Condition

contains(T content)

The CONTAINS operator.

@NotNull Condition

containsIgnoreCase(Field<T> content)

The CONTAINS_IGNORE_CASE operator.

@NotNull Condition

containsIgnoreCase(T content)

The CONTAINS_IGNORE_CASE operator.

 @NotNull Field

convert(Class toType, Function<? super T,? extends U> from, Function<? super U,? extends T> to)

Apply an ad-hoc data type Converter to this field expression.

 @NotNull Field

convert(Binding<T,U> binding)

Apply an ad-hoc data type Binding to this field expression.

 @NotNull Field

convert(Converter<T,U> converter)

Apply an ad-hoc data type Converter to this field expression.

 @NotNull Field

convertFrom(Class toType, Function<? super T,? extends U> from)

Apply an ad-hoc read-only data type Converter to this field expression.

 @NotNull Field

convertFrom(Function<? super T,? extends U> from)

Apply an ad-hoc read-only data type Converter to this field expression.

 @NotNull Field

convertTo(Class toType, Function<? super U,? extends T> to)

Apply an ad-hoc write-only data type Converter to this field expression.

 @NotNull Field

convertTo(Function<? super U,? extends T> to)

Apply an ad-hoc write-only data type Converter to this field expression.

@NotNull Field<BigDecimal>

cos()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.cos(Field) instead.

@NotNull Field<BigDecimal>

cosh()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.cosh(Field) instead.

@NotNull Field<BigDecimal>

cot()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.cot(Field) instead.

@NotNull Field<BigDecimal>

coth()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.coth(Field) instead.

@NotNull Field<Integer>

count()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.count(Field) instead.

@NotNull Field<Integer>

countDistinct()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.countDistinct(Field) instead.

@NotNull WindowPartitionByStep<Integer>

countOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.count(Field) instead.

<Z> @NotNull Field<Z>

decode(Field<T> search, Field<Z> result)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Field, Field, Field) instead.

<Z> @NotNull Field<Z>

decode(Field<T> search, Field<Z> result, Field<?>... more)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Field, Field, Field, Field...) instead.

<Z> @NotNull Field<Z>

decode(T search, Z result)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Object, Object, Object) instead.

<Z> @NotNull Field<Z>

decode(T search, Z result, Object... more)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Object, Object, Object, Object...) instead.

@NotNull Field<BigDecimal>

deg()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.deg(Field) instead.

@NotNull SortField<T>

desc()

Create a descending sort field from this field.

@NotNull Field<T>

div(Number value)

An arithmetic expression dividing this by value.

@NotNull Field<T>

div(Field<? extends Number> value)

An arithmetic expression dividing this by value.

@NotNull Field<T>

divide(Number value)

An alias for div(Number).

@NotNull Field<T>

divide(Field<? extends Number> value)

An alias for div(Field).

@NotNull Condition

endsWith(Field<T> suffix)

The ENDS_WITH operator.

@NotNull Condition

endsWith(T suffix)

The ENDS_WITH operator.

@NotNull Condition

endsWithIgnoreCase(Field<T> suffix)

The ENDS_WITH_IGNORE_CASE operator.

@NotNull Condition

endsWithIgnoreCase(T suffix)

The ENDS_WITH_IGNORE_CASE operator.

@NotNull Condition

eq(Field<T> arg2)

The EQ operator.

@NotNull Condition

eq(QuantifiedSelect<? extends Record1<T>> arg2)

The EQ operator.

@NotNull Condition

eq(Select<? extends Record1<T>> arg2)

The EQ operator.

@NotNull Condition

eq(T arg2)

The EQ operator.

@NotNull Condition

equal(Field<T> arg2)

The EQUAL operator, an alias for the EQ operator.

@NotNull Condition

equal(QuantifiedSelect<? extends Record1<T>> arg2)

The EQUAL operator, an alias for the EQ operator.

@NotNull Condition

equal(Select<? extends Record1<T>> arg2)

The EQUAL operator, an alias for the EQ operator.

@NotNull Condition

equal(T arg2)

The EQUAL operator, an alias for the EQ operator.

@NotNull Condition

equalIgnoreCase(String value)

lower(this) = lower(value).

@NotNull Condition

equalIgnoreCase(Field<String> value)

lower(this) = lower(value).

boolean

equals(Object other)

Check whether this QueryPart can be considered equal to another QueryPart.

@NotNull Field<BigDecimal>

exp()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.exp(Field) instead.

@NotNull Field<Integer>

extract(DatePart datePart)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.extract(Field, DatePart) instead.

@Nullable Field<T>

field(Record record)

The inverse operation of Fields.field(Field).

@NotNull WindowIgnoreNullsStep<T>

firstValue()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.firstValue(Field) instead.

@NotNull Field<T>

floor()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.floor(Field) instead.

@Nullable Record1<T>

from(Record record)

The inverse operation of Record.into(Field).

@NotNull Condition

ge(Field<T> arg2)

The GE operator.

@NotNull Condition

ge(QuantifiedSelect<? extends Record1<T>> arg2)

The GE operator.

@NotNull Condition

ge(Select<? extends Record1<T>> arg2)

The GE operator.

@NotNull Condition

ge(T arg2)

The GE operator.

T

get(Record record)

The inverse operation of Record.get(Field).

@NotNull String

getComment()

The comment given to the field.

@NotNull String

getName()

The name of the field.

T

getValue(Record record)

The inverse operation of Record.getValue(Field).

@NotNull Condition

greaterOrEqual(Field<T> arg2)

The GREATER_OR_EQUAL operator, an alias for the GE operator.

@NotNull Condition

greaterOrEqual(QuantifiedSelect<? extends Record1<T>> arg2)

The GREATER_OR_EQUAL operator, an alias for the GE operator.

@NotNull Condition

greaterOrEqual(Select<? extends Record1<T>> arg2)

The GREATER_OR_EQUAL operator, an alias for the GE operator.

@NotNull Condition

greaterOrEqual(T arg2)

The GREATER_OR_EQUAL operator, an alias for the GE operator.

@NotNull Condition

greaterThan(Field<T> arg2)

The GREATER_THAN operator, an alias for the GT operator.

@NotNull Condition

greaterThan(QuantifiedSelect<? extends Record1<T>> arg2)

The GREATER_THAN operator, an alias for the GT operator.

@NotNull Condition

greaterThan(Select<? extends Record1<T>> arg2)

The GREATER_THAN operator, an alias for the GT operator.

@NotNull Condition

greaterThan(T arg2)

The GREATER_THAN operator, an alias for the GT operator.

@NotNull Field<T>

greatest(Field<?>... others)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.greatest(Field, Field...) instead.

@NotNull Field<T>

greatest(T... others)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.greatest(Field, Field...) instead.

@NotNull Condition

gt(Field<T> arg2)

The GT operator.

@NotNull Condition

gt(QuantifiedSelect<? extends Record1<T>> arg2)

The GT operator.

@NotNull Condition

gt(Select<? extends Record1<T>> arg2)

The GT operator.

@NotNull Condition

gt(T arg2)

The GT operator.

@NotNull Condition

in(Collection<?> values)

Create a condition to check this field against several values.

@NotNull Condition

in(Field<?>... values)

Create a condition to check this field against several values.

@NotNull Condition

in(Result<? extends Record1<T>> result)

Create a condition to check this field against several values from a previous query.

@NotNull Condition

in(Select<? extends Record1<T>> arg2)

The IN operator.

@NotNull Condition

in(T... values)

Create a condition to check this field against several values.

@NotNull Condition

isDistinctFrom(Field<T> arg2)

The IS_DISTINCT_FROM operator.

@NotNull Condition

isDistinctFrom(Select<? extends Record1<T>> arg2)

The IS_DISTINCT_FROM operator.

@NotNull Condition

isDistinctFrom(T arg2)

The IS_DISTINCT_FROM operator.

@NotNull Condition

isDocument()

The IS_DOCUMENT operator.

@NotNull Condition

isFalse()

Create a condition to check this field against known string literals for false.

@NotNull Condition

isJson()

The IS_JSON operator.

@NotNull Condition

isNotDistinctFrom(Field<T> arg2)

The IS_NOT_DISTINCT_FROM operator.

@NotNull Condition

isNotDistinctFrom(Select<? extends Record1<T>> arg2)

The IS_NOT_DISTINCT_FROM operator.

@NotNull Condition

isNotDistinctFrom(T arg2)

The IS_NOT_DISTINCT_FROM operator.

@NotNull Condition

isNotDocument()

The IS_NOT_DOCUMENT operator.

@NotNull Condition

isNotJson()

The IS_NOT_JSON operator.

@NotNull Condition

isNotNull()

The IS_NOT_NULL operator.

@NotNull Condition

isNull()

The IS_NULL operator.

@NotNull Condition

isTrue()

Create a condition to check this field against known string literals for true.

@NotNull WindowIgnoreNullsStep<T>

lag()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lag(Field) instead.

@NotNull WindowIgnoreNullsStep<T>

lag(int offset)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lag(Field, int) instead.

@NotNull WindowIgnoreNullsStep<T>

lag(int offset, Field<T> defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lag(Field, int, Field) instead.

@NotNull WindowIgnoreNullsStep<T>

lag(int offset, T defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lag(Field, int, Object) instead.

@NotNull WindowIgnoreNullsStep<T>

lastValue()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lastValue(Field) instead.

@NotNull Condition

le(Field<T> arg2)

The LE operator.

@NotNull Condition

le(QuantifiedSelect<? extends Record1<T>> arg2)

The LE operator.

@NotNull Condition

le(Select<? extends Record1<T>> arg2)

The LE operator.

@NotNull Condition

le(T arg2)

The LE operator.

@NotNull WindowIgnoreNullsStep<T>

lead()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lead(Field) instead.

@NotNull WindowIgnoreNullsStep<T>

lead(int offset)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lead(Field, int) instead.

@NotNull WindowIgnoreNullsStep<T>

lead(int offset, Field<T> defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lead(Field, int, Field) instead.

@NotNull WindowIgnoreNullsStep<T>

lead(int offset, T defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lead(Field, int, Object) instead.

@NotNull Field<T>

least(Field<?>... others)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.least(Field, Field...) instead.

@NotNull Field<T>

least(T... others)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.least(Field, Field...) instead.

@NotNull Field<Integer>

length()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.length(Field) instead.

@NotNull Condition

lessOrEqual(Field<T> arg2)

The LESS_OR_EQUAL operator, an alias for the LE operator.

@NotNull Condition

lessOrEqual(QuantifiedSelect<? extends Record1<T>> arg2)

The LESS_OR_EQUAL operator, an alias for the LE operator.

@NotNull Condition

lessOrEqual(Select<? extends Record1<T>> arg2)

The LESS_OR_EQUAL operator, an alias for the LE operator.

@NotNull Condition

lessOrEqual(T arg2)

The LESS_OR_EQUAL operator, an alias for the LE operator.

@NotNull Condition

lessThan(Field<T> arg2)

The LESS_THAN operator, an alias for the LT operator.

@NotNull Condition

lessThan(QuantifiedSelect<? extends Record1<T>> arg2)

The LESS_THAN operator, an alias for the LT operator.

@NotNull Condition

lessThan(Select<? extends Record1<T>> arg2)

The LESS_THAN operator, an alias for the LT operator.

@NotNull Condition

lessThan(T arg2)

The LESS_THAN operator, an alias for the LT operator.

@NotNull LikeEscapeStep

like(String pattern)

The LIKE operator.

@NotNull Condition

like(String value, char escape)

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

@NotNull LikeEscapeStep

like(Field<String> pattern)

The LIKE operator.

@NotNull Condition

like(Field<String> value, char escape)

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

@NotNull LikeEscapeStep

like(QuantifiedSelect<? extends Record1<String>> pattern)

The LIKE operator.

@NotNull LikeEscapeStep

likeIgnoreCase(String pattern)

The LIKE_IGNORE_CASE operator.

@NotNull Condition

likeIgnoreCase(String value, char escape)

Create a condition to case-insensitively pattern-check this field against a value.

@NotNull LikeEscapeStep

likeIgnoreCase(Field<String> pattern)

The LIKE_IGNORE_CASE operator.

@NotNull Condition

likeIgnoreCase(Field<String> field, char escape)

Create a condition to case-insensitively pattern-check this field against a field.

@NotNull Condition

likeRegex(String pattern)

Create a condition to regex-pattern-check this field against a pattern.

@NotNull Condition

likeRegex(Field<String> pattern)

Create a condition to regex-pattern-check this field against a pattern.

@NotNull Field<BigDecimal>

ln()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.ln(Field) instead.

@NotNull Field<BigDecimal>

log(int base)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.log(Field, int) instead.

@NotNull Field<String>

lower()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lower(Field) instead.

@NotNull Field<String>

lpad(int length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lpad(Field, int) instead.

@NotNull Field<String>

lpad(int length, char character)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lpad(Field, int, char) instead.

@NotNull Field<String>

lpad(Field<? extends Number> length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lpad(Field, Field) instead.

@NotNull Field<String>

lpad(Field<? extends Number> length, Field<String> character)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lpad(Field, Field, Field) instead.

@NotNull Condition

lt(Field<T> arg2)

The LT operator.

@NotNull Condition

lt(QuantifiedSelect<? extends Record1<T>> arg2)

The LT operator.

@NotNull Condition

lt(Select<? extends Record1<T>> arg2)

The LT operator.

@NotNull Condition

lt(T arg2)

The LT operator.

@NotNull Field<String>

ltrim()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.ltrim(Field) instead.

@NotNull Field<T>

max()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.max(Field) instead.

@NotNull WindowPartitionByStep<T>

maxOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.max(Field) instead.

@NotNull Field<BigDecimal>

median()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.median(Field) instead.

@NotNull Field<T>

min()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.min(Field) instead.

@NotNull WindowPartitionByStep<T>

minOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.min(Field) instead.

@NotNull Field<T>

minus(Number value)

An alias for sub(Number).

@NotNull Field<T>

minus(Field<?> value)

An alias for sub(Field).

@NotNull Field<T>

mod(Number divisor)

The MOD operator.

@NotNull Field<T>

mod(Field<? extends Number> divisor)

The MOD operator.

@NotNull Field<T>

modulo(Number divisor)

The MODULO operator, an alias for the MOD operator.

@NotNull Field<T>

modulo(Field<? extends Number> divisor)

The MODULO operator, an alias for the MOD operator.

@NotNull Field<T>

mul(Number value)

An arithmetic expression multiplying this with value.

@NotNull Field<T>

mul(Field<? extends Number> value)

An arithmetic expression multiplying this with value.

@NotNull Field<T>

multiply(Number value)

An alias for mul(Number).

@NotNull Field<T>

multiply(Field<? extends Number> value)

An alias for mul(Field).

@NotNull Condition

ne(Field<T> arg2)

The NE operator.

@NotNull Condition

ne(QuantifiedSelect<? extends Record1<T>> arg2)

The NE operator.

@NotNull Condition

ne(Select<? extends Record1<T>> arg2)

The NE operator.

@NotNull Condition

ne(T arg2)

The NE operator.

@NotNull Field<T>

neg()

Negate this field to get its negative value.

@NotNull BetweenAndStep<T>

notBetween(Field<T> minValue)

Create a condition to check this field against some bounds.

@NotNull Condition

notBetween(Field<T> minValue, Field<T> maxValue)

Create a condition to check this field against some bounds.

@NotNull BetweenAndStep<T>

notBetween(T minValue)

Create a condition to check this field against some bounds.

@NotNull Condition

notBetween(T minValue, T maxValue)

Create a condition to check this field against some bounds.

@NotNull BetweenAndStep<T>

notBetweenSymmetric(Field<T> minValue)

Create a condition to check this field against some bounds.

@NotNull Condition

notBetweenSymmetric(Field<T> minValue, Field<T> maxValue)

Create a condition to check this field against some bounds.

@NotNull BetweenAndStep<T>

notBetweenSymmetric(T minValue)

Create a condition to check this field against some bounds.

@NotNull Condition

notBetweenSymmetric(T minValue, T maxValue)

Create a condition to check this field against some bounds.

@NotNull Condition

notBinaryLike(byte[] pattern)

The NOT_BINARY_LIKE operator.

@NotNull Condition

notBinaryLike(Field<byte[]> pattern)

The NOT_BINARY_LIKE operator.

@NotNull Condition

notBinaryLike(QuantifiedSelect<? extends Record1<byte[]>> pattern)

The NOT_BINARY_LIKE operator.

@NotNull Condition

notContains(Field<T> value)

Inverse of contains(Field).

@NotNull Condition

notContains(T value)

Inverse of contains(Object).

@NotNull Condition

notContainsIgnoreCase(Field<T> value)

Inverse of containsIgnoreCase(Field)

@NotNull Condition

notContainsIgnoreCase(T value)

Inverse of containsIgnoreCase(Object)

@NotNull Condition

notEqual(Field<T> arg2)

The NOT_EQUAL operator, an alias for the NE operator.

@NotNull Condition

notEqual(QuantifiedSelect<? extends Record1<T>> arg2)

The NOT_EQUAL operator, an alias for the NE operator.

@NotNull Condition

notEqual(Select<? extends Record1<T>> arg2)

The NOT_EQUAL operator, an alias for the NE operator.

@NotNull Condition

notEqual(T arg2)

The NOT_EQUAL operator, an alias for the NE operator.

@NotNull Condition

notEqualIgnoreCase(String value)

lower(this) != lower(value).

@NotNull Condition

notEqualIgnoreCase(Field<String> value)

lower(this) != lower(value).

@NotNull Condition

notIn(Collection<?> values)

Create a condition to check this field against several values.

@NotNull Condition

notIn(Field<?>... values)

Create a condition to check this field against several values.

@NotNull Condition

notIn(Result<? extends Record1<T>> result)

Create a condition to check this field against several values from a previous query.

@NotNull Condition

notIn(Select<? extends Record1<T>> arg2)

The NOT_IN operator.

@NotNull Condition

notIn(T... values)

Create a condition to check this field against several values.

@NotNull LikeEscapeStep

notLike(String pattern)

The NOT_LIKE operator.

@NotNull Condition

notLike(String value, char escape)

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

@NotNull LikeEscapeStep

notLike(Field<String> pattern)

The NOT_LIKE operator.

@NotNull Condition

notLike(Field<String> field, char escape)

Create a condition to pattern-check this field against a field.

@NotNull LikeEscapeStep

notLike(QuantifiedSelect<? extends Record1<String>> pattern)

The NOT_LIKE operator.

@NotNull LikeEscapeStep

notLikeIgnoreCase(String pattern)

The NOT_LIKE_IGNORE_CASE operator.

@NotNull Condition

notLikeIgnoreCase(String value, char escape)

Create a condition to case-insensitively pattern-check this field against a value.

@NotNull LikeEscapeStep

notLikeIgnoreCase(Field<String> pattern)

The NOT_LIKE_IGNORE_CASE operator.

@NotNull Condition

notLikeIgnoreCase(Field<String> field, char escape)

Create a condition to case-insensitively pattern-check this field against a field.

@NotNull Condition

notLikeRegex(String pattern)

Create a condition to regex-pattern-check this field against a pattern.

@NotNull Condition

notLikeRegex(Field<String> pattern)

Create a condition to regex-pattern-check this field against a pattern.

@NotNull LikeEscapeStep

notSimilarTo(String pattern)

The NOT_SIMILAR_TO operator.

@NotNull Condition

notSimilarTo(String value, char escape)

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

@NotNull LikeEscapeStep

notSimilarTo(Field<String> pattern)

The NOT_SIMILAR_TO operator.

@NotNull Condition

notSimilarTo(Field<String> field, char escape)

Create a condition to pattern-check this field against a field.

@NotNull LikeEscapeStep

notSimilarTo(QuantifiedSelect<? extends Record1<String>> pattern)

The NOT_SIMILAR_TO operator.

@NotNull Field<T>

nullif(Field<T> other)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nullif(Field, Field) instead.

@NotNull Field<T>

nullif(T other)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nullif(Field, Object) instead.

@NotNull SortField<T>

nullsFirst()

Convenience method for sortDefault() and then SortField.nullsFirst().

@NotNull SortField<T>

nullsLast()

Convenience method for sortDefault() and then SortField.nullsLast().

@NotNull Field<T>

nvl(Field<T> defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nvl(Field, Field) instead.

@NotNull Field<T>

nvl(T defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nvl(Field, Object) instead.

<Z> @NotNull Field<Z>

nvl2(Field<Z> valueIfNotNull, Field<Z> valueIfNull)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nvl2(Field, Field, Field) instead.

<Z> @NotNull Field<Z>

nvl2(Z valueIfNotNull, Z valueIfNull)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nvl2(Field, Object, Object) instead.

@NotNull Field<Integer>

octetLength()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.octetLength(Field) instead.

T

original(Record record)

The inverse operation of Record.original(Field).

@NotNull Field<T>

plus()

The PLUS operator.

@NotNull Field<T>

plus(Number value)

An alias for add(Number).

@NotNull Field<T>

plus(Field<?> value)

An alias for add(Field).

@NotNull Field<Integer>

position(String search)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.position(Field, String) instead.

@NotNull Field<Integer>

position(Field<String> search)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.position(Field, Field) instead.

@NotNull Field<BigDecimal>

pow(Number exponent)

The POW operator, an alias for the POWER operator.

@NotNull Field<BigDecimal>

pow(Field<? extends Number> exponent)

The POW operator, an alias for the POWER operator.

@NotNull Field<BigDecimal>

power(Number exponent)

The POWER operator.

@NotNull Field<BigDecimal>

power(Field<? extends Number> exponent)

The POWER operator.

@NotNull Field<BigDecimal>

rad()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.rad(Field) instead.

@NotNull Field<T>

rem(Number divisor)

The REM operator, an alias for the MOD operator.

@NotNull Field<T>

rem(Field<? extends Number> divisor)

The REM operator, an alias for the MOD operator.

@NotNull Field<String>

repeat(Number count)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.repeat(Field, int) instead.

@NotNull Field<String>

repeat(Field<? extends Number> count)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.repeat(Field, Field) instead.

@NotNull Field<String>

replace(String search)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.replace(Field, String) instead.

@NotNull Field<String>

replace(String search, String replace)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.replace(Field, String, String) instead.

@NotNull Field<String>

replace(Field<String> search)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.replace(Field, Field) instead.

@NotNull Field<String>

replace(Field<String> search, Field<String> replace)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.replace(Field, Field, Field) instead.

void

reset(Record record)

The inverse operation of Record.reset(Field).

@NotNull Field<T>

round()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.round(Field) instead.

@NotNull Field<T>

round(int decimals)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.round(Field, int) instead.

@NotNull Field<String>

rpad(int length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rpad(Field, int) instead.

@NotNull Field<String>

rpad(int length, char character)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rpad(Field, int, char) instead.

@NotNull Field<String>

rpad(Field<? extends Number> length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rpad(Field, Field) instead.

@NotNull Field<String>

rpad(Field<? extends Number> length, Field<String> character)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rpad(Field, Field, Field) instead.

@NotNull Field<String>

rtrim()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rtrim(Field) instead.

@NotNull Field<T>

shl(Number count)

The SHL operator.

@NotNull Field<T>

shl(Field<? extends Number> count)

The SHL operator.

@NotNull Field<T>

shr(Number count)

The SHR operator.

@NotNull Field<T>

shr(Field<? extends Number> count)

The SHR operator.

@NotNull Field<Integer>

sign()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sign(Field) instead.

@NotNull LikeEscapeStep

similarTo(String pattern)

The SIMILAR_TO operator.

@NotNull Condition

similarTo(String value, char escape)

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

@NotNull LikeEscapeStep

similarTo(Field<String> pattern)

The SIMILAR_TO operator.

@NotNull Condition

similarTo(Field<String> value, char escape)

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

@NotNull LikeEscapeStep

similarTo(QuantifiedSelect<? extends Record1<String>> pattern)

The SIMILAR_TO operator.

@NotNull Field<BigDecimal>

sin()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sin(Field) instead.

@NotNull Field<BigDecimal>

sinh()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sinh(Field) instead.

<Z> @NotNull SortField<Z>

sort(Map<T,Z> sortMap)

Create an indirected sort field.

@NotNull SortField<T>

sort(SortOrder order)

Create an ascending/descending sort field from this field.

@NotNull SortField<Integer>

sortAsc(Collection<T> sortList)

Create an indirected sort field.

@NotNull SortField<Integer>

sortAsc(T... sortList)

Create an indirected sort field.

@NotNull SortField<T>

sortDefault()

Create a default sorted (implicit ASC) from this field.

@NotNull SortField<Integer>

sortDesc(Collection<T> sortList)

Create an indirected sort field.

@NotNull SortField<Integer>

sortDesc(T... sortList)

Create an indirected sort field.

@NotNull Field<BigDecimal>

sqrt()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sqrt(Field) instead.

@NotNull Condition

startsWith(Field<T> prefix)

The STARTS_WITH operator.

@NotNull Condition

startsWith(T prefix)

The STARTS_WITH operator.

@NotNull Condition

startsWithIgnoreCase(Field<T> prefix)

The STARTS_WITH_IGNORE_CASE operator.

@NotNull Condition

startsWithIgnoreCase(T prefix)

The STARTS_WITH_IGNORE_CASE operator.

@NotNull Field<BigDecimal>

stddevPop()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.stddevPop(Field) instead.

@NotNull WindowPartitionByStep<BigDecimal>

stddevPopOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.stddevPop(Field) instead.

@NotNull Field<BigDecimal>

stddevSamp()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.stddevSamp(Field) instead.

@NotNull WindowPartitionByStep<BigDecimal>

stddevSampOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.stddevSamp(Field) instead.

@NotNull Field<T>

sub(Number value)

An arithmetic expression subtracting value from this.

@NotNull Field<T>

sub(Field<?> value)

An arithmetic expression subtracting value from this.

@NotNull Field<String>

substring(int startingPosition)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.substring(Field, int) instead.

@NotNull Field<String>

substring(int startingPosition, int length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.substring(Field, int, int) instead.

@NotNull Field<String>

substring(Field<? extends Number> startingPosition)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.substring(Field, Field) instead.

@NotNull Field<String>

substring(Field<? extends Number> startingPosition, Field<? extends Number> length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.substring(Field, Field, Field) instead.

@NotNull Field<T>

subtract(Number value)

An alias for sub(Number).

@NotNull Field<T>

subtract(Field<?> value)

An alias for sub(Field).

@NotNull Field<BigDecimal>

sum()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sum(Field) instead.

@NotNull WindowPartitionByStep<BigDecimal>

sumOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sum(Field) instead.

@NotNull Field<BigDecimal>

tan()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.tan(Field) instead.

@NotNull Field<BigDecimal>

tanh()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.tanh(Field) instead.

@NotNull Field<T>

times(Number value)

An alias for mul(Number).

@NotNull Field<T>

times(Field<? extends Number> value)

An alias for mul(Field).

boolean

touched(Record record)

The inverse operation of Record.touched(Field).

@NotNull Field<String>

trim()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.trim(Field) instead.

@NotNull Field<T>

unaryMinus()

Negate this field to get its negative value.

@NotNull Field<T>

unaryPlus()

Get this field as its positive value (no effect on SQL).

@NotNull Field<String>

upper()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.upper(Field) instead.

@NotNull Field<BigDecimal>

varPop()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.varPop(Field) instead.

@NotNull WindowPartitionByStep<BigDecimal>

varPopOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.varPop(Field) instead.

@NotNull Field<BigDecimal>

varSamp()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.varSamp(Field) instead.

@NotNull WindowPartitionByStep<BigDecimal>

varSampOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.varSamp(Field) instead.

Methods inherited from interface org.jooq.Named
$name, getCommentPart, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart
$replace, $replace, $traverse, $traverse, hashCode, toString

Methods inherited from interface org.jooq.Typed
$dataType, getBinding, getConverter, getDataType, getDataType, getType

Method Details

getName

@NotNull @NotNull String getName()
The name of the field.
The name is any of these:
- The formal name of the field, if it is a physical table/view field
- The alias of an aliased field
- A generated / unspecified value for any other expression
- The name of a parameter if it is a named Param
Specified by:

getName in interface Named
getComment

@NotNull @NotNull String getComment()

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

Specified by:

getComment in interface Named
as

@Deprecated(forRemoval=true, since="3.14") @NotNull @Support @NotNull Field<T> as(Function<? super Field<T>,? extends String> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ. They offer convenience that is unidiomatic for jOOQ's DSL, without offering functionality that would not be possible otherwise - yet they add complexity in jOOQ's internals.
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 as(String), except that field aliases are provided by a function. This is useful, for instance, to prefix all columns with a common prefix (on Table.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());
 
```
equals

boolean equals(Object other)

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

Specified by:

equals in interface QueryPart

Overrides:

equals in class Object

Parameters:

other - The other QueryPart

Returns:

Whether the two query parts are equal
as

@NotNull @Support @NotNull Field<T> as(String alias)

Description copied from interface: SelectField

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

Specified by:

as in interface SelectField<T>

Parameters:

alias - The alias name

Returns:

The field alias
as

@NotNull @Support @NotNull Field<T> as(Name alias)

Description copied from interface: SelectField

Create an alias for this field.
Note that the case-sensitivity of the returned field depends on Settings.getRenderQuotedNames() and the Name. By default, field aliases are quoted, and thus case-sensitive in many SQL dialects - use DSL.unquotedName(String...) for case-insensitive aliases.
If the argument Name.getName() is qualified, then the Name.last() part will be used.

Specified by:

as in interface SelectField<T>

Parameters:

alias - The alias name

Returns:

The field alias
as

@NotNull @Support @NotNull Field<T> as(Field<?> otherField)

Description copied from interface: SelectField

Create an alias for this field based on another field's name.

Specified by:

as in interface SelectField<T>

Parameters:

otherField - The other field whose name this field is aliased with.

Returns:

The field alias.
convert

@NotNull @NotNull Field convert(Binding<T,U> binding)

Description copied from interface: SelectField

Apply an ad-hoc data type Binding to this field expression.
Rather than attaching data type bindings at code generation time, or creating cumbersome expressions using DataType.asConvertedDataType(Binding), this method allows for creating a derived field expression with an ad-hoc data type binding for single query usage.

Specified by:

convert in interface SelectField<T>

Type Parameters:

U - The user type.

Parameters:

binding - The binding to be applied on any operations using this field.

Returns:

A derived field expression using a new binding.
convert

@NotNull @NotNull Field convert(Converter<T,U> converter)

Description copied from interface: SelectField

Apply an ad-hoc data type Converter to this field expression.
Rather than attaching data type converters at code generation time, or creating cumbersome expressions using DataType.asConvertedDataType(Converter), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.

Specified by:

convert in interface SelectField<T>

Type Parameters:

U - The user type.

Parameters:

converter - The converter to be applied on any operations using this field.

Returns:

A derived field expression using a new converter.
convert

@NotNull @NotNull Field convert(Class toType, Function<? super T,? extends U> from, Function<? super U,? extends T> to)

Description copied from interface: SelectField

Apply an ad-hoc data type Converter to this field expression.
Rather than attaching data type converters at code generation time, or creating cumbersome expressions using DataType.asConvertedDataType(Class, Function, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.

Specified by:

convert in interface SelectField<T>

Type Parameters:

U - The user type.

Returns:

A derived field expression using a new converter.
convertFrom

@NotNull @NotNull Field convertFrom(Class toType, Function<? super T,? extends U> from)

Description copied from interface: SelectField

Apply an ad-hoc read-only data type Converter to this field expression.
Rather than attaching data type converters at code generation time, or creating cumbersome expressions using DataType.asConvertedDataTypeFrom(Class, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.

Specified by:

convertFrom in interface SelectField<T>

Type Parameters:

U - The user type.

Returns:

A derived field expression using a new converter.
convertFrom

@NotNull @NotNull Field convertFrom(Function<? super T,? extends U> from)

Description copied from interface: SelectField

Apply an ad-hoc read-only data type Converter to this field expression.
Rather than attaching data type converters at code generation time, or creating cumbersome expressions using DataType.asConvertedDataTypeFrom(Class, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.
Unlike SelectField.convertFrom(Class, Function), this method attempts to work without an explicit Class reference for the underlying Converter.toType(). There may be some edge cases where this doesn't work, e.g. when nesting rows in arrays, the class literal is required for reflective array creation.

Specified by:

convertFrom in interface SelectField<T>

Type Parameters:

U - The user type.

Returns:

A derived field expression using a new converter.
convertTo

@NotNull @NotNull Field convertTo(Class toType, Function<? super U,? extends T> to)

Description copied from interface: SelectField

Apply an ad-hoc write-only data type Converter to this field expression.
Rather than attaching data type converters at code generation time, or creating cumbersome expressions using DataType.asConvertedDataTypeTo(Class, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.

Specified by:

convertTo in interface SelectField<T>

Type Parameters:

U - The user type.

Returns:

A derived field expression using a new converter.
convertTo

@NotNull @NotNull Field convertTo(Function<? super U,? extends T> to)

Description copied from interface: SelectField

Apply an ad-hoc write-only data type Converter to this field expression.
Rather than attaching data type converters at code generation time, or creating cumbersome expressions using DataType.asConvertedDataTypeTo(Class, Function), this method allows for creating a derived field expression with an ad-hoc data type converter for single query usage.
Unlike SelectField.convertTo(Class, Function), this method attempts to work without an explicit Class reference for the underlying Converter.toType(). There may be some edge cases where this doesn't work, e.g. when nesting rows in arrays, the class literal is required for reflective array creation.

Specified by:

convertTo in interface SelectField<T>

Type Parameters:

U - The user type.

Returns:

A derived field expression using a new converter.
comment

@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLSERVER,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<T> comment(String comment)

Attach a Comment to this field, for use in DDL statements, such as DSLContext.createTable(Table).
comment

@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLSERVER,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<T> comment(Comment comment)

Attach a Comment to this field, for use in DDL statements, such as DSLContext.createTable(Table).
cast

@NotNull @Support <Z> @NotNull Field<Z> cast(Field<Z> field)

Cast this field to the type of another field.
Casting converts expressions between data types directly in SQL using SQL CAST expressions or similar. If you want to convert data types only in jOOQ without any effect on generated SQL, you can use coerce(Field) instead.
Type Parameters:

Z - The generic type of the cast field

Parameters:

field - The field whose type is used for the cast

Returns:

The cast field

See Also:
- cast(DataType)
cast

@NotNull @Support <Z> @NotNull Field<Z> cast(DataType<Z> type)

Cast this field to a dialect-specific data type.
Casting converts expressions between data types directly in SQL using SQL CAST expressions or similar. If you want to convert data types only in jOOQ without any effect on generated SQL, you can use coerce(DataType) instead.

Type Parameters:

Z - The generic type of the cast field

Parameters:

type - The data type that is used for the cast

Returns:

The cast field
cast

@NotNull @Support <Z> @NotNull Field<Z> cast(Class<Z> type)

Cast this field to another type.
Casting converts expressions between data types directly in SQL using SQL CAST expressions or similar. If you want to convert data types only in jOOQ without any effect on generated SQL, you can use coerce(Class) instead.
The actual cast may not be accurate as the DataType has to be "guessed" from the jOOQ-configured data types. Use cast(DataType) for more accurate casts.
NOTE [#15286]: It is strongly recommended to pass only Class references of types supported by jOOQ internally, i.e. types from SQLDataType. If you're using any custom data types by means of a Converter or Binding, it's better to pass that converted DataType reference explicitly to cast(DataType).
Type Parameters:

Z - The generic type of the cast field

Parameters:

type - The type that is used for the cast

Returns:

The cast field

See Also:
- cast(DataType)

coerce

@NotNull @Support <Z> @NotNull Field<Z> coerce(Field<Z> field)

Coerce this field to the type of another field.

Unlike with cast(Field), 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,
 // where a String is expected
 DSL.val(1).coerce(VARCHAR);

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

Other Field types

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

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

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:

coerce

@NotNull @Support <Z> @NotNull Field<Z> coerce(DataType<Z> type)

Coerce this field to a dialect-specific data type.

Unlike with cast(DataType), 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,
 // where a String is expected
 DSL.val(1).coerce(VARCHAR);

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

Other Field types

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

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

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:

coerce

@NotNull @Support <Z> @NotNull Field<Z> coerce(Class<Z> type)
Coerce this field to another type.
Unlike with cast(Class), 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,
 // where a String is expected
 DSL.val(1).coerce(VARCHAR);

 // This binds an int value to a JDBC PreparedStatement
 // and casts it to VARCHAR in SQL
 DSL.val(1).cast(VARCHAR);
 
 
```
Other Field types
```
 
 // This fetches a String value for the BOOK.ID field from JDBC
 BOOK.ID.coerce(VARCHAR);

 // This fetches a String value for the BOOK.ID field from JDBC
 // after casting it to VARCHAR in the database
 BOOK.ID.cast(VARCHAR);
 
 
```
NOTE [#15286]: It is strongly recommended to pass only Class references of types supported by jOOQ internally, i.e. types from SQLDataType. If you're using any custom data types by means of a Converter or Binding, it's better to pass that converted DataType reference explicitly to coerce(DataType).
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:
- coerce(DataType)
- cast(Class)
asc

@NotNull @Support @NotNull SortField<T> asc()

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

Returns:

This field as an ascending sort field
desc

@NotNull @Support @NotNull SortField<T> desc()

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

Returns:

This field as a descending sort field
sortDefault

@NotNull @Support @NotNull SortField<T> sortDefault()

Create a default sorted (implicit ASC) from this field.
This is the same as calling sort(SortOrder) with SortOrder.DEFAULT

Returns:

This field as a default sorted sort field
sort

@NotNull @Support @NotNull SortField<T> sort(SortOrder order)

Create an ascending/descending sort field from this field.

Parameters:

order - The sort order

Returns:

This field as an ascending/descending sort field.
sortAsc

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

sortList - The list containing sort value preferences

Returns:

The sort field
sortAsc

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

sortList - The list containing sort value preferences

Returns:

The sort field
sortDesc

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

sortList - The list containing sort value preferences

Returns:

The sort field
sortDesc

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

sortList - The list containing sort value preferences

Returns:

The sort field
sort

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

sortMap - The list containing sort value preferences

Returns:

The sort field
nullsFirst

@NotNull @Support @NotNull SortField<T> nullsFirst()

Convenience method for sortDefault() and then SortField.nullsFirst().
nullsLast

@NotNull @Support @NotNull SortField<T> nullsLast()

Convenience method for sortDefault() and then SortField.nullsLast().
binaryLike

@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) @NotNull Condition binaryLike(byte[] pattern)

The BINARY_LIKE operator.
The LIKE operator for binary strings
binaryLike

@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) @NotNull Condition binaryLike(Field<byte[]> pattern)

The BINARY_LIKE operator.
The LIKE operator for binary strings
binaryLike

@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) @NotNull Condition binaryLike(QuantifiedSelect<? extends Record1<byte[]>> pattern)

The BINARY_LIKE operator.
The LIKE operator for binary strings
eq

@NotNull @Support @NotNull Condition eq(T arg2)

The EQ operator.
eq

@NotNull @Support @NotNull Condition eq(Select<? extends Record1<T>> arg2)

The EQ operator.
eq

@NotNull @Support @NotNull Condition eq(Field<T> arg2)

The EQ operator.
eq

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Condition eq(QuantifiedSelect<? extends Record1<T>> arg2)

The EQ operator.
equal

@NotNull @Support @NotNull Condition equal(T arg2)

The EQUAL operator, an alias for the EQ operator.
equal

@NotNull @Support @NotNull Condition equal(Select<? extends Record1<T>> arg2)

The EQUAL operator, an alias for the EQ operator.
equal

@NotNull @Support @NotNull Condition equal(Field<T> arg2)

The EQUAL operator, an alias for the EQ operator.
equal

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Condition equal(QuantifiedSelect<? extends Record1<T>> arg2)

The EQUAL operator, an alias for the EQ operator.
ge

@NotNull @Support @NotNull Condition ge(T arg2)

The GE operator.
ge

@NotNull @Support @NotNull Condition ge(Select<? extends Record1<T>> arg2)

The GE operator.
ge

@NotNull @Support @NotNull Condition ge(Field<T> arg2)

The GE operator.
ge

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Condition ge(QuantifiedSelect<? extends Record1<T>> arg2)

The GE operator.
greaterOrEqual

@NotNull @Support @NotNull Condition greaterOrEqual(T arg2)

The GREATER_OR_EQUAL operator, an alias for the GE operator.
greaterOrEqual

@NotNull @Support @NotNull Condition greaterOrEqual(Select<? extends Record1<T>> arg2)

The GREATER_OR_EQUAL operator, an alias for the GE operator.
greaterOrEqual

@NotNull @Support @NotNull Condition greaterOrEqual(Field<T> arg2)

The GREATER_OR_EQUAL operator, an alias for the GE operator.
greaterOrEqual

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Condition greaterOrEqual(QuantifiedSelect<? extends Record1<T>> arg2)

The GREATER_OR_EQUAL operator, an alias for the GE operator.
greaterThan

@NotNull @Support @NotNull Condition greaterThan(T arg2)

The GREATER_THAN operator, an alias for the GT operator.
greaterThan

@NotNull @Support @NotNull Condition greaterThan(Select<? extends Record1<T>> arg2)

The GREATER_THAN operator, an alias for the GT operator.
greaterThan

@NotNull @Support @NotNull Condition greaterThan(Field<T> arg2)

The GREATER_THAN operator, an alias for the GT operator.
greaterThan

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Condition greaterThan(QuantifiedSelect<? extends Record1<T>> arg2)

The GREATER_THAN operator, an alias for the GT operator.
gt

@NotNull @Support @NotNull Condition gt(T arg2)

The GT operator.
gt

@NotNull @Support @NotNull Condition gt(Select<? extends Record1<T>> arg2)

The GT operator.
gt

@NotNull @Support @NotNull Condition gt(Field<T> arg2)

The GT operator.
gt

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Condition gt(QuantifiedSelect<? extends Record1<T>> arg2)

The GT operator.
in

@NotNull @Support @NotNull Condition in(Select<? extends Record1<T>> arg2)

The IN operator.
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.
isDistinctFrom

@NotNull @Support @NotNull Condition isDistinctFrom(T arg2)

The IS_DISTINCT_FROM operator.
The DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for non-equality
isDistinctFrom

@NotNull @Support @NotNull Condition isDistinctFrom(Select<? extends Record1<T>> arg2)

The IS_DISTINCT_FROM operator.
The DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for non-equality
isDistinctFrom

@NotNull @Support @NotNull Condition isDistinctFrom(Field<T> arg2)

The IS_DISTINCT_FROM operator.
The DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for non-equality
isNull

@NotNull @Support @NotNull Condition isNull()

The IS_NULL operator.
isNotDistinctFrom

@NotNull @Support @NotNull Condition isNotDistinctFrom(T arg2)

The IS_NOT_DISTINCT_FROM operator.
The NOT DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for equality
isNotDistinctFrom

@NotNull @Support @NotNull Condition isNotDistinctFrom(Select<? extends Record1<T>> arg2)

The IS_NOT_DISTINCT_FROM operator.
The NOT DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for equality
isNotDistinctFrom

@NotNull @Support @NotNull Condition isNotDistinctFrom(Field<T> arg2)

The IS_NOT_DISTINCT_FROM operator.
The NOT DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for equality
isNotNull

@NotNull @Support @NotNull Condition isNotNull()

The IS_NOT_NULL operator.
le

@NotNull @Support @NotNull Condition le(T arg2)

The LE operator.
le

@NotNull @Support @NotNull Condition le(Select<? extends Record1<T>> arg2)

The LE operator.
le

@NotNull @Support @NotNull Condition le(Field<T> arg2)

The LE operator.
le

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Condition le(QuantifiedSelect<? extends Record1<T>> arg2)

The LE operator.
lessOrEqual

@NotNull @Support @NotNull Condition lessOrEqual(T arg2)

The LESS_OR_EQUAL operator, an alias for the LE operator.
lessOrEqual

@NotNull @Support @NotNull Condition lessOrEqual(Select<? extends Record1<T>> arg2)

The LESS_OR_EQUAL operator, an alias for the LE operator.
lessOrEqual

@NotNull @Support @NotNull Condition lessOrEqual(Field<T> arg2)

The LESS_OR_EQUAL operator, an alias for the LE operator.
lessOrEqual

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Condition lessOrEqual(QuantifiedSelect<? extends Record1<T>> arg2)

The LESS_OR_EQUAL operator, an alias for the LE operator.
lessThan

@NotNull @Support @NotNull Condition lessThan(T arg2)

The LESS_THAN operator, an alias for the LT operator.
lessThan

@NotNull @Support @NotNull Condition lessThan(Select<? extends Record1<T>> arg2)

The LESS_THAN operator, an alias for the LT operator.
lessThan

@NotNull @Support @NotNull Condition lessThan(Field<T> arg2)

The LESS_THAN operator, an alias for the LT operator.
lessThan

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Condition lessThan(QuantifiedSelect<? extends Record1<T>> arg2)

The LESS_THAN operator, an alias for the LT operator.
like

@NotNull @Support @NotNull LikeEscapeStep like(@Param String pattern)

The LIKE operator.

Parameters:

pattern - is wrapped as DSL.val(Object).
like

@NotNull @Support @NotNull LikeEscapeStep like(Field<String> pattern)

The LIKE operator.
like

@NotNull @Support @NotNull LikeEscapeStep like(QuantifiedSelect<? extends Record1<String>> pattern)

The LIKE operator.
likeIgnoreCase

@NotNull @Support @NotNull LikeEscapeStep likeIgnoreCase(@Param String pattern)

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

Parameters:

pattern - is wrapped as DSL.val(Object).
likeIgnoreCase

@NotNull @Support @NotNull LikeEscapeStep likeIgnoreCase(Field<String> pattern)

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

@NotNull @Support @NotNull Condition lt(T arg2)

The LT operator.
lt

@NotNull @Support @NotNull Condition lt(Select<? extends Record1<T>> arg2)

The LT operator.
lt

@NotNull @Support @NotNull Condition lt(Field<T> arg2)

The LT operator.
lt

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Condition lt(QuantifiedSelect<? extends Record1<T>> arg2)

The LT operator.
ne

@NotNull @Support @NotNull Condition ne(T arg2)

The NE operator.
ne

@NotNull @Support @NotNull Condition ne(Select<? extends Record1<T>> arg2)

The NE operator.
ne

@NotNull @Support @NotNull Condition ne(Field<T> arg2)

The NE operator.
ne

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Condition ne(QuantifiedSelect<? extends Record1<T>> arg2)

The NE operator.
notBinaryLike

@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) @NotNull Condition notBinaryLike(byte[] pattern)

The NOT_BINARY_LIKE operator.
The NOT LIKE operator for binary strings
notBinaryLike

@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) @NotNull Condition notBinaryLike(Field<byte[]> pattern)

The NOT_BINARY_LIKE operator.
The NOT LIKE operator for binary strings
notBinaryLike

@NotNull @Support({AURORA_POSTGRES,POSTGRES,YUGABYTEDB}) @NotNull Condition notBinaryLike(QuantifiedSelect<? extends Record1<byte[]>> pattern)

The NOT_BINARY_LIKE operator.
The NOT LIKE operator for binary strings
notEqual

@NotNull @Support @NotNull Condition notEqual(T arg2)

The NOT_EQUAL operator, an alias for the NE operator.
notEqual

@NotNull @Support @NotNull Condition notEqual(Select<? extends Record1<T>> arg2)

The NOT_EQUAL operator, an alias for the NE operator.
notEqual

@NotNull @Support @NotNull Condition notEqual(Field<T> arg2)

The NOT_EQUAL operator, an alias for the NE operator.
notEqual

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Condition notEqual(QuantifiedSelect<? extends Record1<T>> arg2)

The NOT_EQUAL operator, an alias for the NE operator.
notIn

@NotNull @Support @NotNull Condition notIn(Select<? extends Record1<T>> arg2)

The NOT_IN operator.
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.
If any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well. This is standard SQL behaviour.
notLike

@NotNull @Support @NotNull LikeEscapeStep notLike(@Param String pattern)

The NOT_LIKE operator.

Parameters:

pattern - is wrapped as DSL.val(Object).
notLike

@NotNull @Support @NotNull LikeEscapeStep notLike(Field<String> pattern)

The NOT_LIKE operator.
notLike

@NotNull @Support @NotNull LikeEscapeStep notLike(QuantifiedSelect<? extends Record1<String>> pattern)

The NOT_LIKE operator.
notLikeIgnoreCase

@NotNull @Support @NotNull LikeEscapeStep notLikeIgnoreCase(@Param String pattern)

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

Parameters:

pattern - is wrapped as DSL.val(Object).
notLikeIgnoreCase

@NotNull @Support @NotNull LikeEscapeStep notLikeIgnoreCase(Field<String> pattern)

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

@NotNull @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DUCKDB,EXASOL,FIREBIRD,IGNITE,POSTGRES,SNOWFLAKE,YUGABYTEDB}) @NotNull LikeEscapeStep notSimilarTo(@Param String pattern)

The NOT_SIMILAR_TO operator.

Parameters:

pattern - is wrapped as DSL.val(Object).
notSimilarTo

@NotNull @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DUCKDB,EXASOL,FIREBIRD,IGNITE,POSTGRES,SNOWFLAKE,YUGABYTEDB}) @NotNull LikeEscapeStep notSimilarTo(Field<String> pattern)

The NOT_SIMILAR_TO operator.
notSimilarTo

@NotNull @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DUCKDB,EXASOL,FIREBIRD,IGNITE,POSTGRES,SNOWFLAKE,YUGABYTEDB}) @NotNull LikeEscapeStep notSimilarTo(QuantifiedSelect<? extends Record1<String>> pattern)

The NOT_SIMILAR_TO operator.
similarTo

@NotNull @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DUCKDB,EXASOL,FIREBIRD,IGNITE,POSTGRES,SNOWFLAKE,YUGABYTEDB}) @NotNull LikeEscapeStep similarTo(@Param String pattern)

The SIMILAR_TO operator.

Parameters:

pattern - is wrapped as DSL.val(Object).
similarTo

@NotNull @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DUCKDB,EXASOL,FIREBIRD,IGNITE,POSTGRES,SNOWFLAKE,YUGABYTEDB}) @NotNull LikeEscapeStep similarTo(Field<String> pattern)

The SIMILAR_TO operator.
similarTo

@NotNull @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DUCKDB,EXASOL,FIREBIRD,IGNITE,POSTGRES,SNOWFLAKE,YUGABYTEDB}) @NotNull LikeEscapeStep similarTo(QuantifiedSelect<? extends Record1<String>> pattern)

The SIMILAR_TO operator.
isDocument

@NotNull @Support(POSTGRES) @NotNull Condition isDocument()

The IS_DOCUMENT operator.
Create a condition to check if this field contains XML data.
isNotDocument

@NotNull @Support(POSTGRES) @NotNull Condition isNotDocument()

The IS_NOT_DOCUMENT operator.
Create a condition to check if this field does not contain XML data.
isJson

@NotNull @Support({DUCKDB,MARIADB,MYSQL_5_7,ORACLE12C,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER2016}) @NotNull Condition isJson()

The IS_JSON operator.
Create a condition to check if this field contains JSON data.
isNotJson

@NotNull @Support({DUCKDB,MARIADB,MYSQL_5_7,ORACLE12C,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER2016}) @NotNull Condition isNotJson()

The IS_NOT_JSON operator.
Create a condition to check if this field does not contain JSON data.
bitAnd

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> bitAnd(T arg2)

The BIT_AND operator.

Parameters:

arg2 - is wrapped as DSL.val(Object).
bitAnd

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> bitAnd(Field<T> arg2)

The BIT_AND operator.
bitNand

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> bitNand(T arg2)

The BIT_NAND operator.

Parameters:

arg2 - is wrapped as DSL.val(Object).
bitNand

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> bitNand(Field<T> arg2)

The BIT_NAND operator.
bitNor

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> bitNor(T arg2)

The BIT_NOR operator.

Parameters:

arg2 - is wrapped as DSL.val(Object).
bitNor

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> bitNor(Field<T> arg2)

The BIT_NOR operator.
bitNot

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> bitNot()

The BIT_NOT operator.
bitOr

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> bitOr(T arg2)

The BIT_OR operator.

Parameters:

arg2 - is wrapped as DSL.val(Object).
bitOr

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> bitOr(Field<T> arg2)

The BIT_OR operator.
bitXNor

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> bitXNor(T arg2)

The BIT_XNOR operator.

Parameters:

arg2 - is wrapped as DSL.val(Object).
bitXNor

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> bitXNor(Field<T> arg2)

The BIT_XNOR operator.
bitXor

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> bitXor(T arg2)

The BIT_XOR operator.

Parameters:

arg2 - is wrapped as DSL.val(Object).
bitXor

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> bitXor(Field<T> arg2)

The BIT_XOR operator.
mod

@NotNull @Support @NotNull Field<T> mod(Number divisor)

The MOD operator.

Parameters:

divisor - is wrapped as DSL.val(Object).
mod

@NotNull @Support @NotNull Field<T> mod(Field<? extends Number> divisor)

The MOD operator.
modulo

@NotNull @Support @NotNull Field<T> modulo(Number divisor)

The MODULO operator, an alias for the MOD operator.

Parameters:

divisor - is wrapped as DSL.val(Object).
modulo

@NotNull @Support @NotNull Field<T> modulo(Field<? extends Number> divisor)

The MODULO operator, an alias for the MOD operator.
rem

@NotNull @Support @NotNull Field<T> rem(Number divisor)

The REM operator, an alias for the MOD operator.

Parameters:

divisor - is wrapped as DSL.val(Object).
rem

@NotNull @Support @NotNull Field<T> rem(Field<? extends Number> divisor)

The REM operator, an alias for the MOD operator.
power

@NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE_3_38,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> power(Number exponent)

The POWER operator.

Parameters:

exponent - is wrapped as DSL.val(Object).
power

@NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE_3_38,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> power(Field<? extends Number> exponent)

The POWER operator.
pow

@NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE_3_38,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> pow(Number exponent)

The POW operator, an alias for the POWER operator.

Parameters:

exponent - is wrapped as DSL.val(Object).
pow

@NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE_3_38,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> pow(Field<? extends Number> exponent)

The POW operator, an alias for the POWER operator.
shl

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> shl(Number count)

The SHL operator.
Left shift all bits in a number

Parameters:

count - The number of bits to shift.

value - The number whose bits to shift left.
shl

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> shl(Field<? extends Number> count)

The SHL operator.
Left shift all bits in a number

Parameters:

count - The number of bits to shift.

value - The number whose bits to shift left.
shr

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> shr(Number count)

The SHR operator.
Right shift all bits in a number

Parameters:

count - The number of bits to shift.

value - The number whose bits to shift right
shr

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,FIREBIRD,H2,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull Field<T> shr(Field<? extends Number> count)

The SHR operator.
Right shift all bits in a number

Parameters:

count - The number of bits to shift.

value - The number whose bits to shift right
contains

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

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

content - is wrapped as DSL.val(Object).
contains

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

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

@NotNull @Support @NotNull Condition containsIgnoreCase(T content)

The CONTAINS_IGNORE_CASE operator.
Convenience method for likeIgnoreCase(String, char) including proper adding of wildcards and escaping.
This translates to this ilike ('%' || escape(value, '\') || '%') escape '\' in SQLDialect.POSTGRES, or to lower(this) like lower(('%' || escape(value, '\') || '%') escape '\') in all other dialects.

Parameters:

content - is wrapped as DSL.val(Object).
containsIgnoreCase

@NotNull @Support @NotNull Condition containsIgnoreCase(Field<T> content)

The CONTAINS_IGNORE_CASE operator.
Convenience method for likeIgnoreCase(String, char) including proper adding of wildcards and escaping.
This translates to this ilike ('%' || escape(value, '\') || '%') escape '\' in SQLDialect.POSTGRES, or to lower(this) like lower(('%' || escape(value, '\') || '%') escape '\') in all other dialects.
endsWith

@NotNull @Support @NotNull Condition endsWith(T suffix)

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

Parameters:

suffix - is wrapped as DSL.val(Object).
endsWith

@NotNull @Support @NotNull Condition endsWith(Field<T> suffix)

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

@NotNull @Support @NotNull Condition endsWithIgnoreCase(T suffix)

The ENDS_WITH_IGNORE_CASE operator.
Convenience method for 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)

Parameters:

suffix - is wrapped as DSL.val(Object).
endsWithIgnoreCase

@NotNull @Support @NotNull Condition endsWithIgnoreCase(Field<T> suffix)

The ENDS_WITH_IGNORE_CASE operator.
Convenience method for 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)
startsWith

@NotNull @Support @NotNull Condition startsWith(T prefix)

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

Parameters:

prefix - is wrapped as DSL.val(Object).
startsWith

@NotNull @Support @NotNull Condition startsWith(Field<T> prefix)

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

@NotNull @Support @NotNull Condition startsWithIgnoreCase(T prefix)

The STARTS_WITH_IGNORE_CASE operator.
Convenience method for 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)

Parameters:

prefix - is wrapped as DSL.val(Object).
startsWithIgnoreCase

@NotNull @Support @NotNull Condition startsWithIgnoreCase(Field<T> prefix)

The STARTS_WITH_IGNORE_CASE operator.
Convenience method for 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)
plus

@NotNull @Support @Pro @NotNull Field<T> plus()
The PLUS operator.
Turn this field into an Oracle-specific field for use in outer-join predicates. It can be emulated using Settings.isTransformTableListsToAnsiJoin().
Example:
```
 TABLE1.COL.plus().eq(TABLE2.COL);
 TABLE1.COL.eq(TABLE2.COL.plus());
 
```
The above will generate
```
 TABLE1.COL(+) = TABLE2.COL
 TABLE1.COL = TABLE2.COL(+)
 
```
neg

@NotNull @Support @NotNull Field<T> neg()
Negate this field to get its negative value.
This renders the same on all dialects:
```
-[this]
```
unaryMinus

@NotNull @Support @NotNull Field<T> unaryMinus()

Negate this field to get its negative value.
This is an alias for neg(), which can be recognised by the Kotlin language for operator overloading.
unaryPlus

@NotNull @Support @NotNull Field<T> unaryPlus()

Get this field as its positive value (no effect on SQL).
This can be recognised by the Kotlin language for operator overloading.
add

@NotNull @Support @NotNull Field<T> add(Number value)

An arithmetic expression adding this to value.
See Also:
- add(Field)
add

@NotNull @Support @NotNull Field<T> add(Field<?> value)

An arithmetic expression to add value to this.
The behaviour of this operation is as follows:

Operand 1 Operand 2 Result Type

Numeric Numeric Numeric

Date / Time Numeric Date / Time

Date / Time Interval Date / Time

Interval Interval Interval
plus

@NotNull @Support @NotNull Field<T> plus(Number value)

An alias for add(Number).
See Also:
- add(Number)
plus

@NotNull @Support @NotNull Field<T> plus(Field<?> value)

An alias for add(Field).
See Also:
- add(Field)
sub

@NotNull @Support @NotNull Field<T> sub(Number value)

An arithmetic expression subtracting value from this.
See Also:
- sub(Field)
sub

@NotNull @Support @NotNull Field<T> sub(Field<?> value)
An arithmetic expression subtracting value from this.

Operand 1 Operand 2 Result Type

Numeric Numeric Numeric

Date / Time Numeric Date / Time

Date / Time Interval Date / Time

Interval Interval Interval

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

@NotNull @Support @NotNull Field<T> subtract(Number value)

An alias for sub(Number).
See Also:
- sub(Number)
subtract

@NotNull @Support @NotNull Field<T> subtract(Field<?> value)

An alias for sub(Field).
See Also:
- sub(Field)
minus

@NotNull @Support @NotNull Field<T> minus(Number value)

An alias for sub(Number).
See Also:
- sub(Number)
minus

@NotNull @Support @NotNull Field<T> minus(Field<?> value)

An alias for sub(Field).
See Also:
- sub(Field)
mul

@NotNull @Support @NotNull Field<T> mul(Number value)
An arithmetic expression multiplying this with value.
- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval)
mul

@NotNull @Support @NotNull Field<T> mul(Field<? extends Number> value)
An arithmetic expression multiplying this with value.
- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval)
multiply

@NotNull @Support @NotNull Field<T> multiply(Number value)

An alias for mul(Number).
See Also:
- mul(Number)
multiply

@NotNull @Support @NotNull Field<T> multiply(Field<? extends Number> value)

An alias for mul(Field).
See Also:
- mul(Field)
times

@NotNull @Support @NotNull Field<T> times(Number value)

An alias for mul(Number).
See Also:
- mul(Number)
times

@NotNull @Support @NotNull Field<T> times(Field<? extends Number> value)

An alias for mul(Field).
See Also:
- mul(Field)
div

@NotNull @Support @NotNull Field<T> div(Number value)
An arithmetic expression dividing this by value.
- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval)
div

@NotNull @Support @NotNull Field<T> div(Field<? extends Number> value)
An arithmetic expression dividing this by value.
- If this is a numeric field, then the result is a number of the same type as this field.
- If this is an INTERVAL field, then the result is also an INTERVAL field (see Interval)
divide

@NotNull @Support @NotNull Field<T> divide(Number value)

An alias for div(Number).
See Also:
- div(Number)
divide

@NotNull @Support @NotNull Field<T> divide(Field<? extends Number> value)

An alias for div(Field).
See Also:
- div(Field)

likeRegex

@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLITE,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition likeRegex(String pattern)

Create a condition to regex-pattern-check this field against a pattern.

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


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

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

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

SQL dialect	SQL syntax	Pattern syntax	Documentation
`SQLDialect.ASE`	-	-	-
`SQLDialect.DB2`	-	-	-
`SQLDialect.DERBY`	-	-	-
`SQLDialect.H2`	`[search] REGEXP [pattern]`	Java	https ://www.h2database.com/html/grammar.html#condition_right_hand_side
`SQLDialect.HSQLDB`	`REGEXP_MATCHES([search], [pattern])`	Java	http://hsqldb.org/doc/guide/builtinfunctions-chapt.html#N13577
`SQLDialect.INGRES`	-	-	-
`SQLDialect.MYSQL`	`[search] REGEXP [pattern]`	POSIX	http://dev .mysql.com/doc/refman/5.6/en/regexp.html
`SQLDialect.ORACLE`	`REGEXP_LIKE([search], [pattern])`	POSIX	http://docs.oracle.com/cd/E14072_01/server.112/e10592/conditions007.htm# sthref1994
`SQLDialect.POSTGRES`	`[search] ~ [pattern]`	POSIX	http://www.postgresql.org/docs/9.1/static/functions-matching.html# FUNCTIONS-POSIX-REGEXP
`SQLDialect.SQLITE`	`[search] REGEXP [pattern]`	? This module has to be loaded explicitly	http://www.sqlite.org/ lang_expr.html
`SQLDialect.SQLSERVER`	-	-	-
`SQLDialect.SYBASE`	`[search] REGEXP [pattern]`	Perl	http://infocenter.sybase.com/help/topic/com.sybase.help.sqlanywhere.12.0 .1/dbreference/like-regexp-similarto.html

See Also:

likeRegex

@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLITE,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition likeRegex(Field<String> pattern)

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

@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLITE,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition notLikeRegex(String pattern)

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

@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLITE,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition notLikeRegex(Field<String> pattern)

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

@NotNull @Support({COCKROACHDB,FIREBIRD,POSTGRES,YUGABYTEDB}) @NotNull Condition similarTo(Field<String> value, char escape)

Create a condition to pattern-check this field against a value.
SQL: this similar to value escape 'e'
See Also:
- LikeEscapeStep.escape(char)
similarTo

@NotNull @Support({COCKROACHDB,FIREBIRD,POSTGRES,YUGABYTEDB}) @NotNull Condition similarTo(String value, char escape)

Create a condition to pattern-check this field against a value.
SQL: this similar to value escape 'e'
See Also:
- LikeEscapeStep.escape(char)
notSimilarTo

@NotNull @Support({COCKROACHDB,FIREBIRD,POSTGRES,YUGABYTEDB}) @NotNull Condition notSimilarTo(Field<String> field, char escape)

Create a condition to pattern-check this field against a field.
SQL: this not similar to field escape 'e'
See Also:
- LikeEscapeStep.escape(char)
notSimilarTo

@NotNull @Support({COCKROACHDB,FIREBIRD,POSTGRES,YUGABYTEDB}) @NotNull Condition notSimilarTo(String value, char escape)

Create a condition to pattern-check this field against a value.
SQL: this not similar to value escape 'e'
See Also:
- LikeEscapeStep.escape(char)
like

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition like(Field<String> value, char escape)

Create a condition to pattern-check this field against a value.
SQL: this like value escape 'e'
See Also:
- LikeEscapeStep.escape(char)
like

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition like(String value, char escape)

Create a condition to pattern-check this field against a value.
SQL: this like value escape 'e'
See Also:
- LikeEscapeStep.escape(char)
likeIgnoreCase

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition likeIgnoreCase(Field<String> field, char escape)

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

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition likeIgnoreCase(String value, char escape)

Create a condition to case-insensitively pattern-check this field against a value.
This translates to this ilike value in SQLDialect.POSTGRES, or to lower(this) like lower(value) in all other dialects.
See Also:
- LikeEscapeStep.escape(char)
notLike

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition notLike(Field<String> field, char escape)

Create a condition to pattern-check this field against a field.
SQL: this not like field escape 'e'
See Also:
- LikeEscapeStep.escape(char)
notLike

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition notLike(String value, char escape)

Create a condition to pattern-check this field against a value.
SQL: this not like value escape 'e'
See Also:
- LikeEscapeStep.escape(char)
notLikeIgnoreCase

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition notLikeIgnoreCase(Field<String> field, char escape)

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

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition notLikeIgnoreCase(String value, char escape)

Create a condition to case-insensitively pattern-check this field against a value.
This translates to this not ilike value in SQLDialect.POSTGRES, or to lower(this) not like lower(value) in all other dialects.
See Also:
- LikeEscapeStep.escape(char)
notContains

@NotNull @Support @NotNull Condition notContains(T value)

Inverse of contains(Object).
notContains

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition notContains(Field<T> value)

Inverse of contains(Field).
notContainsIgnoreCase

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition notContainsIgnoreCase(T value)

Inverse of containsIgnoreCase(Object)
notContainsIgnoreCase

@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,VERTICA,YUGABYTEDB}) @NotNull Condition notContainsIgnoreCase(Field<T> value)

Inverse of containsIgnoreCase(Field)
in

@NotNull @Support @NotNull Condition in(Collection<?> values)
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 use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
- IN predicates on temporary tables
- IN predicates on unnested array bind variables
in

@NotNull @Support @NotNull Condition in(Result<? extends Record1<T>> result)
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 use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
- IN predicates on temporary tables
- IN predicates on unnested array bind variables
in

@NotNull @Support @NotNull Condition in(T... values)
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 use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
- IN predicates on temporary tables
- IN predicates on unnested array bind variables
in

@NotNull @Support @NotNull Condition in(Field<?>... values)

Create a condition to check this field against several values.
SQL: this in (values…)
notIn

@NotNull @Support @NotNull Condition notIn(Collection<?> values)
Create a condition to check this field against several values.
Note that if any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well. This is standard SQL behaviour.
SQL: this not in (values…)
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 use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
- NOT IN predicates on temporary tables
- NOT IN predicates on unnested array bind variables
notIn

@NotNull @Support @NotNull Condition notIn(Result<? extends Record1<T>> result)
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 be NULL (or false, 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 use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
- NOT IN predicates on temporary tables
- NOT IN predicates on unnested array bind variables
notIn

@NotNull @Support @NotNull Condition notIn(T... values)
Create a condition to check this field against several values.
Note that if any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well. This is standard SQL behaviour.
SQL: this not in (values…)
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 use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
- NOT IN predicates on temporary tables
- NOT IN predicates on unnested array bind variables
notIn

@NotNull @Support @NotNull Condition notIn(Field<?>... values)

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

@NotNull @Support @NotNull Condition between(T minValue, T maxValue)

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

@NotNull @Support @NotNull Condition between(Field<T> minValue, Field<T> maxValue)

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

@NotNull @Support @NotNull Condition betweenSymmetric(T minValue, T maxValue)

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
betweenSymmetric

@NotNull @Support @NotNull Condition betweenSymmetric(Field<T> minValue, Field<T> maxValue)

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
notBetween

@NotNull @Support @NotNull Condition notBetween(T minValue, T maxValue)

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
notBetween

@NotNull @Support @NotNull Condition notBetween(Field<T> minValue, Field<T> maxValue)

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
notBetweenSymmetric

@NotNull @Support @NotNull Condition notBetweenSymmetric(T minValue, T maxValue)

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
notBetweenSymmetric

@NotNull @Support @NotNull Condition notBetweenSymmetric(Field<T> minValue, Field<T> maxValue)

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
between

@NotNull @Support @NotNull BetweenAndStep<T> between(T minValue)

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

@NotNull @Support @NotNull BetweenAndStep<T> between(Field<T> minValue)

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

@NotNull @Support @NotNull BetweenAndStep<T> betweenSymmetric(T minValue)

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

@NotNull @Support @NotNull BetweenAndStep<T> betweenSymmetric(Field<T> minValue)

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

@NotNull @Support @NotNull BetweenAndStep<T> notBetween(T minValue)

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

@NotNull @Support @NotNull BetweenAndStep<T> notBetween(Field<T> minValue)

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

@NotNull @Support @NotNull BetweenAndStep<T> notBetweenSymmetric(T minValue)

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

@NotNull @Support @NotNull BetweenAndStep<T> notBetweenSymmetric(Field<T> minValue)

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

@NotNull @Support @NotNull Condition compare(Comparator comparator, T value)

Compare this field with a value using a dynamic comparator.

Parameters:

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

value - The value to compare this field with

Returns:

A comparison predicate
compare

@NotNull @Support @NotNull Condition compare(Comparator comparator, Field<T> field)

Compare this field with another field using a dynamic comparator.

Parameters:

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

field - The field to compare this field with

Returns:

A comparison predicate
compare

@NotNull @Support @NotNull Condition compare(Comparator comparator, Select<? extends Record1<T>> query)

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

Parameters:

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

query - The subselect to compare this field with

Returns:

A comparison predicate
compare

@NotNull @Support @NotNull Condition compare(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query)

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.

Parameters:

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

query - The quantified subselect to compare this field with

Returns:

A comparison predicate
isTrue

@NotNull @Support @NotNull Condition isTrue()

Create a condition to check this field against known string literals for true.
SQL: lcase(this) in ("1", "y", "yes", "true", "on", "enabled")
isFalse

@NotNull @Support @NotNull Condition isFalse()

Create a condition to check this field against known string literals for false.
SQL: lcase(this) in ("0", "n", "no", "false", "off", "disabled")
equalIgnoreCase

@NotNull @Support @NotNull Condition equalIgnoreCase(String value)

lower(this) = lower(value).
equalIgnoreCase

@NotNull @Support @NotNull Condition equalIgnoreCase(Field<String> value)

lower(this) = lower(value).
notEqualIgnoreCase

@NotNull @Support @NotNull Condition notEqualIgnoreCase(String value)

lower(this) != lower(value).
notEqualIgnoreCase

@NotNull @Support @NotNull Condition notEqualIgnoreCase(Field<String> value)

lower(this) != lower(value).
sign

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<Integer> sign()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sign(Field) instead.
See Also:
- DSL.sign(Field)
abs

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> abs()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.abs(Field) instead.
See Also:
- DSL.abs(Field)
round

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> round()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.round(Field) instead.
See Also:
- DSL.round(Field)
round

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> round(int decimals)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.round(Field, int) instead.
See Also:
- DSL.round(Field, int)
floor

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> floor()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.floor(Field) instead.
See Also:
- DSL.floor(Field)
ceil

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> ceil()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.ceil(Field) instead.
See Also:
- DSL.ceil(Field)
sqrt

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> sqrt()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sqrt(Field) instead.
See Also:
- DSL.sqrt(Field)
exp

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> exp()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.exp(Field) instead.
See Also:
- DSL.exp(Field)
ln

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> ln()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.ln(Field) instead.
See Also:
- DSL.ln(Field)
log

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> log(int base)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.log(Field, int) instead.
See Also:
- DSL.log(Field, int)
acos

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> acos()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.acos(Field) instead.
See Also:
- DSL.acos(Field)
asin

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> asin()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.asin(Field) instead.
See Also:
- DSL.asin(Field)
atan

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> atan()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.atan(Field) instead.
See Also:
- DSL.atan(Field)
atan2

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> atan2(Number y)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.atan2(Field, Number) instead.
See Also:
- DSL.atan2(Field, Number)
atan2

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> atan2(Field<? extends Number> y)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.atan2(Field, Field) instead.
See Also:
- DSL.atan2(Field, Field)
cos

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> cos()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.cos(Field) instead.
See Also:
- DSL.cos(Field)
sin

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> sin()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sin(Field) instead.
See Also:
- DSL.sin(Field)
tan

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> tan()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.tan(Field) instead.
See Also:
- DSL.tan(Field)
cot

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> cot()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.cot(Field) instead.
See Also:
- DSL.cot(Field)
sinh

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> sinh()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sinh(Field) instead.
See Also:
- DSL.sinh(Field)
cosh

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> cosh()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.cosh(Field) instead.
See Also:
- DSL.cosh(Field)
tanh

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> tanh()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.tanh(Field) instead.
See Also:
- DSL.tanh(Field)
coth

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> coth()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.coth(Field) instead.
See Also:
- DSL.coth(Field)
deg

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<BigDecimal> deg()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.deg(Field) instead.
See Also:
- DSL.deg(Field)
rad

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<BigDecimal> rad()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.rad(Field) instead.
See Also:
- DSL.rad(Field)
count

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<Integer> count()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.count(Field) instead.
See Also:
- DSL.count(Field)
countDistinct

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<Integer> countDistinct()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.countDistinct(Field) instead.
See Also:
- DSL.countDistinct(Field)
max

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> max()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.max(Field) instead.
See Also:
- DSL.max(Field)
min

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> min()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.min(Field) instead.
See Also:
- DSL.min(Field)
sum

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<BigDecimal> sum()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sum(Field) instead.
See Also:
- DSL.sum(Field)
avg

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<BigDecimal> avg()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.avg(Field) instead.
See Also:
- DSL.avg(Field)
median

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({CUBRID,HSQLDB,ORACLE,SNOWFLAKE,SYBASE,TERADATA}) @NotNull Field<BigDecimal> median()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.median(Field) instead.
See Also:
- DSL.median(Field)
stddevPop

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> stddevPop()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.stddevPop(Field) instead.
See Also:
- DSL.stddevPop(Field)
stddevSamp

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> stddevSamp()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.stddevSamp(Field) instead.
See Also:
- DSL.stddevSamp(Field)
varPop

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> varPop()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.varPop(Field) instead.
See Also:
- DSL.varPop(Field)
varSamp

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<BigDecimal> varSamp()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.varSamp(Field) instead.
See Also:
- DSL.varSamp(Field)
countOver

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowPartitionByStep<Integer> countOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.count(Field) instead.
See Also:
- DSL.count(Field)
- WindowOverStep.over()
maxOver

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowPartitionByStep<T> maxOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.max(Field) instead.
See Also:
- DSL.max(Field)
- WindowOverStep.over()
minOver

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowPartitionByStep<T> minOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.min(Field) instead.
See Also:
- DSL.min(Field)
- WindowOverStep.over()
sumOver

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowPartitionByStep<BigDecimal> sumOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.sum(Field) instead.
See Also:
- DSL.sum(Field)
- WindowOverStep.over()
avgOver

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowPartitionByStep<BigDecimal> avgOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.avg(Field) instead.
See Also:
- DSL.avg(Field)
- WindowOverStep.over()
firstValue

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,TRINO,YUGABYTEDB}) @NotNull WindowIgnoreNullsStep<T> firstValue()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.firstValue(Field) instead.
See Also:
- DSL.firstValue(Field)
- WindowOverStep.over()
lastValue

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,TRINO,YUGABYTEDB}) @NotNull WindowIgnoreNullsStep<T> lastValue()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lastValue(Field) instead.
See Also:
- DSL.lastValue(Field)
- WindowOverStep.over()
lead

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowIgnoreNullsStep<T> lead()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lead(Field) instead.
See Also:
- DSL.lead(Field)
- WindowOverStep.over()
lead

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowIgnoreNullsStep<T> lead(int offset)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lead(Field, int) instead.
See Also:
- DSL.lead(Field, int)
- WindowOverStep.over()
lead

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowIgnoreNullsStep<T> lead(int offset, T defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lead(Field, int, Object) instead.
See Also:
- DSL.lead(Field, int, Object)
- WindowOverStep.over()
lead

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowIgnoreNullsStep<T> lead(int offset, Field<T> defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lead(Field, int, Field) instead.
See Also:
- DSL.lead(Field, int, Field)
- WindowOverStep.over()
lag

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowIgnoreNullsStep<T> lag()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lag(Field) instead.
See Also:
- DSL.lag(Field)
- WindowOverStep.over()
lag

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowIgnoreNullsStep<T> lag(int offset)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lag(Field, int) instead.
See Also:
- DSL.lag(Field, int)
- WindowOverStep.over()
lag

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowIgnoreNullsStep<T> lag(int offset, T defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lag(Field, int, Object) instead.
See Also:
- DSL.lag(Field, int, Object)
- WindowOverStep.over()
lag

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD_3_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowIgnoreNullsStep<T> lag(int offset, Field<T> defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.lag(Field, int, Field) instead.
See Also:
- DSL.lag(Field, int, Field)
- WindowOverStep.over()
stddevPopOver

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,CUBRID,DB2,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowPartitionByStep<BigDecimal> stddevPopOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.stddevPop(Field) instead.
See Also:
- DSL.stddevPop(Field)
- WindowOverStep.over()
stddevSampOver

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowPartitionByStep<BigDecimal> stddevSampOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.stddevSamp(Field) instead.
See Also:
- DSL.stddevSamp(Field)
- WindowOverStep.over()
varPopOver

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,CUBRID,DB2,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowPartitionByStep<BigDecimal> varPopOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.varPop(Field) instead.
See Also:
- DSL.varPop(Field)
- WindowOverStep.over()
varSampOver

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowPartitionByStep<BigDecimal> varSampOver()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.varSamp(Field) instead.
See Also:
- DSL.varSamp(Field)
- WindowOverStep.over()
upper

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<String> upper()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.upper(Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.upper(Field)
lower

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<String> lower()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lower(Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.lower(Field)
trim

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<String> trim()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.trim(Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.trim(Field)
rtrim

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<String> rtrim()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rtrim(Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.rtrim(Field)
ltrim

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<String> ltrim()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.ltrim(Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.ltrim(Field)
rpad

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> rpad(Field<? extends Number> length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rpad(Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.rpad(Field, Field)
rpad

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> rpad(int length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rpad(Field, int) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.rpad(Field, int)
rpad

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> rpad(Field<? extends Number> length, Field<String> character)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rpad(Field, Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.rpad(Field, Field, Field)
rpad

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> rpad(int length, char character)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.rpad(Field, int, char) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.rpad(Field, int, char)
lpad

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> lpad(Field<? extends Number> length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lpad(Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.lpad(Field, Field)
lpad

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> lpad(int length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lpad(Field, int) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.lpad(Field, int)
lpad

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> lpad(Field<? extends Number> length, Field<String> character)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lpad(Field, Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.lpad(Field, Field, Field)
lpad

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> lpad(int length, char character)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.lpad(Field, int, char) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.lpad(Field, int, char)
repeat

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> repeat(Number count)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.repeat(Field, int) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.repeat(Field, int)
repeat

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> repeat(Field<? extends Number> count)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.repeat(Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.repeat(Field, Field)
replace

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> replace(Field<String> search)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.replace(Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.replace(Field, Field)
replace

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> replace(String search)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.replace(Field, String) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.replace(Field, String)
replace

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> replace(Field<String> search, Field<String> replace)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.replace(Field, Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.replace(Field, Field, Field)
replace

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<String> replace(String search, String replace)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.replace(Field, String, String) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.replace(Field, String, String)
position

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<Integer> position(String search)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.position(Field, String) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.position(Field, String)
position

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<Integer> position(Field<String> search)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.position(Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.position(Field, Field)
ascii

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Field<Integer> ascii()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.ascii(Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.ascii(Field)
collate

@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,HANA,HSQLDB,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB}) @NotNull Field<String> collate(String collation)

Apply a collation operator to this column expression.
See Also:
- DSL.collation(String)
collate

@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,HANA,HSQLDB,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB}) @NotNull Field<String> collate(Name collation)

Apply a collation operator to this column expression.
See Also:
- DSL.collation(Name)
collate

@NotNull @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,HANA,HSQLDB,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB}) @NotNull Field<String> collate(Collation collation)

Apply a collation operator to this column expression.
concat

@NotNull @Support @NotNull Field<String> concat(Field<?>... fields)

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.concat(Field...)
concat

@NotNull @Support @NotNull Field<String> concat(String... values)

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.concat(String...)
concat

@NotNull @Support @NotNull Field<String> concat(char... values)

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.concat(String...)
substring

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<String> substring(int startingPosition)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.substring(Field, int) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.substring(Field, int)
substring

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<String> substring(Field<? extends Number> startingPosition)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.substring(Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.substring(Field, Field)
substring

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<String> substring(int startingPosition, int length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.substring(Field, int, int) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.substring(Field, int, int)
substring

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<String> substring(Field<? extends Number> startingPosition, Field<? extends Number> length)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.substring(Field, Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.substring(Field, Field, Field)
length

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<Integer> length()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.length(Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.length(Field)
charLength

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<Integer> charLength()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.charLength(Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.charLength(Field)
bitLength

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<Integer> bitLength()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.bitLength(Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.bitLength(Field)
octetLength

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<Integer> octetLength()

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.octetLength(Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.octetLength(Field)
extract

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<Integer> extract(DatePart datePart)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.extract(Field, DatePart) instead.
See Also:
- DSL.extract(Field, DatePart)
greatest

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> greatest(T... others)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.greatest(Field, Field...) instead.
See Also:
- DSL.greatest(Field, Field...)
greatest

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> greatest(Field<?>... others)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.greatest(Field, Field...) instead.
See Also:
- DSL.greatest(Field, Field...)
least

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> least(T... others)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.least(Field, Field...) instead.
See Also:
- DSL.least(Field, Field...)
least

@Deprecated(forRemoval=true, since="3.11") @NotNull @Support @NotNull Field<T> least(Field<?>... others)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.11 - [#7538] - Use DSL.least(Field, Field...) instead.
See Also:
- DSL.least(Field, Field...)
nvl

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<T> nvl(T defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nvl(Field, Object) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.nvl(Field, Object)
nvl

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<T> nvl(Field<T> defaultValue)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nvl(Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.nvl(Field, Field)
nvl2

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support <Z> @NotNull Field<Z> nvl2(Z valueIfNotNull, Z valueIfNull)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nvl2(Field, Object, Object) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.nvl2(Field, Object, Object)
nvl2

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support <Z> @NotNull Field<Z> nvl2(Field<Z> valueIfNotNull, Field<Z> valueIfNull)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nvl2(Field, Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.nvl2(Field, Field, Field)
nullif

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<T> nullif(T other)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nullif(Field, Object) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.nullif(Field, Object)
nullif

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<T> nullif(Field<T> other)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.nullif(Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.nullif(Field, Field)
decode

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support <Z> @NotNull Field<Z> decode(T search, Z result)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Object, Object, Object) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.decode(Object, Object, Object)
decode

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support <Z> @NotNull Field<Z> decode(T search, Z result, Object... more)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Object, Object, Object, Object...) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.decode(Object, Object, Object, Object...)
decode

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support <Z> @NotNull Field<Z> decode(Field<T> search, Field<Z> result)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Field, Field, Field) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.decode(Field, Field, Field)
decode

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support <Z> @NotNull Field<Z> decode(Field<T> search, Field<Z> result, Field<?>... more)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.decode(Field, Field, Field, Field...) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.decode(Field, Field, Field, Field...)
coalesce

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<T> coalesce(T option, T... options)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.coalesce(Object, Object...) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.coalesce(Object, Object...)
coalesce

@Deprecated(forRemoval=true, since="3.13") @NotNull @Support @NotNull Field<T> coalesce(Field<T> option, Field<?>... options)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.13 - [#9407] - Use DSL.coalesce(Field, Field...) instead.

This method is part of the pre-2.0 API. This API is maintained for backwards-compatibility. It may be removed in the future. Consider using equivalent methods from DSLContext
See Also:
- DSL.coalesce(Field, Field...)
field

@Nullable @Nullable Field<T> field(Record record)

The inverse operation of Fields.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

@Nullable T get(Record record)
The inverse operation of Record.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

@Nullable T getValue(Record record)
The inverse operation of Record.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

@Nullable T original(Record record)
The inverse operation of Record.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

@Deprecated(forRemoval=true) boolean changed(Record record)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#12494] - 3.20.0 - Use touched(Record) instead.
The inverse operation of Record.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);
 
```
touched

boolean touched(Record record)
The inverse operation of Record.touched(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::touched)
    .forEach(System.out::println);
 
```
reset

void reset(Record record)
The inverse operation of Record.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

@Nullable @Nullable Record1<T> from(Record record)
The inverse operation of Record.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);
 
```

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

Interface Field<T>

Method Summary

Methods inherited from interface org.jooq.Named

Methods inherited from interface org.jooq.QueryPart

Methods inherited from interface org.jooq.Typed

Method Details

getName

getComment

as

equals

as

as

as

convert

convert

convert

convertFrom

convertFrom

convertTo

convertTo

comment

comment

cast

cast

cast

coerce

Bind values

Other Field types

coerce

Bind values

Other Field types

coerce

Bind values

Other Field types

asc

desc

sortDefault

sort

sortAsc

sortAsc

sortDesc

sortDesc

sort

nullsFirst

nullsLast

binaryLike

binaryLike

binaryLike

eq

eq

eq

eq

equal

equal

equal

equal

ge

ge

ge

ge

greaterOrEqual

greaterOrEqual

greaterOrEqual

greaterOrEqual

greaterThan

greaterThan

greaterThan

greaterThan

gt

gt

gt

gt

in

isDistinctFrom

isDistinctFrom

isDistinctFrom

isNull

isNotDistinctFrom

isNotDistinctFrom

isNotDistinctFrom