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