Top Description Methods
org.jooq

public Interface Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>

extends Row, SelectField<Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>>
Known Direct Implementers
org.jooq.impl.RowImpl16
Static Imports
org.jooq.SQLDialect.*
A row value expression.

Row value expressions are mainly useful for use in predicates, when comparing several values in one go, which can be more elegant than expanding the row value expression predicate in other equivalent syntaxes. This is especially true for non-equality predicates. For instance, the following two predicates are equivalent in SQL: 


(A, B) > (X, Y)
(A > X) OR (A = X AND B > Y)

Example: 


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

using(configuration)
   .select()
   .from(CUSTOMER)
   .where(row(CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME).in(
       select(ACTOR.FIRST_NAME, ACTOR.LAST_NAME).from(ACTOR)
   ))
   .fetch();

Note

Not all databases support row value expressions, but many row value expression operations can be emulated on all databases. See relevant row value expression method Javadocs for details.

Instances can be created using DSL#row(Object...) and overloads.

Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16)

Check if this row value expression is within a range of two other row value expressions.

public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16)

Deprecated as a consequence of Field being deprecated.
Check if this row value expression is within a range of two other row value expressions.
public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
between(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue)

Check if this row value expression is within a range of two other row value expressions.

public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
between(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue)

Check if this row value expression is within a range of two records.

public @NotNull Condition
between(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue, Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> maxValue)

Deprecated as a consequence of Condition being deprecated.
Check if this row value expression is within a range of two other row value expressions.
public @NotNull Condition
between(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue, Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> maxValue)

Deprecated as a consequence of Condition being deprecated.
Check if this row value expression is within a range of two records.
public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16)

Check if this row value expression is within a symmetric range of two other row value expressions.

public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16)

Deprecated as a consequence of Field being deprecated.
Check if this row value expression is within a symmetric range of two other row value expressions.
public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
betweenSymmetric(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue)

Check if this row value expression is within a symmetric range of two other row value expressions.

public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
betweenSymmetric(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue)

Check if this row value expression is within a symmetric range of two records.

public @NotNull Condition
betweenSymmetric(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue, Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> maxValue)

Deprecated as a consequence of Condition being deprecated.
Check if this row value expression is within a symmetric range of two other row value expressions.
public @NotNull Condition
betweenSymmetric(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue, Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> maxValue)

Deprecated as a consequence of Condition being deprecated.
Check if this row value expression is within a symmetric range of two records.
public @NotNull Condition
compare(Comparator comparator, Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression using a dynamic comparator.
public @NotNull Condition
compare(Comparator comparator, Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a record using a dynamic comparator.
public @NotNull Condition
compare(Comparator comparator, T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression using a dynamic comparator.
public @NotNull Condition
compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression using a dynamic comparator.
public @NotNull Condition
compare(Comparator comparator, Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect using a dynamic comparator.
public @NotNull Condition
compare(Comparator comparator, QuantifiedSelect<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect using a dynamic comparator.
public @NotNull Condition
eq(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for equality.
public @NotNull Condition
eq(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a record for equality.
public @NotNull Condition
eq(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for equality.
public @NotNull Condition
eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for equality.
public @NotNull Condition
eq(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for equality.
public @NotNull Condition
eq(QuantifiedSelect<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for equality.
public @NotNull Condition
equal(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for equality.
public @NotNull Condition
equal(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a record for equality.
public @NotNull Condition
equal(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for equality.
public @NotNull Condition
equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for equality.
public @NotNull Condition
equal(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for equality.
public @NotNull Condition
equal(QuantifiedSelect<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for equality.
public @NotNull Field<T1>
field1()

Deprecated as a consequence of Field being deprecated.
Get the first field.
public @NotNull Field<T10>
field10()

Deprecated as a consequence of Field being deprecated.
Get the tenth field.
public @NotNull Field<T11>
field11()

Deprecated as a consequence of Field being deprecated.
Get the eleventh field.
public @NotNull Field<T12>
field12()

Deprecated as a consequence of Field being deprecated.
Get the twelfth field.
public @NotNull Field<T13>
field13()

Deprecated as a consequence of Field being deprecated.
Get the thirteenth field.
public @NotNull Field<T14>
field14()

Deprecated as a consequence of Field being deprecated.
Get the fourteenth field.
public @NotNull Field<T15>
field15()

Deprecated as a consequence of Field being deprecated.
Get the fifteenth field.
public @NotNull Field<T16>
field16()

Deprecated as a consequence of Field being deprecated.
Get the sixteenth field.
public @NotNull Field<T2>
field2()

Deprecated as a consequence of Field being deprecated.
Get the second field.
public @NotNull Field<T3>
field3()

Deprecated as a consequence of Field being deprecated.
Get the third field.
public @NotNull Field<T4>
field4()

Deprecated as a consequence of Field being deprecated.
Get the fourth field.
public @NotNull Field<T5>
field5()

Deprecated as a consequence of Field being deprecated.
Get the fifth field.
public @NotNull Field<T6>
field6()

Deprecated as a consequence of Field being deprecated.
Get the sixth field.
public @NotNull Field<T7>
field7()

Deprecated as a consequence of Field being deprecated.
Get the seventh field.
public @NotNull Field<T8>
field8()

Deprecated as a consequence of Field being deprecated.
Get the eighth field.
public @NotNull Field<T9>
field9()

Deprecated as a consequence of Field being deprecated.
Get the ninth field.
public @NotNull Condition
ge(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
ge(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a record for order.
public @NotNull Condition
ge(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
ge(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
ge(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
ge(QuantifiedSelect<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
greaterOrEqual(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
greaterOrEqual(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a record for order.
public @NotNull Condition
greaterOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
greaterOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
greaterOrEqual(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
greaterOrEqual(QuantifiedSelect<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
greaterThan(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
greaterThan(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a record for order.
public @NotNull Condition
greaterThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
greaterThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
greaterThan(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
greaterThan(QuantifiedSelect<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
gt(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
gt(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a record for order.
public @NotNull Condition
gt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
gt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
gt(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
gt(QuantifiedSelect<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
in(Collection<? extends Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> rows)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a set of row value expressions for equality.
public @NotNull Condition
in(Result<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> result)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a set of records for equality.
public @NotNull Condition
in(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>... rows)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a set of row value expressions for equality.
public @NotNull Condition
in(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>... record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a set of records for equality.
public @NotNull Condition
in(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for equality.
public @NotNull Condition
isDistinctFrom(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for distinctness.
public @NotNull Condition
isDistinctFrom(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for distinctness.
public @NotNull Condition
isDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for distinctness.
public @NotNull Condition
isDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for distinctness.
public @NotNull Condition
isDistinctFrom(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for distinctness.
public @NotNull Condition
isNotDistinctFrom(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for distinctness.
public @NotNull Condition
isNotDistinctFrom(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for distinctness.
public @NotNull Condition
isNotDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for distinctness.
public @NotNull Condition
isNotDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for distinctness.
public @NotNull Condition
isNotDistinctFrom(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for distinctness.
public @NotNull Condition
le(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
le(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a record for order.
public @NotNull Condition
le(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
le(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
le(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
le(QuantifiedSelect<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
lessOrEqual(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
lessOrEqual(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a record for order.
public @NotNull Condition
lessOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
lessOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
lessOrEqual(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
lessOrEqual(QuantifiedSelect<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
lessThan(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
lessThan(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a record for order.
public @NotNull Condition
lessThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
lessThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
lessThan(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
lessThan(QuantifiedSelect<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
lt(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
lt(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a record for order.
public @NotNull Condition
lt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
lt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for order.
public @NotNull Condition
lt(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public @NotNull Condition
lt(QuantifiedSelect<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for order.
public <U> @NotNull SelectField<U>
mapping(Function16<? super T1, ? super T2, ? super T3, ? super T4, ? super T5, ? super T6, ? super T7, ? super T8, ? super T9, ? super T10, ? super T11, ? super T12, ? super T13, ? super T14, ? super T15, ? super T16, ? extends U> function)

A convenience method to define a local Record16 to custom type RecordMapper that can be used when projecting Row types in SELECT or RETURNING clauses.

public <U> @NotNull SelectField<U>
mapping(Class<U> uType, Function16<? super T1, ? super T2, ? super T3, ? super T4, ? super T5, ? super T6, ? super T7, ? super T8, ? super T9, ? super T10, ? super T11, ? super T12, ? super T13, ? super T14, ? super T15, ? super T16, ? extends U> function)

A convenience method to define a local Record16 to custom type RecordMapper that can be used when projecting Row types in SELECT or RETURNING clauses.

public @NotNull Condition
ne(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for non-equality.
public @NotNull Condition
ne(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a record for non-equality.
public @NotNull Condition
ne(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for non-equality.
public @NotNull Condition
ne(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for non-equality.
public @NotNull Condition
ne(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for non-equality.
public @NotNull Condition
ne(QuantifiedSelect<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for non-equality.
public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
notBetween(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16)

Check if this row value expression is not within a range of two other row value expressions.

public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
notBetween(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16)

Deprecated as a consequence of Field being deprecated.
Check if this row value expression is not within a range of two other row value expressions.
public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
notBetween(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue)

Check if this row value expression is not within a range of two other row value expressions.

public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
notBetween(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue)

Check if this row value expression is within a range of two records.

public @NotNull Condition
notBetween(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue, Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> maxValue)

Deprecated as a consequence of Condition being deprecated.
Check if this row value expression is not within a range of two other row value expressions.
public @NotNull Condition
notBetween(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue, Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> maxValue)

Deprecated as a consequence of Condition being deprecated.
Check if this row value expression is within a range of two records.
public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
notBetweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16)

Check if this row value expression is not within a symmetric range of two other row value expressions.

public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
notBetweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16)

Deprecated as a consequence of Field being deprecated.
Check if this row value expression is not within a symmetric range of two other row value expressions.
public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
notBetweenSymmetric(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue)

Check if this row value expression is not within a symmetric range of two other row value expressions.

public @NotNull BetweenAndStep16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
notBetweenSymmetric(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue)

Check if this row value expression is not within a symmetric range of two records.

public @NotNull Condition
notBetweenSymmetric(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue, Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> maxValue)

Deprecated as a consequence of Condition being deprecated.
Check if this row value expression is not within a symmetric range of two other row value expressions.
public @NotNull Condition
notBetweenSymmetric(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> minValue, Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> maxValue)

Deprecated as a consequence of Condition being deprecated.
Check if this row value expression is not within a symmetric range of two records.
public @NotNull Condition
notEqual(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for non-equality.
public @NotNull Condition
notEqual(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a record for non-equality
public @NotNull Condition
notEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with another row value expression for.
public @NotNull Condition
notEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)

Deprecated as a consequence of Field and Condition being deprecated.
Compare this row value expression with another row value expression for non-equality.
public @NotNull Condition
notEqual(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for non-equality.
public @NotNull Condition
notEqual(QuantifiedSelect<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for non-equality.
public @NotNull Condition
notIn(Collection<? extends Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> rows)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a set of row value expressions for equality.
public @NotNull Condition
notIn(Result<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> result)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a set of records for equality.
public @NotNull Condition
notIn(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>... rows)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a set of row value expressions for equality.
public @NotNull Condition
notIn(Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>... record)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a set of records for non-equality.
public @NotNull Condition
notIn(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select)

Deprecated as a consequence of Condition being deprecated.
Compare this row value expression with a subselect for non-equality.
Inherited from org.jooq.Row:
$fieldsisNotNullisNullsize
Inherited from org.jooq.SelectField:
asasasconvertconvertconvertconvertFromconvertFromconvertToconvertTo