| Package | Description |
|---|---|
| org.jooq |
The
org.jooq package contains jOOQ's public API
This package mostly contains interfaces that are implemented by the
org.jooq.impl package. |
| org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes
This package provides implementations for the jOOQ API from
org.jooq, whose interfaces are constructed mostly through the
Factory class, which hides implementation facts from
the public API |
| Modifier and Type | Method and Description |
|---|---|
Condition |
Row2.eq(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 |
Row2.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 |
Row2.in(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 |
Row2.ne(Row2<T1,T2> 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 |
Row2.notEqual(Row2<T1,T2> 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 |
Row2.notIn(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 |
Row2.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 2-degree 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)
|
| Modifier and Type | Method and Description |
|---|---|
Condition |
Row2.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 |
Row2.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)) |
| Modifier and Type | Method and Description |
|---|---|
static <T1,T2> Row2<T1,T2> |
Factory.row(Field<T1> t1,
Field<T2> t2)
Create a row value expression of degree
2
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases. |
static <T1,T2> Row2<T1,T2> |
Factory.row(T1 t1,
T2 t2)
Create a row value expression of degree
2
Note: Not all databases support row value expressions, but many row value
expression operations can be simulated on all databases. |
Copyright © 2013. All Rights Reserved.