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 |
|---|---|
| public @NotNull BetweenAndStep10 | 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. |
| public @NotNull BetweenAndStep10 | 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)
Deprecated
as a consequence of
Check if this row value expression is within a range of two other row
value expressions.
Field being deprecated.
|
| public @NotNull BetweenAndStep10 | |
| public @NotNull BetweenAndStep10 | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull BetweenAndStep10 | 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. |
| public @NotNull BetweenAndStep10 | 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)
Deprecated
as a consequence of
Check if this row value expression is within a symmetric range of two
other row value expressions.
Field being deprecated.
|
| public @NotNull BetweenAndStep10 | 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. |
| public @NotNull BetweenAndStep10 | 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. |
| public @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)
Deprecated
as a consequence of
Check if this row value expression is within a symmetric range of two
other row value expressions.
Condition being deprecated.
|
| public @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)
Deprecated
as a consequence of
Check if this row value expression is within a symmetric range of two
records.
Condition being deprecated.
|
| public @NotNull Condition | compare(Comparator comparator, Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row)
Deprecated
as a consequence of
Compare this row value expression with another row value expression
using a dynamic comparator.
Condition being deprecated.
|
| public @NotNull Condition | compare(Comparator comparator, Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record)
Deprecated
as a consequence of
Compare this row value expression with a record
using a dynamic comparator.
Condition being deprecated.
|
| 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)
Deprecated
as a consequence of
Compare this row value expression with another row value expression
using a dynamic comparator.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | compare(Comparator comparator, Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect
using a dynamic comparator.
Condition being deprecated.
|
| public @NotNull Condition | compare(Comparator comparator, QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect
using a dynamic comparator.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | eq(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for equality.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | equal(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for equality.
Condition being deprecated.
|
| public @NotNull Field | |
| public @NotNull Field | |
| public @NotNull Field | |
| public @NotNull Field | |
| public @NotNull Field | |
| public @NotNull Field | |
| public @NotNull Field | |
| public @NotNull Field | |
| public @NotNull Field | |
| public @NotNull Field | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | ge(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | greaterOrEqual(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
order.
Condition being deprecated.
|
| public @NotNull Condition | greaterOrEqual(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record)
Deprecated
as a consequence of
Compare this row value expression with a record for order.
Condition being deprecated.
|
| public @NotNull Condition | greaterOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
order.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | greaterOrEqual(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | greaterOrEqual(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | greaterThan(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
order.
Condition being deprecated.
|
| public @NotNull Condition | greaterThan(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record)
Deprecated
as a consequence of
Compare this row value expression with a record for order.
Condition being deprecated.
|
| public @NotNull Condition | greaterThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
order.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | greaterThan(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | greaterThan(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | gt(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | in(Collection<? extends Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> rows)
Deprecated
as a consequence of
Compare this row value expression with a set of row value expressions for
equality.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | isDistinctFrom(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
distinctness.
Condition being deprecated.
|
| public @NotNull Condition | isDistinctFrom(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
distinctness.
Condition being deprecated.
|
| public @NotNull Condition | isDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
distinctness.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | isDistinctFrom(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
distinctness.
Condition being deprecated.
|
| public @NotNull Condition | isNotDistinctFrom(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
distinctness.
Condition being deprecated.
|
| public @NotNull Condition | isNotDistinctFrom(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
distinctness.
Condition being deprecated.
|
| public @NotNull Condition | isNotDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
distinctness.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | isNotDistinctFrom(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
distinctness.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | le(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | lessOrEqual(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
order.
Condition being deprecated.
|
| public @NotNull Condition | lessOrEqual(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record)
Deprecated
as a consequence of
Compare this row value expression with a record for order.
Condition being deprecated.
|
| public @NotNull Condition | lessOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
order.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | lessOrEqual(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | lessOrEqual(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | lessThan(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | lt(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public <U> @NotNull SelectField | mapping(Function10<? super T1, ? super T2, ? super T3, ? super T4, ? super T5, ? super T6, ? super T7, ? super T8, ? super T9, ? super T10, ? extends U> function)
A convenience method to define a local |
| public <U> @NotNull SelectField | mapping(Class<U> uType, Function10<? super T1, ? super T2, ? super T3, ? super T4, ? super T5, ? super T6, ? super T7, ? super T8, ? super T9, ? super T10, ? extends U> function)
A convenience method to define a local |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | ne(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for non-equality.
Condition being deprecated.
|
| public @NotNull BetweenAndStep10 | 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. |
| public @NotNull BetweenAndStep10 | 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)
Deprecated
as a consequence of
Check if this row value expression is not within a range of two other
row value expressions.
Field being deprecated.
|
| public @NotNull BetweenAndStep10 | 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. |
| public @NotNull BetweenAndStep10 | 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. |
| public @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)
Deprecated
as a consequence of
Check if this row value expression is not within a range of two other
row value expressions.
Condition being deprecated.
|
| public @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)
Deprecated
as a consequence of
Check if this row value expression is within a range of two records.
Condition being deprecated.
|
| public @NotNull BetweenAndStep10 | 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. |
| public @NotNull BetweenAndStep10 | 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)
Deprecated
as a consequence of
Check if this row value expression is not within a symmetric range of two
other row value expressions.
Field being deprecated.
|
| public @NotNull BetweenAndStep10 | 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. |
| public @NotNull BetweenAndStep10 | 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. |
| public @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)
Deprecated
as a consequence of
Check if this row value expression is not within a symmetric range of two
other row value expressions.
Condition being deprecated.
|
| public @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)
Deprecated
as a consequence of
Check if this row value expression is not within a symmetric range of two
records.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | notEqual(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for non-equality.
Condition being deprecated.
|
| public @NotNull Condition | notIn(Collection<? extends Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> rows)
Deprecated
as a consequence of
Compare this row value expression with a set of row value expressions for
equality.
Condition being deprecated.
|
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition |