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 BetweenAndStep11 | between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11)
Check if this row value expression is within a range of two other row value expressions. |
| public @NotNull BetweenAndStep11 | 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)
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 BetweenAndStep11 | |
| public @NotNull BetweenAndStep11 | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull BetweenAndStep11 | betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11)
Check if this row value expression is within a symmetric range of two other row value expressions. |
| public @NotNull BetweenAndStep11 | 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)
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 BetweenAndStep11 | betweenSymmetric(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> minValue)
Check if this row value expression is within a symmetric range of two other row value expressions. |
| public @NotNull BetweenAndStep11 | betweenSymmetric(Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> minValue)
Check if this row value expression is within a symmetric range of two records. |
| public @NotNull Condition | betweenSymmetric(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> minValue, Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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(Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> minValue, Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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, Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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, Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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, T11 t11)
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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 Field | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | ge(QuantifiedSelect<? extends Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | greaterOrEqual(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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(Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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, T11 t11)
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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | greaterThan(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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(Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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, T11 t11)
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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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(Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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, T11 t11)
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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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(Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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, T11 t11)
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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | lessOrEqual(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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(Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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, T11 t11)
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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public <U> @NotNull SelectField | mapping(Function11<? super T1, ? super T2, ? super T3, ? super T4, ? super T5, ? super T6, ? super T7, ? super T8, ? super T9, ? super T10, ? super T11, ? extends U> function)
A convenience method to define a local |
| public <U> @NotNull SelectField | mapping(Class<U> uType, Function11<? super T1, ? super T2, ? super T3, ? super T4, ? super T5, ? super T6, ? super T7, ? super T8, ? super T9, ? super T10, ? super T11, ? 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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for non-equality.
Condition being deprecated.
|
| public @NotNull BetweenAndStep11 | notBetween(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11)
Check if this row value expression is not within a range of two other row value expressions. |
| public @NotNull BetweenAndStep11 | 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)
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 BetweenAndStep11 | notBetween(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> minValue)
Check if this row value expression is not within a range of two other row value expressions. |
| public @NotNull BetweenAndStep11 | notBetween(Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> minValue)
Check if this row value expression is within a range of two records. |
| public @NotNull Condition | notBetween(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> minValue, Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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(Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> minValue, Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> maxValue)
Deprecated
as a consequence of
Check if this row value expression is within a range of two records.
Condition being deprecated.
|
| public @NotNull BetweenAndStep11 | notBetweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11)
Check if this row value expression is not within a symmetric range of two other row value expressions. |
| public @NotNull BetweenAndStep11 | 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)
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 BetweenAndStep11 | notBetweenSymmetric(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> minValue)
Check if this row value expression is not within a symmetric range of two other row value expressions. |
| public @NotNull BetweenAndStep11 | notBetweenSymmetric(Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> minValue)
Check if this row value expression is not within a symmetric range of two records. |
| public @NotNull Condition | notBetweenSymmetric(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> minValue, Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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(Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> minValue, Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> 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 Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> 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 |