| Package | Description | 
|---|---|
| org.jooq | The  org.jooqpackage contains jOOQ's public API. | 
| org.jooq.impl | The  org.jooq.implpackage 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 expressionA BETWEEN B AND Cis equivalent to the
 expressionA >= B AND A <= Cfor those SQL dialects that do
 not properly support theBETWEENpredicate 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 expressionA BETWEEN SYMMETRIC B AND Cis equivalent to
 the expression(A >= B AND A <= C) OR (A >= C AND A <= B)for those SQL dialects that do not properly support theBETWEENpredicate 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 toA = 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 toA > 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 toA > 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 toA < 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 toA < 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 expressionA NOT BETWEEN B AND Cis equivalent to the
 expressionA < B OR A > Cfor those SQL dialects that do
 not properly support theBETWEENpredicate 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 expressionA NOT BETWEEN SYMMETRIC B AND Cis equivalent
 to the expression(A < B OR A > C) AND (A < C OR A > B)for
 those SQL dialects that do not properly support theBETWEENpredicate 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 toNOT(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 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)) | 
| 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.