public interface Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> extends Row
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.
| Modifier and Type | Method and Description |
|---|---|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
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)
Check if this row value expression is within a range of two other row
value expressions.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
between(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
Check if this row value expression is within a range of two records.
|
@NotNull Condition |
between(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue,
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
Check if this row value expression is within a range of two records.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
between(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
Check if this row value expression is within a range of two other row
value expressions.
|
@NotNull Condition |
between(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue,
Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
Check if this row value expression is within a range of two other row
value expressions.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
between(T1 minValue1,
T2 minValue2,
T3 minValue3,
T4 minValue4,
T5 minValue5,
T6 minValue6,
T7 minValue7,
T8 minValue8,
T9 minValue9,
T10 minValue10)
Check if this row value expression is within a range of two other row
value expressions.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
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)
Check if this row value expression is within a symmetric range of two
other row value expressions.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
betweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
Check if this row value expression is within a symmetric range of two
records.
|
@NotNull Condition |
betweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue,
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
Check if this row value expression is within a symmetric range of two
records.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
betweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
Check if this row value expression is within a symmetric range of two
other row value expressions.
|
@NotNull Condition |
betweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue,
Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
Check if this row value expression is within a symmetric range of two
other row value expressions.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
betweenSymmetric(T1 minValue1,
T2 minValue2,
T3 minValue3,
T4 minValue4,
T5 minValue5,
T6 minValue6,
T7 minValue7,
T8 minValue8,
T9 minValue9,
T10 minValue10)
Check if this row value expression is within a symmetric range of two
other row value expressions.
|
@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)
Compare this row value expression with another row value expression
using a dynamic comparator.
|
@NotNull Condition |
compare(Comparator comparator,
QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
@NotNull Condition |
compare(Comparator comparator,
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with a record
using a dynamic comparator.
|
@NotNull Condition |
compare(Comparator comparator,
Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression
using a dynamic comparator.
|
@NotNull Condition |
compare(Comparator comparator,
Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
@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)
Compare this row value expression with another row value expression
using a dynamic comparator.
|
@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)
Compare this row value expression with another row value expression for
equality.
|
@NotNull Condition |
eq(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for equality.
|
@NotNull Condition |
eq(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with a record for equality.
|
@NotNull Condition |
eq(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
equality.
|
@NotNull Condition |
eq(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for equality.
|
@NotNull Condition |
eq(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for
equality.
|
@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)
Compare this row value expression with another row value expression for
equality.
|
@NotNull Condition |
equal(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for equality.
|
@NotNull Condition |
equal(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with a record for equality.
|
@NotNull Condition |
equal(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
equality.
|
@NotNull Condition |
equal(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for equality.
|
@NotNull Condition |
equal(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for
equality.
|
@NotNull Field<T1> |
field1()
Get the first field.
|
@NotNull Field<T10> |
field10()
Get the tenth field.
|
@NotNull Field<T2> |
field2()
Get the second field.
|
@NotNull Field<T3> |
field3()
Get the third field.
|
@NotNull Field<T4> |
field4()
Get the fourth field.
|
@NotNull Field<T5> |
field5()
Get the fifth field.
|
@NotNull Field<T6> |
field6()
Get the sixth field.
|
@NotNull Field<T7> |
field7()
Get the seventh field.
|
@NotNull Field<T8> |
field8()
Get the eighth field.
|
@NotNull Field<T9> |
field9()
Get the ninth field.
|
@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)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
ge(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
ge(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with a record for order.
|
@NotNull Condition |
ge(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
ge(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
ge(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for
order.
|
@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)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
greaterOrEqual(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
greaterOrEqual(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with a record for order.
|
@NotNull Condition |
greaterOrEqual(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
greaterOrEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
greaterOrEqual(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for
order.
|
@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)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
greaterThan(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
greaterThan(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with a record for order.
|
@NotNull Condition |
greaterThan(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
greaterThan(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
greaterThan(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for
order.
|
@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)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
gt(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
gt(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with a record for order.
|
@NotNull Condition |
gt(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
gt(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
gt(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
in(Collection<? extends Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> rows)
Compare this row value expression with a set of row value expressions for
equality.
|
@NotNull Condition |
in(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... record)
Compare this row value expression with a set of records for equality.
|
@NotNull Condition |
in(Result<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> result)
Compare this row value expression with a set of records for
equality.
|
@NotNull Condition |
in(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... rows)
Compare this row value expression with a set of row value expressions for
equality.
|
@NotNull Condition |
in(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for equality.
|
@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)
Compare this row value expression with another row value expression for
distinctness.
|
@NotNull Condition |
isDistinctFrom(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with another row value expression for
distinctness.
|
@NotNull Condition |
isDistinctFrom(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
distinctness.
|
@NotNull Condition |
isDistinctFrom(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with another row value expression for
distinctness.
|
@NotNull Condition |
isDistinctFrom(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for
distinctness.
|
@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)
Compare this row value expression with another row value expression for
distinctness.
|
@NotNull Condition |
isNotDistinctFrom(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with another row value expression for
distinctness.
|
@NotNull Condition |
isNotDistinctFrom(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
distinctness.
|
@NotNull Condition |
isNotDistinctFrom(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with another row value expression for
distinctness.
|
@NotNull Condition |
isNotDistinctFrom(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for
distinctness.
|
@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)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
le(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
le(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with a record for order.
|
@NotNull Condition |
le(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
le(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
le(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for
order.
|
@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)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
lessOrEqual(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
lessOrEqual(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with a record for order.
|
@NotNull Condition |
lessOrEqual(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
lessOrEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
lessOrEqual(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for
order.
|
@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)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
lessThan(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
lessThan(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with a record for order.
|
@NotNull Condition |
lessThan(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
lessThan(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
lessThan(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for
order.
|
@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)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
lt(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
lt(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with a record for order.
|
@NotNull Condition |
lt(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
order.
|
@NotNull Condition |
lt(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
@NotNull Condition |
lt(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for
order.
|
@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)
Compare this row value expression with another row value expression for
non-equality.
|
@NotNull Condition |
ne(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for non-equality.
|
@NotNull Condition |
ne(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with a record for non-equality.
|
@NotNull Condition |
ne(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
non-equality.
|
@NotNull Condition |
ne(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for non-equality.
|
@NotNull Condition |
ne(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for
non-equality.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
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)
Check if this row value expression is not within a range of two other
row value expressions.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
notBetween(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
Check if this row value expression is within a range of two records.
|
@NotNull Condition |
notBetween(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue,
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
Check if this row value expression is within a range of two records.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
notBetween(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
Check if this row value expression is not within a range of two other
row value expressions.
|
@NotNull Condition |
notBetween(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue,
Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
Check if this row value expression is not within a range of two other
row value expressions.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
notBetween(T1 minValue1,
T2 minValue2,
T3 minValue3,
T4 minValue4,
T5 minValue5,
T6 minValue6,
T7 minValue7,
T8 minValue8,
T9 minValue9,
T10 minValue10)
Check if this row value expression is not within a range of two other
row value expressions.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
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)
Check if this row value expression is not within a symmetric range of two
other row value expressions.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
notBetweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
Check if this row value expression is not within a symmetric range of two
records.
|
@NotNull Condition |
notBetweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue,
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
Check if this row value expression is not within a symmetric range of two
records.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
notBetweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
Check if this row value expression is not within a symmetric range of two
other row value expressions.
|
@NotNull Condition |
notBetweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue,
Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
Check if this row value expression is not within a symmetric range of two
other row value expressions.
|
@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
notBetweenSymmetric(T1 minValue1,
T2 minValue2,
T3 minValue3,
T4 minValue4,
T5 minValue5,
T6 minValue6,
T7 minValue7,
T8 minValue8,
T9 minValue9,
T10 minValue10)
Check if this row value expression is not within a symmetric range of two
other row value expressions.
|
@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)
Compare this row value expression with another row value expression for
non-equality.
|
@NotNull Condition |
notEqual(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for non-equality.
|
@NotNull Condition |
notEqual(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
Compare this row value expression with a record for non-equality
|
@NotNull Condition |
notEqual(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Compare this row value expression with another row value expression for
non-equality.
|
@NotNull Condition |
notEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for non-equality.
|
@NotNull Condition |
notEqual(T1 t1,
T2 t2,
T3 t3,
T4 t4,
T5 t5,
T6 t6,
T7 t7,
T8 t8,
T9 t9,
T10 t10)
Compare this row value expression with another row value expression for.
|
@NotNull Condition |
notIn(Collection<? extends Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> rows)
Compare this row value expression with a set of row value expressions for
equality.
|
@NotNull Condition |
notIn(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... record)
Compare this row value expression with a set of records for non-equality.
|
@NotNull Condition |
notIn(Result<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> result)
Compare this row value expression with a set of records for
equality.
|
@NotNull Condition |
notIn(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... rows)
Compare this row value expression with a set of row value expressions for
equality.
|
@NotNull Condition |
notIn(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for non-equality.
|
@NotNull @Support @NotNull Condition compare(Comparator comparator, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
See the explicit comparison methods for details. Note, not all
Comparator types are supported
@NotNull @Support @NotNull Condition compare(Comparator comparator, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
See the explicit comparison methods for details. Note, not all
Comparator types are supported
@NotNull @Support @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)
See the explicit comparison methods for details. Note, not all
Comparator types are supported
@NotNull @Support @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)
See the explicit comparison methods for details. Note, not all
Comparator types are supported
@NotNull @Support @NotNull Condition compare(Comparator comparator, Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
See the explicit comparison methods for details. Note, not all
Comparator types are supported
@NotNull @Support @NotNull Condition compare(Comparator comparator, QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
See the explicit comparison methods for details. Note, not all
Comparator types are supported
@NotNull @Support @NotNull Condition equal(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Row equality comparison predicates can be emulated in those databases
that do not support such predicates natively:
(A, B) = (1, 2) is equivalent to
A = 1 AND B = 2
@NotNull @Support @NotNull Condition equal(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
equal(Row10)@NotNull @Support @NotNull Condition equal(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
equal(Row10)@NotNull @Support @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)
equal(Row10)@NotNull @Support @NotNull Condition equal(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
equal(Row10)@NotNull @Support @NotNull Condition equal(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull Condition eq(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
equal(Row10)@NotNull @Support @NotNull Condition eq(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
equal(Row10)@NotNull @Support @NotNull Condition eq(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
equal(Row10)@NotNull @Support @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)
equal(Row10)@NotNull @Support @NotNull Condition eq(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
equal(Row10)@NotNull @Support @NotNull Condition eq(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull Condition notEqual(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Row non-equality comparison predicates can be emulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2)
@NotNull @Support @NotNull Condition notEqual(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
notEqual(Row10)@NotNull @Support @NotNull Condition notEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
notEqual(Row10)@NotNull @Support @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)
notEqual(Row10)@NotNull @Support @NotNull Condition notEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
notEqual(Row10)@NotNull @Support @NotNull Condition notEqual(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull Condition ne(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
notEqual(Row10)@NotNull @Support @NotNull Condition ne(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
notEqual(Row10)@NotNull @Support @NotNull Condition ne(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
notEqual(Row10)@NotNull @Support @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)
notEqual(Row10)@NotNull @Support @NotNull Condition ne(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
notEqual(Row10)@NotNull @Support @NotNull Condition ne(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull Condition isDistinctFrom(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
@NotNull @Support @NotNull Condition isDistinctFrom(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
@NotNull @Support @NotNull Condition isDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
@NotNull @Support @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)
@NotNull @Support @NotNull Condition isDistinctFrom(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull Condition isNotDistinctFrom(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
@NotNull @Support @NotNull Condition isNotDistinctFrom(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
@NotNull @Support @NotNull Condition isNotDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
@NotNull @Support @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)
@NotNull @Support @NotNull Condition isNotDistinctFrom(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull Condition lessThan(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Row order comparison predicates can be emulated in those
databases that do not support such predicates natively:
(A, B, C) < (1, 2, 3) is equivalent to
A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3)
@NotNull @Support @NotNull Condition lessThan(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
lessThan(Row10)@NotNull @Support @NotNull Condition lessThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
lessThan(Row10)@NotNull @Support @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)
lessThan(Row10)@NotNull @Support @NotNull Condition lessThan(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
lessThan(Row10)@NotNull @Support @NotNull Condition lessThan(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull Condition lt(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
lessThan(Row10)@NotNull @Support @NotNull Condition lt(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
lessThan(Row10)@NotNull @Support @NotNull Condition lt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
lessThan(Row10)@NotNull @Support @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)
lessThan(Row10)@NotNull @Support @NotNull Condition lt(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
lessThan(Row10)@NotNull @Support @NotNull Condition lt(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull Condition lessOrEqual(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Row order comparison predicates can be emulated in those
databases that do not support such predicates natively:
(A, B) <= (1, 2) is equivalent to
A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2)
@NotNull @Support @NotNull Condition lessOrEqual(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
lessOrEqual(Row10)@NotNull @Support @NotNull Condition lessOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
lessOrEqual(Row10)@NotNull @Support @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)
lessOrEqual(Row10)@NotNull @Support @NotNull Condition lessOrEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
lessOrEqual(Row10)@NotNull @Support @NotNull Condition lessOrEqual(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull Condition le(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
lessOrEqual(Row10)@NotNull @Support @NotNull Condition le(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
lessOrEqual(Row10)@NotNull @Support @NotNull Condition le(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
lessOrEqual(Row10)@NotNull @Support @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)
lessOrEqual(Row10)@NotNull @Support @NotNull Condition le(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
lessOrEqual(Row10)@NotNull @Support @NotNull Condition le(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull Condition greaterThan(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Row order comparison predicates can be emulated in those
databases that do not support such predicates natively:
(A, B, C) > (1, 2, 3) is equivalent to
A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3)
@NotNull @Support @NotNull Condition greaterThan(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
greaterThan(Row10)@NotNull @Support @NotNull Condition greaterThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
greaterThan(Row10)@NotNull @Support @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)
greaterThan(Row10)@NotNull @Support @NotNull Condition greaterThan(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
greaterThan(Row10)@NotNull @Support @NotNull Condition greaterThan(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull Condition gt(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
greaterThan(Row10)@NotNull @Support @NotNull Condition gt(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
greaterThan(Row10)@NotNull @Support @NotNull Condition gt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
greaterThan(Row10)@NotNull @Support @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)
greaterThan(Row10)@NotNull @Support @NotNull Condition gt(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
greaterThan(Row10)@NotNull @Support @NotNull Condition gt(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull Condition greaterOrEqual(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
Row order comparison predicates can be emulated in those
databases that do not support such predicates natively:
(A, B) >= (1, 2) is equivalent to
A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2)
@NotNull @Support @NotNull Condition greaterOrEqual(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
greaterOrEqual(Row10)@NotNull @Support @NotNull Condition greaterOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
greaterOrEqual(Row10)@NotNull @Support @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)
greaterOrEqual(Row10)@NotNull @Support @NotNull Condition greaterOrEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
greaterOrEqual(Row10)@NotNull @Support @NotNull Condition greaterOrEqual(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull Condition ge(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
greaterOrEqual(Row10)@NotNull @Support @NotNull Condition ge(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
greaterOrEqual(Row10)@NotNull @Support @NotNull Condition ge(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
greaterOrEqual(Row10)@NotNull @Support @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)
greaterOrEqual(Row10)@NotNull @Support @NotNull Condition ge(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
greaterOrEqual(Row10)@NotNull @Support @NotNull Condition ge(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)
between(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> 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)
between(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> between(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
between(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> between(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
between(Row10, Row10)@NotNull @Support @NotNull Condition between(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
This is the same as calling between(minValue).and(maxValue)
The expression A BETWEEN B AND C is equivalent to the
expression A >= B AND A <= C for those SQL dialects that do
not properly support the BETWEEN predicate for row value
expressions
@NotNull @Support @NotNull Condition between(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
This is the same as calling between(minValue).and(maxValue)
between(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)
betweenSymmetric(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> 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)
betweenSymmetric(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> betweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
betweenSymmetric(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> betweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
betweenSymmetric(Row10, Row10)@NotNull @Support @NotNull Condition betweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
This is the same as calling betweenSymmetric(minValue).and(maxValue)
The expression A BETWEEN SYMMETRIC B AND C is equivalent to
the expression (A >= B AND A <= C) OR (A >= C AND A <= B)
for those SQL dialects that do not properly support the
BETWEEN predicate for row value expressions
@NotNull @Support @NotNull Condition betweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
This is the same as calling betweenSymmetric(minValue).and(maxValue)
betweenSymmetric(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetween(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)
between(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> 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)
notBetween(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetween(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
notBetween(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetween(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
notBetween(Row10, Row10)@NotNull @Support @NotNull Condition notBetween(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
This is the same as calling notBetween(minValue).and(maxValue)
The expression A NOT BETWEEN B AND C is equivalent to the
expression A < B OR A > C for those SQL dialects that do
not properly support the BETWEEN predicate for row value
expressions
@NotNull @Support @NotNull Condition notBetween(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
This is the same as calling notBetween(minValue).and(maxValue)
notBetween(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)
notBetweenSymmetric(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> 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)
notBetweenSymmetric(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
notBetweenSymmetric(Row10, Row10)@NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
notBetweenSymmetric(Row10, Row10)@NotNull @Support @NotNull Condition notBetweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
This is the same as calling notBetweenSymmetric(minValue).and(maxValue)
The expression A NOT BETWEEN SYMMETRIC B AND C is equivalent
to the expression (A < B OR A > C) AND (A < C OR A > B) for
those SQL dialects that do not properly support the BETWEEN
predicate for row value expressions
@NotNull @Support @NotNull Condition notBetweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
This is the same as calling notBetweenSymmetric(minValue).and(maxValue)
notBetweenSymmetric(Row10, Row10)@NotNull @Support @NotNull Condition in(Collection<? extends Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> rows)
Row IN predicates can be emulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4)) is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
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 tablesIN predicates on unnested array bind variables@NotNull @Support @NotNull Condition in(Result<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> result)
Row IN predicates can be emulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4)) is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
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 tablesIN predicates on unnested array bind variables@NotNull @Support @NotNull Condition in(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... rows)
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 tablesIN predicates on unnested array bind variablesin(Collection)@NotNull @Support @NotNull Condition in(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... record)
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 tablesIN predicates on unnested array bind variablesin(Collection)@NotNull @Support @NotNull Condition in(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
in(Collection)@NotNull @Support @NotNull Condition notIn(Collection<? extends Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> rows)
Row NOT IN predicates can be emulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
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 tablesNOT IN predicates on unnested array bind variables@NotNull @Support @NotNull Condition notIn(Result<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> result)
Row NOT IN predicates can be emulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
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 tablesNOT IN predicates on unnested array bind variables@NotNull @Support @NotNull Condition notIn(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... rows)
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 tablesNOT IN predicates on unnested array bind variablesnotIn(Collection)@NotNull @Support @NotNull Condition notIn(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... record)
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 tablesNOT IN predicates on unnested array bind variablesnotIn(Collection)Copyright © 2020. All rights reserved.