@Generated(value="This class was generated using jOOQ-tools") public interface Row3<T1,T2,T3> extends Row
3.
 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 | 
|---|---|
BetweenAndStep3<T1,T2,T3> | 
between(Field<T1> minValue1,
       Field<T2> minValue2,
       Field<T3> minValue3)
Check if this row value expression is within a range of two other row
 value expressions. 
 | 
BetweenAndStep3<T1,T2,T3> | 
between(Record3<T1,T2,T3> minValue)
Check if this row value expression is within a range of two records. 
 | 
Condition | 
between(Record3<T1,T2,T3> minValue,
       Record3<T1,T2,T3> maxValue)
Check if this row value expression is within a range of two records. 
 | 
BetweenAndStep3<T1,T2,T3> | 
between(Row3<T1,T2,T3> minValue)
Check if this row value expression is within a range of two other row
 value expressions. 
 | 
Condition | 
between(Row3<T1,T2,T3> minValue,
       Row3<T1,T2,T3> maxValue)
Check if this row value expression is within a range of two other row
 value expressions. 
 | 
BetweenAndStep3<T1,T2,T3> | 
between(T1 minValue1,
       T2 minValue2,
       T3 minValue3)
Check if this row value expression is within a range of two other row
 value expressions. 
 | 
BetweenAndStep3<T1,T2,T3> | 
betweenSymmetric(Field<T1> minValue1,
                Field<T2> minValue2,
                Field<T3> minValue3)
Check if this row value expression is within a symmetric range of two
 other row value expressions. 
 | 
BetweenAndStep3<T1,T2,T3> | 
betweenSymmetric(Record3<T1,T2,T3> minValue)
Check if this row value expression is within a symmetric range of two
 records. 
 | 
Condition | 
betweenSymmetric(Record3<T1,T2,T3> minValue,
                Record3<T1,T2,T3> maxValue)
Check if this row value expression is within a symmetric range of two
 records. 
 | 
BetweenAndStep3<T1,T2,T3> | 
betweenSymmetric(Row3<T1,T2,T3> minValue)
Check if this row value expression is within a symmetric range of two
 other row value expressions. 
 | 
Condition | 
betweenSymmetric(Row3<T1,T2,T3> minValue,
                Row3<T1,T2,T3> maxValue)
Check if this row value expression is within a symmetric range of two
 other row value expressions. 
 | 
BetweenAndStep3<T1,T2,T3> | 
betweenSymmetric(T1 minValue1,
                T2 minValue2,
                T3 minValue3)
Check if this row value expression is within a symmetric range of two
 other row value expressions. 
 | 
Condition | 
compare(Comparator comparator,
       Field<T1> t1,
       Field<T2> t2,
       Field<T3> t3)
Compare this row value expression with another row value expression
 using a dynamic comparator. 
 | 
Condition | 
compare(Comparator comparator,
       QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect
 using a dynamic comparator. 
 | 
Condition | 
compare(Comparator comparator,
       Record3<T1,T2,T3> record)
Compare this row value expression with a record
 using a dynamic comparator. 
 | 
Condition | 
compare(Comparator comparator,
       Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression
 using a dynamic comparator. 
 | 
Condition | 
compare(Comparator comparator,
       Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect
 using a dynamic comparator. 
 | 
Condition | 
compare(Comparator comparator,
       T1 t1,
       T2 t2,
       T3 t3)
Compare this row value expression with another row value expression
 using a dynamic comparator. 
 | 
Condition | 
eq(Field<T1> t1,
  Field<T2> t2,
  Field<T3> t3)
Compare this row value expression with another row value expression for
 equality. 
 | 
Condition | 
eq(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for equality. 
 | 
Condition | 
eq(Record3<T1,T2,T3> record)
Compare this row value expression with a record for equality. 
 | 
Condition | 
eq(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 equality. 
 | 
Condition | 
eq(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for equality. 
 | 
Condition | 
eq(T1 t1,
  T2 t2,
  T3 t3)
Compare this row value expression with another row value expression for
 equality. 
 | 
Condition | 
equal(Field<T1> t1,
     Field<T2> t2,
     Field<T3> t3)
Compare this row value expression with another row value expression for
 equality. 
 | 
Condition | 
equal(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for equality. 
 | 
Condition | 
equal(Record3<T1,T2,T3> record)
Compare this row value expression with a record for equality. 
 | 
Condition | 
equal(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 equality. 
 | 
Condition | 
equal(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for equality. 
 | 
Condition | 
equal(T1 t1,
     T2 t2,
     T3 t3)
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. 
 | 
Field<T3> | 
field3()
Get the third field. 
 | 
Condition | 
ge(Field<T1> t1,
  Field<T2> t2,
  Field<T3> t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
ge(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
ge(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
ge(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
ge(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
ge(T1 t1,
  T2 t2,
  T3 t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
greaterOrEqual(Field<T1> t1,
              Field<T2> t2,
              Field<T3> t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
greaterOrEqual(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
greaterOrEqual(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
greaterOrEqual(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
greaterOrEqual(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
greaterOrEqual(T1 t1,
              T2 t2,
              T3 t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
greaterThan(Field<T1> t1,
           Field<T2> t2,
           Field<T3> t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
greaterThan(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
greaterThan(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
greaterThan(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
greaterThan(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
greaterThan(T1 t1,
           T2 t2,
           T3 t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
gt(Field<T1> t1,
  Field<T2> t2,
  Field<T3> t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
gt(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
gt(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
gt(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
gt(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
gt(T1 t1,
  T2 t2,
  T3 t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
in(Collection<? extends Row3<T1,T2,T3>> rows)
Compare this row value expression with a set of row value expressions for
 equality. 
 | 
Condition | 
in(Record3<T1,T2,T3>... record)
Compare this row value expression with a set of records for equality. 
 | 
Condition | 
in(Result<? extends Record3<T1,T2,T3>> result)
Compare this row value expression with a set of records for
 equality. 
 | 
Condition | 
in(Row3<T1,T2,T3>... rows)
Compare this row value expression with a set of row value expressions for
 equality. 
 | 
Condition | 
in(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for equality. 
 | 
Condition | 
le(Field<T1> t1,
  Field<T2> t2,
  Field<T3> t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
le(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
le(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
le(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
le(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
le(T1 t1,
  T2 t2,
  T3 t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
lessOrEqual(Field<T1> t1,
           Field<T2> t2,
           Field<T3> t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
lessOrEqual(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
lessOrEqual(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
lessOrEqual(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
lessOrEqual(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
lessOrEqual(T1 t1,
           T2 t2,
           T3 t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
lessThan(Field<T1> t1,
        Field<T2> t2,
        Field<T3> t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
lessThan(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
lessThan(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
lessThan(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
lessThan(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
lessThan(T1 t1,
        T2 t2,
        T3 t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
lt(Field<T1> t1,
  Field<T2> t2,
  Field<T3> t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
lt(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
lt(Record3<T1,T2,T3> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
lt(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
lt(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
lt(T1 t1,
  T2 t2,
  T3 t3)
Compare this row value expression with another row value expression for
 order. 
 | 
Condition | 
ne(Field<T1> t1,
  Field<T2> t2,
  Field<T3> t3)
Compare this row value expression with another row value expression for
 non-equality. 
 | 
Condition | 
ne(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for non-equality. 
 | 
Condition | 
ne(Record3<T1,T2,T3> record)
Compare this row value expression with a record for non-equality. 
 | 
Condition | 
ne(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 non-equality. 
 | 
Condition | 
ne(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for non-equality. 
 | 
Condition | 
ne(T1 t1,
  T2 t2,
  T3 t3)
Compare this row value expression with another row value expression for
 non-equality. 
 | 
BetweenAndStep3<T1,T2,T3> | 
notBetween(Field<T1> minValue1,
          Field<T2> minValue2,
          Field<T3> minValue3)
Check if this row value expression is not within a range of two other
 row value expressions. 
 | 
BetweenAndStep3<T1,T2,T3> | 
notBetween(Record3<T1,T2,T3> minValue)
Check if this row value expression is within a range of two records. 
 | 
Condition | 
notBetween(Record3<T1,T2,T3> minValue,
          Record3<T1,T2,T3> maxValue)
Check if this row value expression is within a range of two records. 
 | 
BetweenAndStep3<T1,T2,T3> | 
notBetween(Row3<T1,T2,T3> minValue)
Check if this row value expression is not within a range of two other
 row value expressions. 
 | 
Condition | 
notBetween(Row3<T1,T2,T3> minValue,
          Row3<T1,T2,T3> maxValue)
Check if this row value expression is not within a range of two other
 row value expressions. 
 | 
BetweenAndStep3<T1,T2,T3> | 
notBetween(T1 minValue1,
          T2 minValue2,
          T3 minValue3)
Check if this row value expression is not within a range of two other
 row value expressions. 
 | 
BetweenAndStep3<T1,T2,T3> | 
notBetweenSymmetric(Field<T1> minValue1,
                   Field<T2> minValue2,
                   Field<T3> minValue3)
Check if this row value expression is not within a symmetric range of two
 other row value expressions. 
 | 
BetweenAndStep3<T1,T2,T3> | 
notBetweenSymmetric(Record3<T1,T2,T3> minValue)
Check if this row value expression is not within a symmetric range of two
 records. 
 | 
Condition | 
notBetweenSymmetric(Record3<T1,T2,T3> minValue,
                   Record3<T1,T2,T3> maxValue)
Check if this row value expression is not within a symmetric range of two
 records. 
 | 
BetweenAndStep3<T1,T2,T3> | 
notBetweenSymmetric(Row3<T1,T2,T3> minValue)
Check if this row value expression is not within a symmetric range of two
 other row value expressions. 
 | 
Condition | 
notBetweenSymmetric(Row3<T1,T2,T3> minValue,
                   Row3<T1,T2,T3> maxValue)
Check if this row value expression is not within a symmetric range of two
 other row value expressions. 
 | 
BetweenAndStep3<T1,T2,T3> | 
notBetweenSymmetric(T1 minValue1,
                   T2 minValue2,
                   T3 minValue3)
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,
        Field<T3> t3)
Compare this row value expression with another row value expression for
 non-equality. 
 | 
Condition | 
notEqual(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for non-equality. 
 | 
Condition | 
notEqual(Record3<T1,T2,T3> record)
Compare this row value expression with a record for non-equality 
 | 
Condition | 
notEqual(Row3<T1,T2,T3> row)
Compare this row value expression with another row value expression for
 non-equality. 
 | 
Condition | 
notEqual(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for non-equality. 
 | 
Condition | 
notEqual(T1 t1,
        T2 t2,
        T3 t3)
Compare this row value expression with another row value expression for. 
 | 
Condition | 
notIn(Collection<? extends Row3<T1,T2,T3>> rows)
Compare this row value expression with a set of row value expressions for
 equality. 
 | 
Condition | 
notIn(Record3<T1,T2,T3>... record)
Compare this row value expression with a set of records for non-equality. 
 | 
Condition | 
notIn(Result<? extends Record3<T1,T2,T3>> result)
Compare this row value expression with a set of records for
 equality. 
 | 
Condition | 
notIn(Row3<T1,T2,T3>... rows)
Compare this row value expression with a set of row value expressions for
 equality. 
 | 
Condition | 
notIn(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for non-equality. 
 | 
@Support Condition compare(Comparator comparator, Row3<T1,T2,T3> row)
 See the explicit comparison methods for details. Note, not all
 Comparator types are supported
@Support Condition compare(Comparator comparator, Record3<T1,T2,T3> record)
 See the explicit comparison methods for details. Note, not all
 Comparator types are supported
@Support Condition compare(Comparator comparator, T1 t1, T2 t2, T3 t3)
 See the explicit comparison methods for details. Note, not all
 Comparator types are supported
@Support Condition compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3)
 See the explicit comparison methods for details. Note, not all
 Comparator types are supported
@Support Condition compare(Comparator comparator, Select<? extends Record3<T1,T2,T3>> select)
 See the explicit comparison methods for details. Note, not all
 Comparator types are supported
@Support Condition compare(Comparator comparator, QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
 See the explicit comparison methods for details. Note, not all
 Comparator types are supported
@Support Condition equal(Row3<T1,T2,T3> 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(Record3<T1,T2,T3> record)
equal(Row3)@Support Condition equal(T1 t1, T2 t2, T3 t3)
equal(Row3)@Support Condition equal(Field<T1> t1, Field<T2> t2, Field<T3> t3)
equal(Row3)@Support Condition equal(Select<? extends Record3<T1,T2,T3>> select)
equal(Row3)@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition equal(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
@Support Condition eq(Row3<T1,T2,T3> row)
equal(Row3)@Support Condition eq(Record3<T1,T2,T3> record)
equal(Row3)@Support Condition eq(T1 t1, T2 t2, T3 t3)
equal(Row3)@Support Condition eq(Field<T1> t1, Field<T2> t2, Field<T3> t3)
equal(Row3)@Support Condition eq(Select<? extends Record3<T1,T2,T3>> select)
equal(Row3)@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition eq(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
@Support Condition notEqual(Row3<T1,T2,T3> row)
 Row non-equality 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(Record3<T1,T2,T3> record)
notEqual(Row3)@Support Condition notEqual(T1 t1, T2 t2, T3 t3)
notEqual(Row3)@Support Condition notEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3)
notEqual(Row3)@Support Condition notEqual(Select<? extends Record3<T1,T2,T3>> select)
notEqual(Row3)@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition notEqual(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
@Support Condition ne(Row3<T1,T2,T3> row)
notEqual(Row3)@Support Condition ne(Record3<T1,T2,T3> record)
notEqual(Row3)@Support Condition ne(T1 t1, T2 t2, T3 t3)
notEqual(Row3)@Support Condition ne(Field<T1> t1, Field<T2> t2, Field<T3> t3)
notEqual(Row3)@Support Condition ne(Select<? extends Record3<T1,T2,T3>> select)
notEqual(Row3)@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition ne(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
@Support Condition lessThan(Row3<T1,T2,T3> 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(Record3<T1,T2,T3> record)
lessThan(Row3)@Support Condition lessThan(T1 t1, T2 t2, T3 t3)
lessThan(Row3)@Support Condition lessThan(Field<T1> t1, Field<T2> t2, Field<T3> t3)
lessThan(Row3)@Support Condition lessThan(Select<? extends Record3<T1,T2,T3>> select)
lessThan(Row3)@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessThan(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
@Support Condition lt(Row3<T1,T2,T3> row)
lessThan(Row3)@Support Condition lt(Record3<T1,T2,T3> record)
lessThan(Row3)@Support Condition lt(T1 t1, T2 t2, T3 t3)
lessThan(Row3)@Support Condition lt(Field<T1> t1, Field<T2> t2, Field<T3> t3)
lessThan(Row3)@Support Condition lt(Select<? extends Record3<T1,T2,T3>> select)
lessThan(Row3)@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lt(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
@Support Condition lessOrEqual(Row3<T1,T2,T3> 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(Record3<T1,T2,T3> record)
lessOrEqual(Row3)@Support Condition lessOrEqual(T1 t1, T2 t2, T3 t3)
lessOrEqual(Row3)@Support Condition lessOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3)
lessOrEqual(Row3)@Support Condition lessOrEqual(Select<? extends Record3<T1,T2,T3>> select)
lessOrEqual(Row3)@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessOrEqual(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
@Support Condition le(Row3<T1,T2,T3> row)
lessOrEqual(Row3)@Support Condition le(Record3<T1,T2,T3> record)
lessOrEqual(Row3)@Support Condition le(T1 t1, T2 t2, T3 t3)
lessOrEqual(Row3)@Support Condition le(Field<T1> t1, Field<T2> t2, Field<T3> t3)
lessOrEqual(Row3)@Support Condition le(Select<? extends Record3<T1,T2,T3>> select)
lessOrEqual(Row3)@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition le(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
@Support Condition greaterThan(Row3<T1,T2,T3> 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(Record3<T1,T2,T3> record)
greaterThan(Row3)@Support Condition greaterThan(T1 t1, T2 t2, T3 t3)
greaterThan(Row3)@Support Condition greaterThan(Field<T1> t1, Field<T2> t2, Field<T3> t3)
greaterThan(Row3)@Support Condition greaterThan(Select<? extends Record3<T1,T2,T3>> select)
greaterThan(Row3)@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterThan(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
@Support Condition gt(Row3<T1,T2,T3> row)
greaterThan(Row3)@Support Condition gt(Record3<T1,T2,T3> record)
greaterThan(Row3)@Support Condition gt(T1 t1, T2 t2, T3 t3)
greaterThan(Row3)@Support Condition gt(Field<T1> t1, Field<T2> t2, Field<T3> t3)
greaterThan(Row3)@Support Condition gt(Select<? extends Record3<T1,T2,T3>> select)
greaterThan(Row3)@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition gt(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
@Support Condition greaterOrEqual(Row3<T1,T2,T3> 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(Record3<T1,T2,T3> record)
greaterOrEqual(Row3)@Support Condition greaterOrEqual(T1 t1, T2 t2, T3 t3)
greaterOrEqual(Row3)@Support Condition greaterOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3)
greaterOrEqual(Row3)@Support Condition greaterOrEqual(Select<? extends Record3<T1,T2,T3>> select)
greaterOrEqual(Row3)@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterOrEqual(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
@Support Condition ge(Row3<T1,T2,T3> row)
greaterOrEqual(Row3)@Support Condition ge(Record3<T1,T2,T3> record)
greaterOrEqual(Row3)@Support Condition ge(T1 t1, T2 t2, T3 t3)
greaterOrEqual(Row3)@Support Condition ge(Field<T1> t1, Field<T2> t2, Field<T3> t3)
greaterOrEqual(Row3)@Support Condition ge(Select<? extends Record3<T1,T2,T3>> select)
greaterOrEqual(Row3)@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition ge(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)
@Support BetweenAndStep3<T1,T2,T3> between(T1 minValue1, T2 minValue2, T3 minValue3)
between(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3)
between(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> between(Row3<T1,T2,T3> minValue)
between(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> between(Record3<T1,T2,T3> minValue)
between(Row3, Row3)@Support Condition between(Row3<T1,T2,T3> minValue, Row3<T1,T2,T3> 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(Record3<T1,T2,T3> minValue, Record3<T1,T2,T3> maxValue)
 This is the same as calling between(minValue).and(maxValue)
between(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3)
betweenSymmetric(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3)
betweenSymmetric(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> betweenSymmetric(Row3<T1,T2,T3> minValue)
betweenSymmetric(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> betweenSymmetric(Record3<T1,T2,T3> minValue)
betweenSymmetric(Row3, Row3)@Support Condition betweenSymmetric(Row3<T1,T2,T3> minValue, Row3<T1,T2,T3> 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(Record3<T1,T2,T3> minValue, Record3<T1,T2,T3> maxValue)
 This is the same as calling betweenSymmetric(minValue).and(maxValue)
betweenSymmetric(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> notBetween(T1 minValue1, T2 minValue2, T3 minValue3)
between(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> notBetween(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3)
notBetween(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> notBetween(Row3<T1,T2,T3> minValue)
notBetween(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> notBetween(Record3<T1,T2,T3> minValue)
notBetween(Row3, Row3)@Support Condition notBetween(Row3<T1,T2,T3> minValue, Row3<T1,T2,T3> 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(Record3<T1,T2,T3> minValue, Record3<T1,T2,T3> maxValue)
 This is the same as calling notBetween(minValue).and(maxValue)
notBetween(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> notBetweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3)
notBetweenSymmetric(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> notBetweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3)
notBetweenSymmetric(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> notBetweenSymmetric(Row3<T1,T2,T3> minValue)
notBetweenSymmetric(Row3, Row3)@Support BetweenAndStep3<T1,T2,T3> notBetweenSymmetric(Record3<T1,T2,T3> minValue)
notBetweenSymmetric(Row3, Row3)@Support Condition notBetweenSymmetric(Row3<T1,T2,T3> minValue, Row3<T1,T2,T3> 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(Record3<T1,T2,T3> minValue, Record3<T1,T2,T3> maxValue)
 This is the same as calling notBetweenSymmetric(minValue).and(maxValue)
notBetweenSymmetric(Row3, Row3)@Support Condition in(Collection<? extends Row3<T1,T2,T3>> 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)
@Support Condition in(Result<? extends Record3<T1,T2,T3>> 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)
@Support Condition in(Row3<T1,T2,T3>... rows)
in(Collection)@Support Condition in(Record3<T1,T2,T3>... record)
in(Collection)@Support Condition in(Select<? extends Record3<T1,T2,T3>> select)
in(Collection)@Support Condition notIn(Collection<? extends Row3<T1,T2,T3>> 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))
@Support Condition notIn(Result<? extends Record3<T1,T2,T3>> 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))
@Support Condition notIn(Row3<T1,T2,T3>... rows)
notIn(Collection)@Support Condition notIn(Record3<T1,T2,T3>... record)
notIn(Collection)Copyright © 2015. All Rights Reserved.