@Generated(value="This class was generated using jOOQtools") public interface Row2<T1,T2> extends Row
2
Note: Not all databases support row value expressions, but many row value expression operations can be simulated on all databases. See relevant row value expression method Javadocs for details.
Modifier and Type  Method and Description 

BetweenAndStep2<T1,T2> 
between(Field<T1> minValue1,
Field<T2> minValue2)
Check if this row value expression is within a range of two other row
value expressions

BetweenAndStep2<T1,T2> 
between(Record2<T1,T2> minValue)
Check if this row value expression is within a range of two records

Condition 
between(Record2<T1,T2> minValue,
Record2<T1,T2> maxValue)
Check if this row value expression is within a range of two records
This is the same as calling
between(minValue).and(maxValue) 
BetweenAndStep2<T1,T2> 
between(Row2<T1,T2> minValue)
Check if this row value expression is within a range of two other row
value expressions

Condition 
between(Row2<T1,T2> minValue,
Row2<T1,T2> 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
expression A >= B AND A <= C for those SQL dialects that do
not properly support the BETWEEN predicate for row value
expressions 
BetweenAndStep2<T1,T2> 
between(T1 minValue1,
T2 minValue2)
Check if this row value expression is within a range of two other row
value expressions

BetweenAndStep2<T1,T2> 
betweenSymmetric(Field<T1> minValue1,
Field<T2> minValue2)
Check if this row value expression is within a symmetric range of two
other row value expressions

BetweenAndStep2<T1,T2> 
betweenSymmetric(Record2<T1,T2> minValue)
Check if this row value expression is within a symmetric range of two
records

Condition 
betweenSymmetric(Record2<T1,T2> minValue,
Record2<T1,T2> 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) 
BetweenAndStep2<T1,T2> 
betweenSymmetric(Row2<T1,T2> minValue)
Check if this row value expression is within a symmetric range of two
other row value expressions

Condition 
betweenSymmetric(Row2<T1,T2> minValue,
Row2<T1,T2> 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 the
BETWEEN predicate for row value expressions 
BetweenAndStep2<T1,T2> 
betweenSymmetric(T1 minValue1,
T2 minValue2)
Check if this row value expression is within a symmetric range of two
other row value expressions

Condition 
eq(Field<T1> t1,
Field<T2> t2)
Compare this row value expression with another row value expression for
equality

Condition 
eq(Record2<T1,T2> record)
Compare this row value expression with a record for equality

Condition 
eq(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
equality

Condition 
eq(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality

Condition 
eq(T1 t1,
T2 t2)
Compare this row value expression with another row value expression for
equality

Condition 
equal(Field<T1> t1,
Field<T2> t2)
Compare this row value expression with another row value expression for
equality

Condition 
equal(Record2<T1,T2> record)
Compare this row value expression with a record for equality

Condition 
equal(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
equality
Row equality comparison predicates can be simulated in those databases
that do not support such predicates natively:
(A, B) = (1, 2) is equivalent to
A = 1 AND B = 2 
Condition 
equal(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality

Condition 
equal(T1 t1,
T2 t2)
Compare this row value expression with another row value expression for
equality

Field<T1> 
field1()
Get the first field

Field<T2> 
field2()
Get the second field

Condition 
ge(Field<T1> t1,
Field<T2> t2)
Compare this row value expression with another row value expression for
order

Condition 
ge(Record2<T1,T2> record)
Compare this row value expression with a record for order

Condition 
ge(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order

Condition 
ge(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order

Condition 
ge(T1 t1,
T2 t2)
Compare this row value expression with another row value expression for
order

Condition 
greaterOrEqual(Field<T1> t1,
Field<T2> t2)
Compare this row value expression with another row value expression for
order

Condition 
greaterOrEqual(Record2<T1,T2> record)
Compare this row value expression with a record for order

Condition 
greaterOrEqual(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order
Row order comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) >= (1, 2) is equivalent to
A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2) 
Condition 
greaterOrEqual(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order

Condition 
greaterOrEqual(T1 t1,
T2 t2)
Compare this row value expression with another row value expression for
order

Condition 
greaterThan(Field<T1> t1,
Field<T2> t2)
Compare this row value expression with another row value expression for
order

Condition 
greaterThan(Record2<T1,T2> record)
Compare this row value expression with a record for order

Condition 
greaterThan(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order
Row order comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B, C) > (1, 2, 3) is equivalent to
A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3) 
Condition 
greaterThan(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order

Condition 
greaterThan(T1 t1,
T2 t2)
Compare this row value expression with another row value expression for
order

Condition 
gt(Field<T1> t1,
Field<T2> t2)
Compare this row value expression with another row value expression for
order

Condition 
gt(Record2<T1,T2> record)
Compare this row value expression with a record for order

Condition 
gt(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order

Condition 
gt(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order

Condition 
gt(T1 t1,
T2 t2)
Compare this row value expression with another row value expression for
order

Condition 
in(Collection<? extends Row2<T1,T2>> rows)
Compare this row value expression with a set of row value expressions for
equality
Row IN predicates can be simulated 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) 
Condition 
in(Record2<T1,T2>... record)
Compare this row value expression with a set of records for equality

Condition 
in(Row2<T1,T2>... rows)
Compare this row value expression with a set of row value expressions for
equality

Condition 
in(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality

Condition 
le(Field<T1> t1,
Field<T2> t2)
Compare this row value expression with another row value expression for
order

Condition 
le(Record2<T1,T2> record)
Compare this row value expression with a record for order

Condition 
le(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order

Condition 
le(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order

Condition 
le(T1 t1,
T2 t2)
Compare this row value expression with another row value expression for
order

Condition 
lessOrEqual(Field<T1> t1,
Field<T2> t2)
Compare this row value expression with another row value expression for
order

Condition 
lessOrEqual(Record2<T1,T2> record)
Compare this row value expression with a record for order

Condition 
lessOrEqual(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order
Row order comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <= (1, 2) is equivalent to
A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2) 
Condition 
lessOrEqual(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order

Condition 
lessOrEqual(T1 t1,
T2 t2)
Compare this row value expression with another row value expression for
order

Condition 
lessThan(Field<T1> t1,
Field<T2> t2)
Compare this row value expression with another row value expression for
order

Condition 
lessThan(Record2<T1,T2> record)
Compare this row value expression with a record for order

Condition 
lessThan(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order
Row order comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B, C) < (1, 2, 3) is equivalent to
A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3) 
Condition 
lessThan(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order

Condition 
lessThan(T1 t1,
T2 t2)
Compare this row value expression with another row value expression for
order

Condition 
lt(Field<T1> t1,
Field<T2> t2)
Compare this row value expression with another row value expression for
order

Condition 
lt(Record2<T1,T2> record)
Compare this row value expression with a record for order

Condition 
lt(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
order

Condition 
lt(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order

Condition 
lt(T1 t1,
T2 t2)
Compare this row value expression with another row value expression for
order

Condition 
ne(Field<T1> t1,
Field<T2> t2)
Compare this row value expression with another row value expression for

Condition 
ne(Record2<T1,T2> record)
Compare this row value expression with a record for nonequality

Condition 
ne(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
nonequality

Condition 
ne(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for nonequality

Condition 
ne(T1 t1,
T2 t2)
Compare this row value expression with another row value expression for
nonequality

BetweenAndStep2<T1,T2> 
notBetween(Field<T1> minValue1,
Field<T2> minValue2)
Check if this row value expression is not within a range of two other
row value expressions

BetweenAndStep2<T1,T2> 
notBetween(Record2<T1,T2> minValue)
Check if this row value expression is within a range of two records

Condition 
notBetween(Record2<T1,T2> minValue,
Record2<T1,T2> maxValue)
Check if this row value expression is within a range of two records
This is the same as calling
notBetween(minValue).and(maxValue) 
BetweenAndStep2<T1,T2> 
notBetween(Row2<T1,T2> minValue)
Check if this row value expression is not within a range of two other
row value expressions

Condition 
notBetween(Row2<T1,T2> minValue,
Row2<T1,T2> 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
expression A < B OR A > C for those SQL dialects that do
not properly support the BETWEEN predicate for row value
expressions 
BetweenAndStep2<T1,T2> 
notBetween(T1 minValue1,
T2 minValue2)
Check if this row value expression is not within a range of two other
row value expressions

BetweenAndStep2<T1,T2> 
notBetweenSymmetric(Field<T1> minValue1,
Field<T2> minValue2)
Check if this row value expression is not within a symmetric range of two
other row value expressions

BetweenAndStep2<T1,T2> 
notBetweenSymmetric(Record2<T1,T2> minValue)
Check if this row value expression is not within a symmetric range of two
records

Condition 
notBetweenSymmetric(Record2<T1,T2> minValue,
Record2<T1,T2> 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) 
BetweenAndStep2<T1,T2> 
notBetweenSymmetric(Row2<T1,T2> minValue)
Check if this row value expression is not within a symmetric range of two
other row value expressions

Condition 
notBetweenSymmetric(Row2<T1,T2> minValue,
Row2<T1,T2> 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 the BETWEEN
predicate for row value expressions 
BetweenAndStep2<T1,T2> 
notBetweenSymmetric(T1 minValue1,
T2 minValue2)
Check if this row value expression is not within a symmetric range of two
other row value expressions

Condition 
notEqual(Field<T1> t1,
Field<T2> t2)
Compare this row value expression with another row value expression for
nonequality

Condition 
notEqual(Record2<T1,T2> record)
Compare this row value expression with a record for nonequality

Condition 
notEqual(Row2<T1,T2> row)
Compare this row value expression with another row value expression for
nonequality
Row nonequality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2) is equivalent to
NOT(A = 1 AND B = 2) 
Condition 
notEqual(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for nonequality

Condition 
notEqual(T1 t1,
T2 t2)
Compare this row value expression with another row value expression for
nonequality

Condition 
notIn(Collection<? extends Row2<T1,T2>> rows)
Compare this row value expression with a set of row value expressions for
equality
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4)) is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))) , which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4)) 
Condition 
notIn(Record2<T1,T2>... record)
Compare this row value expression with a set of records for nonequality

Condition 
notIn(Row2<T1,T2>... rows)
Compare this row value expression with a set of row value expressions for
equality

Condition 
notIn(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for nonequality

Condition 
overlaps(Field<T1> t1,
Field<T2> t2)
Check if this row value expression overlaps another row value expression
The SQL standard specifies a temporal
OVERLAPS predicate,
which comes in two flavours:
(DATE, DATE) OVERLAPS (DATE, DATE)
(DATE, INTERVAL) OVERLAPS (DATE, INTERVAL)
jOOQ also supports arbitrary 2degree row value expression comparisons,
by simulating them as such
 This predicate
(A, B) OVERLAPS (C, D)
 can be simulated as such
(C <= B) AND (A <= D)

Condition 
overlaps(Row2<T1,T2> row)
Check if this row value expression overlaps another row value expression
The SQL standard specifies a temporal
OVERLAPS predicate,
which comes in two flavours:
(DATE, DATE) OVERLAPS (DATE, DATE)
(DATE, INTERVAL) OVERLAPS (DATE, INTERVAL)
jOOQ also supports arbitrary 2degree row value expression comparisons,
by simulating them as such
 This predicate
(A, B) OVERLAPS (C, D)
 can be simulated as such
(C <= B) AND (A <= D)

Condition 
overlaps(T1 t1,
T2 t2)
Check if this row value expression overlaps another row value expression
The SQL standard specifies a temporal
OVERLAPS predicate,
which comes in two flavours:
(DATE, DATE) OVERLAPS (DATE, DATE)
(DATE, INTERVAL) OVERLAPS (DATE, INTERVAL)
jOOQ also supports arbitrary 2degree row value expression comparisons,
by simulating them as such
 This predicate
(A, B) OVERLAPS (C, D)
 can be simulated as such
(C <= B) AND (A <= D)

@Support Condition equal(Row2<T1,T2> row)
Row equality comparison predicates can be simulated in those databases
that do not support such predicates natively:
(A, B) = (1, 2)
is equivalent to
A = 1 AND B = 2
@Support Condition equal(Record2<T1,T2> record)
equal(Row2)
@Support Condition equal(T1 t1, T2 t2)
equal(Row2)
@Support Condition equal(Field<T1> t1, Field<T2> t2)
equal(Row2)
@Support(value={HSQLDB,MYSQL,ORACLE,POSTGRES}) Condition equal(Select<? extends Record2<T1,T2>> select)
equal(Row2)
@Support Condition eq(Row2<T1,T2> row)
equal(Row2)
@Support Condition eq(Record2<T1,T2> record)
equal(Row2)
@Support Condition eq(T1 t1, T2 t2)
equal(Row2)
@Support Condition eq(Field<T1> t1, Field<T2> t2)
equal(Row2)
@Support(value={HSQLDB,MYSQL,ORACLE,POSTGRES}) Condition eq(Select<? extends Record2<T1,T2>> select)
equal(Row2)
@Support Condition notEqual(Row2<T1,T2> row)
Row nonequality comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2)
is equivalent to
NOT(A = 1 AND B = 2)
@Support Condition notEqual(Record2<T1,T2> record)
notEqual(Row2)
@Support Condition notEqual(T1 t1, T2 t2)
notEqual(Row2)
@Support Condition notEqual(Field<T1> t1, Field<T2> t2)
notEqual(Row2)
@Support(value={HSQLDB,MYSQL,ORACLE,POSTGRES}) Condition notEqual(Select<? extends Record2<T1,T2>> select)
notEqual(Row2)
@Support Condition ne(Row2<T1,T2> row)
notEqual(Row2)
@Support Condition ne(Record2<T1,T2> record)
notEqual(Row2)
@Support Condition ne(T1 t1, T2 t2)
notEqual(Row2)
@Support Condition ne(Field<T1> t1, Field<T2> t2)
notEqual(Row2)
@Support(value={HSQLDB,MYSQL,ORACLE,POSTGRES}) Condition ne(Select<? extends Record2<T1,T2>> select)
notEqual(Row2)
@Support Condition lessThan(Row2<T1,T2> row)
Row order comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B, C) < (1, 2, 3)
is equivalent to
A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3)
@Support Condition lessThan(Record2<T1,T2> record)
lessThan(Row2)
@Support Condition lessThan(T1 t1, T2 t2)
lessThan(Row2)
@Support Condition lessThan(Field<T1> t1, Field<T2> t2)
lessThan(Row2)
@Support(value={HSQLDB,MYSQL,POSTGRES}) Condition lessThan(Select<? extends Record2<T1,T2>> select)
lessThan(Row2)
@Support Condition lt(Row2<T1,T2> row)
lessThan(Row2)
@Support Condition lt(Record2<T1,T2> record)
lessThan(Row2)
@Support Condition lt(T1 t1, T2 t2)
lessThan(Row2)
@Support Condition lt(Field<T1> t1, Field<T2> t2)
lessThan(Row2)
@Support(value={HSQLDB,MYSQL,POSTGRES}) Condition lt(Select<? extends Record2<T1,T2>> select)
lessThan(Row2)
@Support Condition lessOrEqual(Row2<T1,T2> row)
Row order comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) <= (1, 2)
is equivalent to
A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2)
@Support Condition lessOrEqual(Record2<T1,T2> record)
lessOrEqual(Row2)
@Support Condition lessOrEqual(T1 t1, T2 t2)
lessOrEqual(Row2)
@Support Condition lessOrEqual(Field<T1> t1, Field<T2> t2)
lessOrEqual(Row2)
@Support(value={HSQLDB,MYSQL,POSTGRES}) Condition lessOrEqual(Select<? extends Record2<T1,T2>> select)
lessOrEqual(Row2)
@Support Condition le(Row2<T1,T2> row)
lessOrEqual(Row2)
@Support Condition le(Record2<T1,T2> record)
lessOrEqual(Row2)
@Support Condition le(T1 t1, T2 t2)
lessOrEqual(Row2)
@Support Condition le(Field<T1> t1, Field<T2> t2)
lessOrEqual(Row2)
@Support(value={HSQLDB,MYSQL,POSTGRES}) Condition le(Select<? extends Record2<T1,T2>> select)
lessOrEqual(Row2)
@Support Condition greaterThan(Row2<T1,T2> row)
Row order comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B, C) > (1, 2, 3)
is equivalent to
A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3)
@Support Condition greaterThan(Record2<T1,T2> record)
greaterThan(Row2)
@Support Condition greaterThan(T1 t1, T2 t2)
greaterThan(Row2)
@Support Condition greaterThan(Field<T1> t1, Field<T2> t2)
greaterThan(Row2)
@Support(value={HSQLDB,MYSQL,POSTGRES}) Condition greaterThan(Select<? extends Record2<T1,T2>> select)
greaterThan(Row2)
@Support Condition gt(Row2<T1,T2> row)
greaterThan(Row2)
@Support Condition gt(Record2<T1,T2> record)
greaterThan(Row2)
@Support Condition gt(T1 t1, T2 t2)
greaterThan(Row2)
@Support Condition gt(Field<T1> t1, Field<T2> t2)
greaterThan(Row2)
@Support(value={HSQLDB,MYSQL,POSTGRES}) Condition gt(Select<? extends Record2<T1,T2>> select)
greaterThan(Row2)
@Support Condition greaterOrEqual(Row2<T1,T2> row)
Row order comparison predicates can be simulated in those
databases that do not support such predicates natively:
(A, B) >= (1, 2)
is equivalent to
A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2)
@Support Condition greaterOrEqual(Record2<T1,T2> record)
greaterOrEqual(Row2)
@Support Condition greaterOrEqual(T1 t1, T2 t2)
greaterOrEqual(Row2)
@Support Condition greaterOrEqual(Field<T1> t1, Field<T2> t2)
greaterOrEqual(Row2)
@Support(value={HSQLDB,MYSQL,POSTGRES}) Condition greaterOrEqual(Select<? extends Record2<T1,T2>> select)
greaterOrEqual(Row2)
@Support Condition ge(Row2<T1,T2> row)
greaterOrEqual(Row2)
@Support Condition ge(Record2<T1,T2> record)
greaterOrEqual(Row2)
@Support Condition ge(T1 t1, T2 t2)
greaterOrEqual(Row2)
@Support Condition ge(Field<T1> t1, Field<T2> t2)
greaterOrEqual(Row2)
@Support(value={HSQLDB,MYSQL,POSTGRES}) Condition ge(Select<? extends Record2<T1,T2>> select)
greaterOrEqual(Row2)
@Support BetweenAndStep2<T1,T2> between(T1 minValue1, T2 minValue2)
between(Row2, Row2)
@Support BetweenAndStep2<T1,T2> between(Field<T1> minValue1, Field<T2> minValue2)
between(Row2, Row2)
@Support BetweenAndStep2<T1,T2> between(Row2<T1,T2> minValue)
between(Row2, Row2)
@Support BetweenAndStep2<T1,T2> between(Record2<T1,T2> minValue)
between(Row2, Row2)
@Support Condition between(Row2<T1,T2> minValue, Row2<T1,T2> maxValue)
This is the same as calling between(minValue).and(maxValue)
The expression A BETWEEN B AND C
is equivalent to the
expression A >= B AND A <= C
for those SQL dialects that do
not properly support the BETWEEN
predicate for row value
expressions
@Support Condition between(Record2<T1,T2> minValue, Record2<T1,T2> maxValue)
This is the same as calling between(minValue).and(maxValue)
between(Row2, Row2)
@Support BetweenAndStep2<T1,T2> betweenSymmetric(T1 minValue1, T2 minValue2)
betweenSymmetric(Row2, Row2)
@Support BetweenAndStep2<T1,T2> betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2)
betweenSymmetric(Row2, Row2)
@Support BetweenAndStep2<T1,T2> betweenSymmetric(Row2<T1,T2> minValue)
betweenSymmetric(Row2, Row2)
@Support BetweenAndStep2<T1,T2> betweenSymmetric(Record2<T1,T2> minValue)
betweenSymmetric(Row2, Row2)
@Support Condition betweenSymmetric(Row2<T1,T2> minValue, Row2<T1,T2> maxValue)
This is the same as calling betweenSymmetric(minValue).and(maxValue)
The expression A BETWEEN SYMMETRIC B AND C
is equivalent to
the expression (A >= B AND A <= C) OR (A >= C AND A <= B)
for those SQL dialects that do not properly support the
BETWEEN
predicate for row value expressions
@Support Condition betweenSymmetric(Record2<T1,T2> minValue, Record2<T1,T2> maxValue)
This is the same as calling betweenSymmetric(minValue).and(maxValue)
betweenSymmetric(Row2, Row2)
@Support BetweenAndStep2<T1,T2> notBetween(T1 minValue1, T2 minValue2)
between(Row2, Row2)
@Support BetweenAndStep2<T1,T2> notBetween(Field<T1> minValue1, Field<T2> minValue2)
notBetween(Row2, Row2)
@Support BetweenAndStep2<T1,T2> notBetween(Row2<T1,T2> minValue)
notBetween(Row2, Row2)
@Support BetweenAndStep2<T1,T2> notBetween(Record2<T1,T2> minValue)
notBetween(Row2, Row2)
@Support Condition notBetween(Row2<T1,T2> minValue, Row2<T1,T2> maxValue)
This is the same as calling notBetween(minValue).and(maxValue)
The expression A NOT BETWEEN B AND C
is equivalent to the
expression A < B OR A > C
for those SQL dialects that do
not properly support the BETWEEN
predicate for row value
expressions
@Support Condition notBetween(Record2<T1,T2> minValue, Record2<T1,T2> maxValue)
This is the same as calling notBetween(minValue).and(maxValue)
notBetween(Row2, Row2)
@Support BetweenAndStep2<T1,T2> notBetweenSymmetric(T1 minValue1, T2 minValue2)
notBetweenSymmetric(Row2, Row2)
@Support BetweenAndStep2<T1,T2> notBetweenSymmetric(Field<T1> minValue1, Field<T2> minValue2)
notBetweenSymmetric(Row2, Row2)
@Support BetweenAndStep2<T1,T2> notBetweenSymmetric(Row2<T1,T2> minValue)
notBetweenSymmetric(Row2, Row2)
@Support BetweenAndStep2<T1,T2> notBetweenSymmetric(Record2<T1,T2> minValue)
notBetweenSymmetric(Row2, Row2)
@Support Condition notBetweenSymmetric(Row2<T1,T2> minValue, Row2<T1,T2> maxValue)
This is the same as calling notBetweenSymmetric(minValue).and(maxValue)
The expression A NOT BETWEEN SYMMETRIC B AND C
is equivalent
to the expression (A < B OR A > C) AND (A < C OR A > B)
for
those SQL dialects that do not properly support the BETWEEN
predicate for row value expressions
@Support Condition notBetweenSymmetric(Record2<T1,T2> minValue, Record2<T1,T2> maxValue)
This is the same as calling notBetweenSymmetric(minValue).and(maxValue)
notBetweenSymmetric(Row2, Row2)
@Support Condition in(Collection<? extends Row2<T1,T2>> rows)
Row IN predicates can be simulated 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)
@Support Condition in(Row2<T1,T2>... rows)
in(Collection)
@Support Condition in(Record2<T1,T2>... record)
in(Collection)
@Support(value={DB2,HSQLDB,MYSQL,ORACLE,POSTGRES}) Condition in(Select<? extends Record2<T1,T2>> select)
in(Collection)
@Support Condition notIn(Collection<? extends Row2<T1,T2>> rows)
Row NOT IN predicates can be simulated in those databases that do not
support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4))
is equivalent to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4)))
, which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
@Support Condition notIn(Row2<T1,T2>... rows)
notIn(Collection)
@Support Condition notIn(Record2<T1,T2>... record)
notIn(Collection)
@Support(value={DB2,HSQLDB,MYSQL,ORACLE,POSTGRES}) Condition notIn(Select<? extends Record2<T1,T2>> select)
notIn(Collection)
@Support Condition overlaps(T1 t1, T2 t2)
The SQL standard specifies a temporal OVERLAPS
predicate,
which comes in two flavours:
(DATE, DATE) OVERLAPS (DATE, DATE)
(DATE, INTERVAL) OVERLAPS (DATE, INTERVAL)
jOOQ also supports arbitrary 2degree row value expression comparisons,
by simulating them as such
 This predicate
(A, B) OVERLAPS (C, D)
 can be simulated as such
(C <= B) AND (A <= D)
@Support Condition overlaps(Field<T1> t1, Field<T2> t2)
The SQL standard specifies a temporal OVERLAPS
predicate,
which comes in two flavours:
(DATE, DATE) OVERLAPS (DATE, DATE)
(DATE, INTERVAL) OVERLAPS (DATE, INTERVAL)
jOOQ also supports arbitrary 2degree row value expression comparisons,
by simulating them as such
 This predicate
(A, B) OVERLAPS (C, D)
 can be simulated as such
(C <= B) AND (A <= D)
@Support Condition overlaps(Row2<T1,T2> row)
The SQL standard specifies a temporal OVERLAPS
predicate,
which comes in two flavours:
(DATE, DATE) OVERLAPS (DATE, DATE)
(DATE, INTERVAL) OVERLAPS (DATE, INTERVAL)
jOOQ also supports arbitrary 2degree row value expression comparisons,
by simulating them as such
 This predicate
(A, B) OVERLAPS (C, D)
 can be simulated as such
(C <= B) AND (A <= D)
Copyright © 2013. All Rights Reserved.