-
- All Superinterfaces:
FieldOrRow
,QueryPart
,Row
,Serializable
public interface RowN extends Row
A row value expression.Row value expressions are mainly useful for use in predicates, when comparing several values in one go, which can be more elegant than expanding the row value expression predicate in other equivalent syntaxes. This is especially true for non-equality predicates. For instance, the following two predicates are equivalent in SQL:
(A, B) > (X, Y) (A > X) OR (A = X AND B > Y)
Example:
// Assuming import static org.jooq.impl.DSL.*; using(configuration) .select() .from(CUSTOMER) .where(row(CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME).in( select(ACTOR.FIRST_NAME, ACTOR.LAST_NAME).from(ACTOR) )) .fetch();
Note: Not all databases support row value expressions, but many row value expression operations can be emulated on all databases. See relevant row value expression method Javadocs for details.
Instances can be created using
DSL.row(Object...)
and overloads.- Author:
- Lukas Eder
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description BetweenAndStepN
between(Object... minValues)
Check if this row value expression is within a range of two other row value expressions.BetweenAndStepN
between(Field<?>... minValues)
Check if this row value expression is within a range of two other row value expressions.BetweenAndStepN
between(Record minValue)
Check if this row value expression is within a range of two records.Condition
between(Record minValue, Record maxValue)
Check if this row value expression is within a range of two records.BetweenAndStepN
between(RowN minValue)
Check if this row value expression is within a range of two other row value expressions.Condition
between(RowN minValue, RowN maxValue)
Check if this row value expression is within a range of two other row value expressions.BetweenAndStepN
betweenSymmetric(Object... minValues)
Check if this row value expression is within a symmetric range of two other row value expressions.BetweenAndStepN
betweenSymmetric(Field<?>... minValues)
Check if this row value expression is within a symmetric range of two other row value expressions.BetweenAndStepN
betweenSymmetric(Record minValue)
Check if this row value expression is within a symmetric range of two records.Condition
betweenSymmetric(Record minValue, Record maxValue)
Check if this row value expression is within a symmetric range of two records.BetweenAndStepN
betweenSymmetric(RowN minValue)
Check if this row value expression is within a symmetric range of two other row value expressions.Condition
betweenSymmetric(RowN minValue, RowN maxValue)
Check if this row value expression is within a symmetric range of two other row value expressions.Condition
compare(Comparator comparator, Object... values)
Compare this row value expression with another row value expression using a dynamic comparator.Condition
compare(Comparator comparator, Field<?>... values)
Compare this row value expression with another row value expression using a dynamic comparator.Condition
compare(Comparator comparator, QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect using a dynamic comparator.Condition
compare(Comparator comparator, Record record)
Compare this row value expression with a record using a dynamic comparator.Condition
compare(Comparator comparator, RowN row)
Compare this row value expression with another row value expression using a dynamic comparator.Condition
compare(Comparator comparator, Select<? extends Record> select)
Compare this row value expression with a subselect using a dynamic comparator.Condition
eq(Object... values)
Compare this row value expression with another row value expression for equality.Condition
eq(Field<?>... values)
Compare this row value expression with another row value expression for equality.Condition
eq(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for equality.Condition
eq(Record record)
Compare this row value expression with a record for equality.Condition
eq(RowN row)
Compare this row value expression with another row value expression for equality.Condition
eq(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.Condition
equal(Object... values)
Compare this row value expression with another row value expression for equality.Condition
equal(Field<?>... values)
Compare this row value expression with another row value expression for equality.Condition
equal(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for equality.Condition
equal(Record record)
Compare this row value expression with a record for equality.Condition
equal(RowN row)
Compare this row value expression with another row value expression for equality.Condition
equal(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.Condition
ge(Object... values)
Compare this row value expression with another row value expression for order.Condition
ge(Field<?>... values)
Compare this row value expression with another row value expression for order.Condition
ge(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
ge(Record record)
Compare this row value expression with a record for order.Condition
ge(RowN row)
Compare this row value expression with another row value expression for order.Condition
ge(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
greaterOrEqual(Object... values)
Compare this row value expression with another row value expression for order.Condition
greaterOrEqual(Field<?>... values)
Compare this row value expression with another row value expression for order.Condition
greaterOrEqual(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
greaterOrEqual(Record record)
Compare this row value expression with a record for order.Condition
greaterOrEqual(RowN row)
Compare this row value expression with another row value expression for order.Condition
greaterOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
greaterThan(Object... values)
Compare this row value expression with another row value expression for order.Condition
greaterThan(Field<?>... values)
Compare this row value expression with another row value expression for order.Condition
greaterThan(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
greaterThan(Record record)
Compare this row value expression with a record for order.Condition
greaterThan(RowN row)
Compare this row value expression with another row value expression for order.Condition
greaterThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
gt(Object... values)
Compare this row value expression with another row value expression for order.Condition
gt(Field<?>... values)
Compare this row value expression with another row value expression for order.Condition
gt(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
gt(Record record)
Compare this row value expression with a record for order.Condition
gt(RowN row)
Compare this row value expression with another row value expression for order.Condition
gt(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
in(Collection<? extends RowN> rows)
Compare this row value expression with a set of row value expressions for equality.Condition
in(Record... record)
Compare this row value expression with a set of records for equality.Condition
in(Result<? extends Record> result)
Compare this row value expression with a set of records for equality.Condition
in(RowN... rows)
Compare this row value expression with a set of row value expressions for equality.Condition
in(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.Condition
isDistinctFrom(Object... values)
Compare this row value expression with another row value expression for distinctness.Condition
isDistinctFrom(Field<?>... values)
Compare this row value expression with another row value expression for distinctness.Condition
isDistinctFrom(Record record)
Compare this row value expression with another row value expression for distinctness.Condition
isDistinctFrom(RowN row)
Compare this row value expression with another row value expression for distinctness.Condition
isNotDistinctFrom(Object... values)
Compare this row value expression with another row value expression for distinctness.Condition
isNotDistinctFrom(Field<?>... values)
Compare this row value expression with another row value expression for distinctness.Condition
isNotDistinctFrom(Record record)
Compare this row value expression with another row value expression for distinctness.Condition
isNotDistinctFrom(RowN row)
Compare this row value expression with another row value expression for distinctness.Condition
le(Object... values)
Compare this row value expression with another row value expression for order.Condition
le(Field<?>... values)
Compare this row value expression with another row value expression for order.Condition
le(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
le(Record record)
Compare this row value expression with a record for order.Condition
le(RowN row)
Compare this row value expression with another row value expression for order.Condition
le(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
lessOrEqual(Object... values)
Compare this row value expression with another row value expression for order.Condition
lessOrEqual(Field<?>... values)
Compare this row value expression with another row value expression for order.Condition
lessOrEqual(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
lessOrEqual(Record record)
Compare this row value expression with a record for order.Condition
lessOrEqual(RowN row)
Compare this row value expression with another row value expression for order.Condition
lessOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
lessThan(Object... values)
Compare this row value expression with another row value expression for order.Condition
lessThan(Field<?>... values)
Compare this row value expression with another row value expression for order.Condition
lessThan(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
lessThan(Record record)
Compare this row value expression with a record for order.Condition
lessThan(RowN row)
Compare this row value expression with another row value expression for order.Condition
lessThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
lt(Object... values)
Compare this row value expression with another row value expression for order.Condition
lt(Field<?>... values)
Compare this row value expression with another row value expression for order.Condition
lt(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
lt(Record record)
Compare this row value expression with a record for order.Condition
lt(RowN row)
Compare this row value expression with another row value expression for order.Condition
lt(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
ne(Object... values)
Compare this row value expression with another row value expression for non-equality.Condition
ne(Field<?>... values)
Compare this row value expression with another row value expression for non-equality.Condition
ne(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for non-equality.Condition
ne(Record record)
Compare this row value expression with a record for non-equality.Condition
ne(RowN row)
Compare this row value expression with another row value expression for non-equality.Condition
ne(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.BetweenAndStepN
notBetween(Object... minValues)
Check if this row value expression is not within a range of two other row value expressions.BetweenAndStepN
notBetween(Field<?>... minValues)
Check if this row value expression is not within a range of two other row value expressions.BetweenAndStepN
notBetween(Record minValue)
Check if this row value expression is within a range of two records.Condition
notBetween(Record minValue, Record maxValue)
Check if this row value expression is within a range of two records.BetweenAndStepN
notBetween(RowN minValue)
Check if this row value expression is not within a range of two other row value expressions.Condition
notBetween(RowN minValue, RowN maxValue)
Check if this row value expression is not within a range of two other row value expressions.BetweenAndStepN
notBetweenSymmetric(Object... minValues)
Check if this row value expression is not within a symmetric range of two other row value expressions.BetweenAndStepN
notBetweenSymmetric(Field<?>... minValues)
Check if this row value expression is not within a symmetric range of two other row value expressions.BetweenAndStepN
notBetweenSymmetric(Record minValue)
Check if this row value expression is not within a symmetric range of two records.Condition
notBetweenSymmetric(Record minValue, Record maxValue)
Check if this row value expression is not within a symmetric range of two records.BetweenAndStepN
notBetweenSymmetric(RowN minValue)
Check if this row value expression is not within a symmetric range of two other row value expressions.Condition
notBetweenSymmetric(RowN minValue, RowN maxValue)
Check if this row value expression is not within a symmetric range of two other row value expressions.Condition
notEqual(Object... values)
Compare this row value expression with another row value expression for.Condition
notEqual(Field<?>... values)
Compare this row value expression with another row value expression for non-equality.Condition
notEqual(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for non-equality.Condition
notEqual(Record record)
Compare this row value expression with a record for non-equalityCondition
notEqual(RowN row)
Compare this row value expression with another row value expression for non-equality.Condition
notEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.Condition
notIn(Collection<? extends RowN> rows)
Compare this row value expression with a set of row value expressions for equality.Condition
notIn(Record... record)
Compare this row value expression with a set of records for non-equality.Condition
notIn(Result<? extends Record> result)
Compare this row value expression with a set of records for equality.Condition
notIn(RowN... rows)
Compare this row value expression with a set of row value expressions for equality.Condition
notIn(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.
-
-
-
Method Detail
-
compare
@Support Condition compare(Comparator comparator, RowN row)
Compare this row value expression with another row value expression using a dynamic comparator.See the explicit comparison methods for details. Note, not all
Comparator
types are supported
-
compare
@Support Condition compare(Comparator comparator, Record record)
Compare this row value expression with a record using a dynamic comparator.See the explicit comparison methods for details. Note, not all
Comparator
types are supported
-
compare
@Support Condition compare(Comparator comparator, Object... values)
Compare this row value expression with another row value expression using a dynamic comparator.See the explicit comparison methods for details. Note, not all
Comparator
types are supported
-
compare
@Support Condition compare(Comparator comparator, Field<?>... values)
Compare this row value expression with another row value expression using a dynamic comparator.See the explicit comparison methods for details. Note, not all
Comparator
types are supported
-
compare
@Support Condition compare(Comparator comparator, Select<? extends Record> select)
Compare this row value expression with a subselect using a dynamic comparator.See the explicit comparison methods for details. Note, not all
Comparator
types are supported
-
compare
@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES,SYBASE,VERTICA}) Condition compare(Comparator comparator, QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect using a dynamic comparator.See the explicit comparison methods for details. Note, not all
Comparator
types are supported
-
equal
@Support Condition equal(RowN row)
Compare this row value expression with another row value expression for equality.Row equality comparison predicates can be emulated in those databases that do not support such predicates natively:
(A, B) = (1, 2)
is equivalent toA = 1 AND B = 2
-
equal
@Support Condition equal(Record record)
Compare this row value expression with a record for equality.- See Also:
equal(RowN)
-
equal
@Support Condition equal(Object... values)
Compare this row value expression with another row value expression for equality.- See Also:
equal(RowN)
-
equal
@Support Condition equal(Field<?>... values)
Compare this row value expression with another row value expression for equality.- See Also:
equal(RowN)
-
equal
@Support Condition equal(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.- See Also:
equal(RowN)
-
equal
@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES,SYBASE,VERTICA}) Condition equal(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for equality.
-
eq
@Support Condition eq(RowN row)
Compare this row value expression with another row value expression for equality.- See Also:
equal(RowN)
-
eq
@Support Condition eq(Record record)
Compare this row value expression with a record for equality.- See Also:
equal(RowN)
-
eq
@Support Condition eq(Object... values)
Compare this row value expression with another row value expression for equality.- See Also:
equal(RowN)
-
eq
@Support Condition eq(Field<?>... values)
Compare this row value expression with another row value expression for equality.- See Also:
equal(RowN)
-
eq
@Support Condition eq(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.- See Also:
equal(RowN)
-
eq
@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES,SYBASE,VERTICA}) Condition eq(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for equality.
-
notEqual
@Support Condition notEqual(RowN row)
Compare this row value expression with another row value expression for non-equality.Row non-equality comparison predicates can be emulated in those databases that do not support such predicates natively:
(A, B) <> (1, 2)
is equivalent toNOT(A = 1 AND B = 2)
-
notEqual
@Support Condition notEqual(Record record)
Compare this row value expression with a record for non-equality- See Also:
notEqual(RowN)
-
notEqual
@Support Condition notEqual(Object... values)
Compare this row value expression with another row value expression for. non-equality- See Also:
notEqual(RowN)
-
notEqual
@Support Condition notEqual(Field<?>... values)
Compare this row value expression with another row value expression for non-equality.- See Also:
notEqual(RowN)
-
notEqual
@Support Condition notEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.- See Also:
notEqual(RowN)
-
notEqual
@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES,REDSHIFT,SYBASE}) Condition notEqual(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for non-equality.
-
ne
@Support Condition ne(RowN row)
Compare this row value expression with another row value expression for non-equality.- See Also:
notEqual(RowN)
-
ne
@Support Condition ne(Record record)
Compare this row value expression with a record for non-equality.- See Also:
notEqual(RowN)
-
ne
@Support Condition ne(Object... values)
Compare this row value expression with another row value expression for non-equality.- See Also:
notEqual(RowN)
-
ne
@Support Condition ne(Field<?>... values)
Compare this row value expression with another row value expression for non-equality.- See Also:
notEqual(RowN)
-
ne
@Support Condition ne(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.- See Also:
notEqual(RowN)
-
ne
@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES,REDSHIFT,SYBASE}) Condition ne(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for non-equality.
-
isDistinctFrom
@Support Condition isDistinctFrom(RowN row)
Compare this row value expression with another row value expression for distinctness.
-
isDistinctFrom
@Support Condition isDistinctFrom(Record record)
Compare this row value expression with another row value expression for distinctness.
-
isDistinctFrom
@Support Condition isDistinctFrom(Object... values)
Compare this row value expression with another row value expression for distinctness.
-
isDistinctFrom
@Support Condition isDistinctFrom(Field<?>... values)
Compare this row value expression with another row value expression for distinctness.
-
isNotDistinctFrom
@Support Condition isNotDistinctFrom(RowN row)
Compare this row value expression with another row value expression for distinctness.
-
isNotDistinctFrom
@Support Condition isNotDistinctFrom(Record record)
Compare this row value expression with another row value expression for distinctness.
-
isNotDistinctFrom
@Support Condition isNotDistinctFrom(Object... values)
Compare this row value expression with another row value expression for distinctness.
-
isNotDistinctFrom
@Support Condition isNotDistinctFrom(Field<?>... values)
Compare this row value expression with another row value expression for distinctness.
-
lessThan
@Support Condition lessThan(RowN row)
Compare this row value expression with another row value expression for order.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 toA < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3)
-
lessThan
@Support Condition lessThan(Record record)
Compare this row value expression with a record for order.- See Also:
lessThan(RowN)
-
lessThan
@Support Condition lessThan(Object... values)
Compare this row value expression with another row value expression for order.- See Also:
lessThan(RowN)
-
lessThan
@Support Condition lessThan(Field<?>... values)
Compare this row value expression with another row value expression for order.- See Also:
lessThan(RowN)
-
lessThan
@Support Condition lessThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order.- See Also:
lessThan(RowN)
-
lessThan
@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE}) Condition lessThan(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.
-
lt
@Support Condition lt(RowN row)
Compare this row value expression with another row value expression for order.- See Also:
lessThan(RowN)
-
lt
@Support Condition lt(Record record)
Compare this row value expression with a record for order.- See Also:
lessThan(RowN)
-
lt
@Support Condition lt(Object... values)
Compare this row value expression with another row value expression for order.- See Also:
lessThan(RowN)
-
lt
@Support Condition lt(Field<?>... values)
Compare this row value expression with another row value expression for order.- See Also:
lessThan(RowN)
-
lt
@Support Condition lt(Select<? extends Record> select)
Compare this row value expression with a subselect for order.- See Also:
lessThan(RowN)
-
lt
@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE}) Condition lt(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.
-
lessOrEqual
@Support Condition lessOrEqual(RowN row)
Compare this row value expression with another row value expression for order.Row order comparison predicates can be emulated in those databases that do not support such predicates natively:
(A, B) <= (1, 2)
is equivalent toA < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2)
-
lessOrEqual
@Support Condition lessOrEqual(Record record)
Compare this row value expression with a record for order.- See Also:
lessOrEqual(RowN)
-
lessOrEqual
@Support Condition lessOrEqual(Object... values)
Compare this row value expression with another row value expression for order.- See Also:
lessOrEqual(RowN)
-
lessOrEqual
@Support Condition lessOrEqual(Field<?>... values)
Compare this row value expression with another row value expression for order.- See Also:
lessOrEqual(RowN)
-
lessOrEqual
@Support Condition lessOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order.- See Also:
lessOrEqual(RowN)
-
lessOrEqual
@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE}) Condition lessOrEqual(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.
-
le
@Support Condition le(RowN row)
Compare this row value expression with another row value expression for order.- See Also:
lessOrEqual(RowN)
-
le
@Support Condition le(Record record)
Compare this row value expression with a record for order.- See Also:
lessOrEqual(RowN)
-
le
@Support Condition le(Object... values)
Compare this row value expression with another row value expression for order.- See Also:
lessOrEqual(RowN)
-
le
@Support Condition le(Field<?>... values)
Compare this row value expression with another row value expression for order.- See Also:
lessOrEqual(RowN)
-
le
@Support Condition le(Select<? extends Record> select)
Compare this row value expression with a subselect for order.- See Also:
lessOrEqual(RowN)
-
le
@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE}) Condition le(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.
-
greaterThan
@Support Condition greaterThan(RowN row)
Compare this row value expression with another row value expression for order.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 toA > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3)
-
greaterThan
@Support Condition greaterThan(Record record)
Compare this row value expression with a record for order.- See Also:
greaterThan(RowN)
-
greaterThan
@Support Condition greaterThan(Object... values)
Compare this row value expression with another row value expression for order.- See Also:
greaterThan(RowN)
-
greaterThan
@Support Condition greaterThan(Field<?>... values)
Compare this row value expression with another row value expression for order.- See Also:
greaterThan(RowN)
-
greaterThan
@Support Condition greaterThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order.- See Also:
greaterThan(RowN)
-
greaterThan
@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE}) Condition greaterThan(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.
-
gt
@Support Condition gt(RowN row)
Compare this row value expression with another row value expression for order.- See Also:
greaterThan(RowN)
-
gt
@Support Condition gt(Record record)
Compare this row value expression with a record for order.- See Also:
greaterThan(RowN)
-
gt
@Support Condition gt(Object... values)
Compare this row value expression with another row value expression for order.- See Also:
greaterThan(RowN)
-
gt
@Support Condition gt(Field<?>... values)
Compare this row value expression with another row value expression for order.- See Also:
greaterThan(RowN)
-
gt
@Support Condition gt(Select<? extends Record> select)
Compare this row value expression with a subselect for order.- See Also:
greaterThan(RowN)
-
gt
@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE}) Condition gt(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.
-
greaterOrEqual
@Support Condition greaterOrEqual(RowN row)
Compare this row value expression with another row value expression for order.Row order comparison predicates can be emulated in those databases that do not support such predicates natively:
(A, B) >= (1, 2)
is equivalent toA > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2)
-
greaterOrEqual
@Support Condition greaterOrEqual(Record record)
Compare this row value expression with a record for order.- See Also:
greaterOrEqual(RowN)
-
greaterOrEqual
@Support Condition greaterOrEqual(Object... values)
Compare this row value expression with another row value expression for order.- See Also:
greaterOrEqual(RowN)
-
greaterOrEqual
@Support Condition greaterOrEqual(Field<?>... values)
Compare this row value expression with another row value expression for order.- See Also:
greaterOrEqual(RowN)
-
greaterOrEqual
@Support Condition greaterOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order.- See Also:
greaterOrEqual(RowN)
-
greaterOrEqual
@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE}) Condition greaterOrEqual(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.
-
ge
@Support Condition ge(RowN row)
Compare this row value expression with another row value expression for order.- See Also:
greaterOrEqual(RowN)
-
ge
@Support Condition ge(Record record)
Compare this row value expression with a record for order.- See Also:
greaterOrEqual(RowN)
-
ge
@Support Condition ge(Object... values)
Compare this row value expression with another row value expression for order.- See Also:
greaterOrEqual(RowN)
-
ge
@Support Condition ge(Field<?>... values)
Compare this row value expression with another row value expression for order.- See Also:
greaterOrEqual(RowN)
-
ge
@Support Condition ge(Select<? extends Record> select)
Compare this row value expression with a subselect for order.- See Also:
greaterOrEqual(RowN)
-
ge
@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE}) Condition ge(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.
-
between
@Support BetweenAndStepN between(Object... minValues)
Check if this row value expression is within a range of two other row value expressions.- See Also:
between(RowN, RowN)
-
between
@Support BetweenAndStepN between(Field<?>... minValues)
Check if this row value expression is within a range of two other row value expressions.- See Also:
between(RowN, RowN)
-
between
@Support BetweenAndStepN between(RowN minValue)
Check if this row value expression is within a range of two other row value expressions.- See Also:
between(RowN, RowN)
-
between
@Support BetweenAndStepN between(Record minValue)
Check if this row value expression is within a range of two records.- See Also:
between(RowN, RowN)
-
between
@Support Condition between(RowN minValue, RowN maxValue)
Check if this row value expression is within a range of two other row value expressions.This is the same as calling
between(minValue).and(maxValue)
The expression
A BETWEEN B AND C
is equivalent to the expressionA >= B AND A <= C
for those SQL dialects that do not properly support theBETWEEN
predicate for row value expressions
-
between
@Support Condition between(Record minValue, Record maxValue)
Check if this row value expression is within a range of two records.This is the same as calling
between(minValue).and(maxValue)
- See Also:
between(RowN, RowN)
-
betweenSymmetric
@Support BetweenAndStepN betweenSymmetric(Object... minValues)
Check if this row value expression is within a symmetric range of two other row value expressions.- See Also:
betweenSymmetric(RowN, RowN)
-
betweenSymmetric
@Support BetweenAndStepN betweenSymmetric(Field<?>... minValues)
Check if this row value expression is within a symmetric range of two other row value expressions.- See Also:
betweenSymmetric(RowN, RowN)
-
betweenSymmetric
@Support BetweenAndStepN betweenSymmetric(RowN minValue)
Check if this row value expression is within a symmetric range of two other row value expressions.- See Also:
betweenSymmetric(RowN, RowN)
-
betweenSymmetric
@Support BetweenAndStepN betweenSymmetric(Record minValue)
Check if this row value expression is within a symmetric range of two records.- See Also:
betweenSymmetric(RowN, RowN)
-
betweenSymmetric
@Support Condition betweenSymmetric(RowN minValue, RowN maxValue)
Check if this row value expression is within a symmetric range of two other row value expressions.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 theBETWEEN
predicate for row value expressions
-
betweenSymmetric
@Support Condition betweenSymmetric(Record minValue, Record maxValue)
Check if this row value expression is within a symmetric range of two records.This is the same as calling
betweenSymmetric(minValue).and(maxValue)
- See Also:
betweenSymmetric(RowN, RowN)
-
notBetween
@Support BetweenAndStepN notBetween(Object... minValues)
Check if this row value expression is not within a range of two other row value expressions.- See Also:
between(RowN, RowN)
-
notBetween
@Support BetweenAndStepN notBetween(Field<?>... minValues)
Check if this row value expression is not within a range of two other row value expressions.- See Also:
notBetween(RowN, RowN)
-
notBetween
@Support BetweenAndStepN notBetween(RowN minValue)
Check if this row value expression is not within a range of two other row value expressions.- See Also:
notBetween(RowN, RowN)
-
notBetween
@Support BetweenAndStepN notBetween(Record minValue)
Check if this row value expression is within a range of two records.- See Also:
notBetween(RowN, RowN)
-
notBetween
@Support Condition notBetween(RowN minValue, RowN maxValue)
Check if this row value expression is not within a range of two other row value expressions.This is the same as calling
notBetween(minValue).and(maxValue)
The expression
A NOT BETWEEN B AND C
is equivalent to the expressionA < B OR A > C
for those SQL dialects that do not properly support theBETWEEN
predicate for row value expressions
-
notBetween
@Support Condition notBetween(Record minValue, Record maxValue)
Check if this row value expression is within a range of two records.This is the same as calling
notBetween(minValue).and(maxValue)
- See Also:
notBetween(RowN, RowN)
-
notBetweenSymmetric
@Support BetweenAndStepN notBetweenSymmetric(Object... minValues)
Check if this row value expression is not within a symmetric range of two other row value expressions.- See Also:
notBetweenSymmetric(RowN, RowN)
-
notBetweenSymmetric
@Support BetweenAndStepN notBetweenSymmetric(Field<?>... minValues)
Check if this row value expression is not within a symmetric range of two other row value expressions.- See Also:
notBetweenSymmetric(RowN, RowN)
-
notBetweenSymmetric
@Support BetweenAndStepN notBetweenSymmetric(RowN minValue)
Check if this row value expression is not within a symmetric range of two other row value expressions.- See Also:
notBetweenSymmetric(RowN, RowN)
-
notBetweenSymmetric
@Support BetweenAndStepN notBetweenSymmetric(Record minValue)
Check if this row value expression is not within a symmetric range of two records.- See Also:
notBetweenSymmetric(RowN, RowN)
-
notBetweenSymmetric
@Support Condition notBetweenSymmetric(RowN minValue, RowN maxValue)
Check if this row value expression is not within a symmetric range of two other row value expressions.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 theBETWEEN
predicate for row value expressions
-
notBetweenSymmetric
@Support Condition notBetweenSymmetric(Record minValue, Record maxValue)
Check if this row value expression is not within a symmetric range of two records.This is the same as calling
notBetweenSymmetric(minValue).and(maxValue)
- See Also:
notBetweenSymmetric(RowN, RowN)
-
in
@Support Condition in(Collection<? extends RowN> rows)
Compare this row value expression with a set of row value expressions for equality.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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables
-
in
@Support Condition in(Result<? extends Record> result)
Compare this row value expression with a set of records for equality.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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables
-
in
@Support Condition in(RowN... rows)
Compare this row value expression with a set of row value expressions for equality.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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables
- See Also:
in(Collection)
-
in
@Support Condition in(Record... record)
Compare this row value expression with a set of records for equality.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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables
- See Also:
in(Collection)
-
in
@Support Condition in(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.- See Also:
in(Collection)
-
notIn
@Support Condition notIn(Collection<? extends RowN> rows)
Compare this row value expression with a set of row value expressions for equality.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 toNOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4)))
, which is equivalent toNOT((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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables
-
notIn
@Support Condition notIn(Result<? extends Record> result)
Compare this row value expression with a set of records for equality.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 toNOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4)))
, which is equivalent toNOT((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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables
-
notIn
@Support Condition notIn(RowN... rows)
Compare this row value expression with a set of row value expressions for equality.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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables
- See Also:
notIn(Collection)
-
notIn
@Support Condition notIn(Record... record)
Compare this row value expression with a set of records for non-equality.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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables
- See Also:
notIn(Collection)
-
notIn
@Support Condition notIn(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.- See Also:
notIn(Collection)
-
-