Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes. |
Modifier and Type | Method and Description |
---|---|
Condition |
BetweenAndStepN.and(RowN maxValue)
Create a condition to check this field against some bounds
|
BetweenAndStepN |
RowN.between(RowN minValue)
Check if this row value expression is within a range of two other row
value expressions
|
Condition |
RowN.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
expression A >= B AND A <= C for those SQL dialects that do
not properly support the BETWEEN predicate for row value
expressions |
BetweenAndStepN |
RowN.betweenSymmetric(RowN minValue)
Check if this row value expression is within a symmetric range of two
other row value expressions
|
Condition |
RowN.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 the
BETWEEN predicate for row value expressions |
Condition |
RowN.eq(RowN row)
Compare this row value expression with another row value expression for
equality
|
Condition |
RowN.equal(RowN 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 |
RowN.ge(RowN row)
Compare this row value expression with another row value expression for
order
|
Condition |
RowN.greaterOrEqual(RowN 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 |
RowN.greaterThan(RowN 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 |
RowN.gt(RowN row)
Compare this row value expression with another row value expression for
order
|
Condition |
RowN.in(RowN... rows)
Compare this row value expression with a set of row value expressions for
equality
|
Condition |
RowN.le(RowN row)
Compare this row value expression with another row value expression for
order
|
Condition |
RowN.lessOrEqual(RowN 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 |
RowN.lessThan(RowN 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 |
RowN.lt(RowN row)
Compare this row value expression with another row value expression for
order
|
Condition |
RowN.ne(RowN row)
Compare this row value expression with another row value expression for
non-equality
|
BetweenAndStepN |
RowN.notBetween(RowN minValue)
Check if this row value expression is not within a range of two other
row value expressions
|
Condition |
RowN.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
expression A < B OR A > C for those SQL dialects that do
not properly support the BETWEEN predicate for row value
expressions |
BetweenAndStepN |
RowN.notBetweenSymmetric(RowN minValue)
Check if this row value expression is not within a symmetric range of two
other row value expressions
|
Condition |
RowN.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 the BETWEEN
predicate for row value expressions |
Condition |
RowN.notEqual(RowN row)
Compare this row value expression with another row value expression for
non-equality
Row non-equality 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 |
RowN.notIn(RowN... rows)
Compare this row value expression with a set of row value expressions for
equality
|
Modifier and Type | Method and Description |
---|---|
Condition |
RowN.in(Collection<? extends RowN> 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 |
RowN.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 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)) |
Modifier and Type | Method and Description |
---|---|
static RowN |
DSL.row(Field<?>... values)
Create a row value expression of degree
N > 22 . |
static RowN |
DSL.row(Object... values)
Create a row value expression of degree
N > 22 . |
Copyright © 2013. All Rights Reserved.