@Generated(value="This class was generated using jOOQtools") public interface Row1<T1> extends Row
1
.
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.
Modifier and Type  Method and Description 

BetweenAndStep1<T1> 
between(Field<T1> minValue1)
Check if this row value expression is within a range of two other row
value expressions.

BetweenAndStep1<T1> 
between(Record1<T1> minValue)
Check if this row value expression is within a range of two records.

Condition 
between(Record1<T1> minValue,
Record1<T1> maxValue)
Check if this row value expression is within a range of two records.

BetweenAndStep1<T1> 
between(Row1<T1> minValue)
Check if this row value expression is within a range of two other row
value expressions.

Condition 
between(Row1<T1> minValue,
Row1<T1> maxValue)
Check if this row value expression is within a range of two other row
value expressions.

BetweenAndStep1<T1> 
between(T1 minValue1)
Check if this row value expression is within a range of two other row
value expressions.

BetweenAndStep1<T1> 
betweenSymmetric(Field<T1> minValue1)
Check if this row value expression is within a symmetric range of two
other row value expressions.

BetweenAndStep1<T1> 
betweenSymmetric(Record1<T1> minValue)
Check if this row value expression is within a symmetric range of two
records.

Condition 
betweenSymmetric(Record1<T1> minValue,
Record1<T1> maxValue)
Check if this row value expression is within a symmetric range of two
records.

BetweenAndStep1<T1> 
betweenSymmetric(Row1<T1> minValue)
Check if this row value expression is within a symmetric range of two
other row value expressions.

Condition 
betweenSymmetric(Row1<T1> minValue,
Row1<T1> maxValue)
Check if this row value expression is within a symmetric range of two
other row value expressions.

BetweenAndStep1<T1> 
betweenSymmetric(T1 minValue1)
Check if this row value expression is within a symmetric range of two
other row value expressions.

Condition 
compare(Comparator comparator,
Field<T1> t1)
Compare this row value expression with another row value expression
using a dynamic comparator.

Condition 
compare(Comparator comparator,
QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect
using a dynamic comparator.

Condition 
compare(Comparator comparator,
Record1<T1> record)
Compare this row value expression with a record
using a dynamic comparator.

Condition 
compare(Comparator comparator,
Row1<T1> row)
Compare this row value expression with another row value expression
using a dynamic comparator.

Condition 
compare(Comparator comparator,
Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect
using a dynamic comparator.

Condition 
compare(Comparator comparator,
T1 t1)
Compare this row value expression with another row value expression
using a dynamic comparator.

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

Condition 
eq(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.

Condition 
eq(Record1<T1> record)
Compare this row value expression with a record for equality.

Condition 
eq(Row1<T1> row)
Compare this row value expression with another row value expression for
equality.

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

Condition 
eq(T1 t1)
Compare this row value expression with another row value expression for
equality.

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

Condition 
equal(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.

Condition 
equal(Record1<T1> record)
Compare this row value expression with a record for equality.

Condition 
equal(Row1<T1> row)
Compare this row value expression with another row value expression for
equality.

Condition 
equal(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.

Condition 
equal(T1 t1)
Compare this row value expression with another row value expression for
equality.

Field<T1> 
field1()
Get the first field.

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

Condition 
ge(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

Condition 
ge(Record1<T1> record)
Compare this row value expression with a record for order.

Condition 
ge(Row1<T1> row)
Compare this row value expression with another row value expression for
order.

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

Condition 
ge(T1 t1)
Compare this row value expression with another row value expression for
order.

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

Condition 
greaterOrEqual(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

Condition 
greaterOrEqual(Record1<T1> record)
Compare this row value expression with a record for order.

Condition 
greaterOrEqual(Row1<T1> row)
Compare this row value expression with another row value expression for
order.

Condition 
greaterOrEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

Condition 
greaterOrEqual(T1 t1)
Compare this row value expression with another row value expression for
order.

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

Condition 
greaterThan(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

Condition 
greaterThan(Record1<T1> record)
Compare this row value expression with a record for order.

Condition 
greaterThan(Row1<T1> row)
Compare this row value expression with another row value expression for
order.

Condition 
greaterThan(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

Condition 
greaterThan(T1 t1)
Compare this row value expression with another row value expression for
order.

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

Condition 
gt(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

Condition 
gt(Record1<T1> record)
Compare this row value expression with a record for order.

Condition 
gt(Row1<T1> row)
Compare this row value expression with another row value expression for
order.

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

Condition 
gt(T1 t1)
Compare this row value expression with another row value expression for
order.

Condition 
in(Collection<? extends Row1<T1>> rows)
Compare this row value expression with a set of row value expressions for
equality.

Condition 
in(Record1<T1>... record)
Compare this row value expression with a set of records for equality.

Condition 
in(Result<? extends Record1<T1>> result)
Compare this row value expression with a set of records for
equality.

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

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

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

Condition 
le(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

Condition 
le(Record1<T1> record)
Compare this row value expression with a record for order.

Condition 
le(Row1<T1> row)
Compare this row value expression with another row value expression for
order.

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

Condition 
le(T1 t1)
Compare this row value expression with another row value expression for
order.

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

Condition 
lessOrEqual(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

Condition 
lessOrEqual(Record1<T1> record)
Compare this row value expression with a record for order.

Condition 
lessOrEqual(Row1<T1> row)
Compare this row value expression with another row value expression for
order.

Condition 
lessOrEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

Condition 
lessOrEqual(T1 t1)
Compare this row value expression with another row value expression for
order.

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

Condition 
lessThan(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

Condition 
lessThan(Record1<T1> record)
Compare this row value expression with a record for order.

Condition 
lessThan(Row1<T1> row)
Compare this row value expression with another row value expression for
order.

Condition 
lessThan(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

Condition 
lessThan(T1 t1)
Compare this row value expression with another row value expression for
order.

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

Condition 
lt(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

Condition 
lt(Record1<T1> record)
Compare this row value expression with a record for order.

Condition 
lt(Row1<T1> row)
Compare this row value expression with another row value expression for
order.

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

Condition 
lt(T1 t1)
Compare this row value expression with another row value expression for
order.

Condition 
ne(Field<T1> t1)
Compare this row value expression with another row value expression for
nonequality.

Condition 
ne(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for nonequality.

Condition 
ne(Record1<T1> record)
Compare this row value expression with a record for nonequality.

Condition 
ne(Row1<T1> row)
Compare this row value expression with another row value expression for
nonequality.

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

Condition 
ne(T1 t1)
Compare this row value expression with another row value expression for
nonequality.

BetweenAndStep1<T1> 
notBetween(Field<T1> minValue1)
Check if this row value expression is not within a range of two other
row value expressions.

BetweenAndStep1<T1> 
notBetween(Record1<T1> minValue)
Check if this row value expression is within a range of two records.

Condition 
notBetween(Record1<T1> minValue,
Record1<T1> maxValue)
Check if this row value expression is within a range of two records.

BetweenAndStep1<T1> 
notBetween(Row1<T1> minValue)
Check if this row value expression is not within a range of two other
row value expressions.

Condition 
notBetween(Row1<T1> minValue,
Row1<T1> maxValue)
Check if this row value expression is not within a range of two other
row value expressions.

BetweenAndStep1<T1> 
notBetween(T1 minValue1)
Check if this row value expression is not within a range of two other
row value expressions.

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

BetweenAndStep1<T1> 
notBetweenSymmetric(Record1<T1> minValue)
Check if this row value expression is not within a symmetric range of two
records.

Condition 
notBetweenSymmetric(Record1<T1> minValue,
Record1<T1> maxValue)
Check if this row value expression is not within a symmetric range of two
records.

BetweenAndStep1<T1> 
notBetweenSymmetric(Row1<T1> minValue)
Check if this row value expression is not within a symmetric range of two
other row value expressions.

Condition 
notBetweenSymmetric(Row1<T1> minValue,
Row1<T1> maxValue)
Check if this row value expression is not within a symmetric range of two
other row value expressions.

BetweenAndStep1<T1> 
notBetweenSymmetric(T1 minValue1)
Check if this row value expression is not within a symmetric range of two
other row value expressions.

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

Condition 
notEqual(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for nonequality.

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

Condition 
notEqual(Row1<T1> row)
Compare this row value expression with another row value expression for
nonequality.

Condition 
notEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for nonequality.

Condition 
notEqual(T1 t1)
Compare this row value expression with another row value expression for.

Condition 
notIn(Collection<? extends Row1<T1>> rows)
Compare this row value expression with a set of row value expressions for
equality.

Condition 
notIn(Record1<T1>... record)
Compare this row value expression with a set of records for nonequality.

Condition 
notIn(Result<? extends Record1<T1>> result)
Compare this row value expression with a set of records for
equality.

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

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

@Support Condition compare(Comparator comparator, Row1<T1> row)
See the explicit comparison methods for details. Note, not all
Comparator
types are supported
@Support Condition compare(Comparator comparator, Record1<T1> record)
See the explicit comparison methods for details. Note, not all
Comparator
types are supported
@Support Condition compare(Comparator comparator, T1 t1)
See the explicit comparison methods for details. Note, not all
Comparator
types are supported
@Support Condition compare(Comparator comparator, Field<T1> t1)
See the explicit comparison methods for details. Note, not all
Comparator
types are supported
@Support Condition compare(Comparator comparator, Select<? extends Record1<T1>> select)
See the explicit comparison methods for details. Note, not all
Comparator
types are supported
@Support Condition compare(Comparator comparator, QuantifiedSelect<? extends Record1<T1>> select)
See the explicit comparison methods for details. Note, not all
Comparator
types are supported
@Support Condition equal(Row1<T1> row)
Row equality comparison predicates can be emulated 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(Record1<T1> record)
equal(Row1)
@Support Condition equal(T1 t1)
equal(Row1)
@Support Condition equal(Field<T1> t1)
equal(Row1)
@Support Condition equal(Select<? extends Record1<T1>> select)
equal(Row1)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA}) Condition equal(QuantifiedSelect<? extends Record1<T1>> select)
@Support Condition eq(Row1<T1> row)
equal(Row1)
@Support Condition eq(Record1<T1> record)
equal(Row1)
@Support Condition eq(T1 t1)
equal(Row1)
@Support Condition eq(Field<T1> t1)
equal(Row1)
@Support Condition eq(Select<? extends Record1<T1>> select)
equal(Row1)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA}) Condition eq(QuantifiedSelect<? extends Record1<T1>> select)
@Support Condition notEqual(Row1<T1> row)
Row nonequality comparison predicates can be emulated 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(Record1<T1> record)
notEqual(Row1)
@Support Condition notEqual(T1 t1)
notEqual(Row1)
@Support Condition notEqual(Field<T1> t1)
notEqual(Row1)
@Support Condition notEqual(Select<? extends Record1<T1>> select)
notEqual(Row1)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA}) Condition notEqual(QuantifiedSelect<? extends Record1<T1>> select)
@Support Condition ne(Row1<T1> row)
notEqual(Row1)
@Support Condition ne(Record1<T1> record)
notEqual(Row1)
@Support Condition ne(T1 t1)
notEqual(Row1)
@Support Condition ne(Field<T1> t1)
notEqual(Row1)
@Support Condition ne(Select<? extends Record1<T1>> select)
notEqual(Row1)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA}) Condition ne(QuantifiedSelect<? extends Record1<T1>> select)
@Support Condition lessThan(Row1<T1> row)
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 to
A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3)
@Support Condition lessThan(Record1<T1> record)
lessThan(Row1)
@Support Condition lessThan(T1 t1)
lessThan(Row1)
@Support Condition lessThan(Field<T1> t1)
lessThan(Row1)
@Support Condition lessThan(Select<? extends Record1<T1>> select)
lessThan(Row1)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessThan(QuantifiedSelect<? extends Record1<T1>> select)
@Support Condition lt(Row1<T1> row)
lessThan(Row1)
@Support Condition lt(Record1<T1> record)
lessThan(Row1)
@Support Condition lt(T1 t1)
lessThan(Row1)
@Support Condition lt(Field<T1> t1)
lessThan(Row1)
@Support Condition lt(Select<? extends Record1<T1>> select)
lessThan(Row1)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lt(QuantifiedSelect<? extends Record1<T1>> select)
@Support Condition lessOrEqual(Row1<T1> row)
Row order comparison predicates can be emulated 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(Record1<T1> record)
lessOrEqual(Row1)
@Support Condition lessOrEqual(T1 t1)
lessOrEqual(Row1)
@Support Condition lessOrEqual(Field<T1> t1)
lessOrEqual(Row1)
@Support Condition lessOrEqual(Select<? extends Record1<T1>> select)
lessOrEqual(Row1)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessOrEqual(QuantifiedSelect<? extends Record1<T1>> select)
@Support Condition le(Row1<T1> row)
lessOrEqual(Row1)
@Support Condition le(Record1<T1> record)
lessOrEqual(Row1)
@Support Condition le(T1 t1)
lessOrEqual(Row1)
@Support Condition le(Field<T1> t1)
lessOrEqual(Row1)
@Support Condition le(Select<? extends Record1<T1>> select)
lessOrEqual(Row1)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition le(QuantifiedSelect<? extends Record1<T1>> select)
@Support Condition greaterThan(Row1<T1> row)
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 to
A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3)
@Support Condition greaterThan(Record1<T1> record)
greaterThan(Row1)
@Support Condition greaterThan(T1 t1)
greaterThan(Row1)
@Support Condition greaterThan(Field<T1> t1)
greaterThan(Row1)
@Support Condition greaterThan(Select<? extends Record1<T1>> select)
greaterThan(Row1)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterThan(QuantifiedSelect<? extends Record1<T1>> select)
@Support Condition gt(Row1<T1> row)
greaterThan(Row1)
@Support Condition gt(Record1<T1> record)
greaterThan(Row1)
@Support Condition gt(T1 t1)
greaterThan(Row1)
@Support Condition gt(Field<T1> t1)
greaterThan(Row1)
@Support Condition gt(Select<? extends Record1<T1>> select)
greaterThan(Row1)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition gt(QuantifiedSelect<? extends Record1<T1>> select)
@Support Condition greaterOrEqual(Row1<T1> row)
Row order comparison predicates can be emulated 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(Record1<T1> record)
greaterOrEqual(Row1)
@Support Condition greaterOrEqual(T1 t1)
greaterOrEqual(Row1)
@Support Condition greaterOrEqual(Field<T1> t1)
greaterOrEqual(Row1)
@Support Condition greaterOrEqual(Select<? extends Record1<T1>> select)
greaterOrEqual(Row1)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterOrEqual(QuantifiedSelect<? extends Record1<T1>> select)
@Support Condition ge(Row1<T1> row)
greaterOrEqual(Row1)
@Support Condition ge(Record1<T1> record)
greaterOrEqual(Row1)
@Support Condition ge(T1 t1)
greaterOrEqual(Row1)
@Support Condition ge(Field<T1> t1)
greaterOrEqual(Row1)
@Support Condition ge(Select<? extends Record1<T1>> select)
greaterOrEqual(Row1)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition ge(QuantifiedSelect<? extends Record1<T1>> select)
@Support BetweenAndStep1<T1> between(T1 minValue1)
between(Row1, Row1)
@Support BetweenAndStep1<T1> between(Field<T1> minValue1)
between(Row1, Row1)
@Support BetweenAndStep1<T1> between(Row1<T1> minValue)
between(Row1, Row1)
@Support BetweenAndStep1<T1> between(Record1<T1> minValue)
between(Row1, Row1)
@Support Condition between(Row1<T1> minValue, Row1<T1> 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(Record1<T1> minValue, Record1<T1> maxValue)
This is the same as calling between(minValue).and(maxValue)
between(Row1, Row1)
@Support BetweenAndStep1<T1> betweenSymmetric(T1 minValue1)
betweenSymmetric(Row1, Row1)
@Support BetweenAndStep1<T1> betweenSymmetric(Field<T1> minValue1)
betweenSymmetric(Row1, Row1)
@Support BetweenAndStep1<T1> betweenSymmetric(Row1<T1> minValue)
betweenSymmetric(Row1, Row1)
@Support BetweenAndStep1<T1> betweenSymmetric(Record1<T1> minValue)
betweenSymmetric(Row1, Row1)
@Support Condition betweenSymmetric(Row1<T1> minValue, Row1<T1> 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(Record1<T1> minValue, Record1<T1> maxValue)
This is the same as calling betweenSymmetric(minValue).and(maxValue)
betweenSymmetric(Row1, Row1)
@Support BetweenAndStep1<T1> notBetween(T1 minValue1)
between(Row1, Row1)
@Support BetweenAndStep1<T1> notBetween(Field<T1> minValue1)
notBetween(Row1, Row1)
@Support BetweenAndStep1<T1> notBetween(Row1<T1> minValue)
notBetween(Row1, Row1)
@Support BetweenAndStep1<T1> notBetween(Record1<T1> minValue)
notBetween(Row1, Row1)
@Support Condition notBetween(Row1<T1> minValue, Row1<T1> 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(Record1<T1> minValue, Record1<T1> maxValue)
This is the same as calling notBetween(minValue).and(maxValue)
notBetween(Row1, Row1)
@Support BetweenAndStep1<T1> notBetweenSymmetric(T1 minValue1)
notBetweenSymmetric(Row1, Row1)
@Support BetweenAndStep1<T1> notBetweenSymmetric(Field<T1> minValue1)
notBetweenSymmetric(Row1, Row1)
@Support BetweenAndStep1<T1> notBetweenSymmetric(Row1<T1> minValue)
notBetweenSymmetric(Row1, Row1)
@Support BetweenAndStep1<T1> notBetweenSymmetric(Record1<T1> minValue)
notBetweenSymmetric(Row1, Row1)
@Support Condition notBetweenSymmetric(Row1<T1> minValue, Row1<T1> 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(Record1<T1> minValue, Record1<T1> maxValue)
This is the same as calling notBetweenSymmetric(minValue).and(maxValue)
notBetweenSymmetric(Row1, Row1)
@Support Condition in(Collection<? extends Row1<T1>> rows)
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 arbitrarylength
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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
IN
predicates on temporary tablesIN
predicates on unnested array bind variables@Support Condition in(Result<? extends Record1<T1>> result)
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 arbitrarylength
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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
IN
predicates on temporary tablesIN
predicates on unnested array bind variables@Support Condition in(Row1<T1>... rows)
Note that generating dynamic SQL with arbitrarylength
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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
IN
predicates on temporary tablesIN
predicates on unnested array bind variablesin(Collection)
@Support Condition in(Record1<T1>... record)
Note that generating dynamic SQL with arbitrarylength
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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
IN
predicates on temporary tablesIN
predicates on unnested array bind variablesin(Collection)
@Support Condition in(Select<? extends Record1<T1>> select)
in(Collection)
@Support Condition notIn(Collection<? extends Row1<T1>> rows)
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 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))
Note that generating dynamic SQL with arbitrarylength
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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables@Support Condition notIn(Result<? extends Record1<T1>> result)
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 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))
Note that generating dynamic SQL with arbitrarylength
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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables@Support Condition notIn(Row1<T1>... rows)
Note that generating dynamic SQL with arbitrarylength
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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variablesnotIn(Collection)
@Support Condition notIn(Record1<T1>... record)
Note that generating dynamic SQL with arbitrarylength
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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variablesnotIn(Collection)
Copyright © 2017. All Rights Reserved.