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 BetweenAndStep1 | between(T1 minValue1)
Check if this row value expression is within a range of two other row value expressions. |
| public @NotNull BetweenAndStep1 | |
| public @NotNull BetweenAndStep1 | |
| public @NotNull BetweenAndStep1 | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull BetweenAndStep1 | betweenSymmetric(T1 minValue1)
Check if this row value expression is within a symmetric range of two other row value expressions. |
| public @NotNull BetweenAndStep1 | betweenSymmetric(Field<T1> minValue1)
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 BetweenAndStep1 | betweenSymmetric(Row1<T1> minValue)
Check if this row value expression is within a symmetric range of two other row value expressions. |
| public @NotNull BetweenAndStep1 | betweenSymmetric(Record1<T1> minValue)
Check if this row value expression is within a symmetric range of two records. |
| public @NotNull Condition | betweenSymmetric(Row1<T1> minValue, Row1<T1> 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(Record1<T1> minValue, Record1<T1> 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, Row1<T1> 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, Record1<T1> 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)
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, Field<T1> t1)
Compare this row value expression with another row value expression
using a dynamic comparator.
|
| public @NotNull Condition | compare(Comparator comparator, Select<? extends Record1<T1>> 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 Record1<T1>> 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 Record1<T1>> 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 Record1<T1>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for equality.
Condition being deprecated.
|
| public @NotNull Field | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | ge(QuantifiedSelect<? extends Record1<T1>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | greaterOrEqual(Row1<T1> 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(Record1<T1> 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)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
order.
Condition being deprecated.
|
| public @NotNull Condition | greaterOrEqual(Field<T1> t1)
Compare this row value expression with another row value expression for
order.
|
| public @NotNull Condition | greaterOrEqual(Select<? extends Record1<T1>> 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 Record1<T1>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | greaterThan(Row1<T1> 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(Record1<T1> 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)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
order.
Condition being deprecated.
|
| public @NotNull Condition | greaterThan(Field<T1> t1)
Compare this row value expression with another row value expression for
order.
|
| public @NotNull Condition | greaterThan(Select<? extends Record1<T1>> 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 Record1<T1>> 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 Record1<T1>> 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 Row1<T1>> 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(Row1<T1> 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(Record1<T1> 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)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
distinctness.
Condition being deprecated.
|
| public @NotNull Condition | isDistinctFrom(Field<T1> t1)
Compare this row value expression with another row value expression for
distinctness.
|
| public @NotNull Condition | isDistinctFrom(Select<? extends Record1<T1>> 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(Row1<T1> 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(Record1<T1> 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)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
distinctness.
Condition being deprecated.
|
| public @NotNull Condition | isNotDistinctFrom(Field<T1> t1)
Compare this row value expression with another row value expression for
distinctness.
|
| public @NotNull Condition | isNotDistinctFrom(Select<? extends Record1<T1>> 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 Record1<T1>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public @NotNull Condition | lessOrEqual(Row1<T1> 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(Record1<T1> 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)
Deprecated
as a consequence of
Compare this row value expression with another row value expression for
order.
Condition being deprecated.
|
| public @NotNull Condition | lessOrEqual(Field<T1> t1)
Compare this row value expression with another row value expression for
order.
|
| public @NotNull Condition | lessOrEqual(Select<? extends Record1<T1>> 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 Record1<T1>> 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 Record1<T1>> 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 Record1<T1>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for order.
Condition being deprecated.
|
| public <U> @NotNull SelectField | mapping(Function1<? super T1, ? extends U> function)
A convenience method to define a local |
| public <U> @NotNull SelectField | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | |
| public @NotNull Condition | ne(QuantifiedSelect<? extends Record1<T1>> select)
Deprecated
as a consequence of
Compare this row value expression with a subselect for non-equality.
Condition being deprecated.
|
| public @NotNull BetweenAndStep1 | notBetween(T1 minValue1)
Check if this row value expression is not within a range of two other row value expressions. |
| public @NotNull BetweenAndStep1 | notBetween(Field<T1> minValue1)
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 BetweenAndStep1 | notBetween(Row1<T1> minValue)
Check if this row value expression is not within a range of two other row value expressions. |
| public @NotNull BetweenAndStep1 | notBetween(Record1<T1> minValue)
Check if this row value expression is within a range of two records. |
| public @NotNull Condition | notBetween(Row1<T1> minValue, Row1<T1> 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(Record1<T1> minValue, Record1<T1> maxValue)
Deprecated
as a consequence of
Check if this row value expression is within a range of two records.
Condition being deprecated.
|
| public @NotNull BetweenAndStep1 | notBetweenSymmetric(T1 minValue1)
Check if this row value expression is not within a symmetric range of two other row value expressions. |
| public @NotNull BetweenAndStep1 | notBetweenSymmetric(Field<T1> minValue1)
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 BetweenAndStep1 | notBetweenSymmetric(Row1<T1> minValue)
Check if this row value expression is not within a symmetric range of two other row value expressions. |
| public @NotNull BetweenAndStep1 | notBetweenSymmetric(Record1<T1> minValue)
Check if this row value expression is not within a symmetric range of two records. |
| public @NotNull Condition | notBetweenSymmetric(Row1<T1> minValue, Row1<T1> 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(Record1<T1> minValue, Record1<T1> 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 Record1<T1>> 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 Row1<T1>> 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 |