org.jooq

Interface Row4<T1,T2,T3,T4>

All Superinterfaces:

QueryPart, Row, Serializable

@Generated(value="This class was generated using jOOQ-tools")
public interface Row4<T1,T2,T3,T4>
extends Row

A model type for a row value expression with degree 4

Note: Not all databases support row value expressions, but many row value expression operations can be simulated on all databases. See relevant row value expression method Javadocs for details.

Author:

Lukas Eder

Method Summary

Methods

Modifier and Type	Method and Description
BetweenAndStep4<T1,T2,T3,T4>	between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4) Check if this row value expression is within a range of two other row value expressions
BetweenAndStep4<T1,T2,T3,T4>	between(Record4<T1,T2,T3,T4> minValue) Check if this row value expression is within a range of two records
Condition	between(Record4<T1,T2,T3,T4> minValue, Record4<T1,T2,T3,T4> maxValue) Check if this row value expression is within a range of two records This is the same as calling between(minValue).and(maxValue)
BetweenAndStep4<T1,T2,T3,T4>	between(Row4<T1,T2,T3,T4> minValue) Check if this row value expression is within a range of two other row value expressions
Condition	between(Row4<T1,T2,T3,T4> minValue, Row4<T1,T2,T3,T4> maxValue) Check if this row value expression is within a range of two other row value expressions This is the same as calling between(minValue).and(maxValue) The 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
BetweenAndStep4<T1,T2,T3,T4>	between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4) Check if this row value expression is within a range of two other row value expressions
BetweenAndStep4<T1,T2,T3,T4>	betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4) Check if this row value expression is within a symmetric range of two other row value expressions
BetweenAndStep4<T1,T2,T3,T4>	betweenSymmetric(Record4<T1,T2,T3,T4> minValue) Check if this row value expression is within a symmetric range of two records
Condition	betweenSymmetric(Record4<T1,T2,T3,T4> minValue, Record4<T1,T2,T3,T4> maxValue) Check if this row value expression is within a symmetric range of two records This is the same as calling betweenSymmetric(minValue).and(maxValue)
BetweenAndStep4<T1,T2,T3,T4>	betweenSymmetric(Row4<T1,T2,T3,T4> minValue) Check if this row value expression is within a symmetric range of two other row value expressions
Condition	betweenSymmetric(Row4<T1,T2,T3,T4> minValue, Row4<T1,T2,T3,T4> maxValue) Check if this row value expression is within a symmetric range of two other row value expressions This is the same as calling betweenSymmetric(minValue).and(maxValue) The 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
BetweenAndStep4<T1,T2,T3,T4>	betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4) Check if this row value expression is within a symmetric range of two other row value expressions
Condition	eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for equality
Condition	eq(Record4<T1,T2,T3,T4> record) Compare this row value expression with a record for equality
Condition	eq(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for equality
Condition	eq(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for equality
Condition	eq(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for equality
Condition	equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for equality
Condition	equal(Record4<T1,T2,T3,T4> record) Compare this row value expression with a record for equality
Condition	equal(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for equality Row equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) = (1, 2) is equivalent to A = 1 AND B = 2
Condition	equal(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for equality
Condition	equal(T1 t1, T2 t2, T3 t3, T4 t4) 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
Field<T4>	field4() Get the fourth field
Condition	ge(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for order
Condition	ge(Record4<T1,T2,T3,T4> record) Compare this row value expression with a record for order
Condition	ge(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for order
Condition	ge(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order
Condition	ge(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for order
Condition	greaterOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for order
Condition	greaterOrEqual(Record4<T1,T2,T3,T4> record) Compare this row value expression with a record for order
Condition	greaterOrEqual(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for order Row order comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) >= (1, 2) is equivalent to A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2)
Condition	greaterOrEqual(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order
Condition	greaterOrEqual(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for order
Condition	greaterThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for order
Condition	greaterThan(Record4<T1,T2,T3,T4> record) Compare this row value expression with a record for order
Condition	greaterThan(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for order Row order comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B, C) > (1, 2, 3) is equivalent to A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3)
Condition	greaterThan(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order
Condition	greaterThan(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for order
Condition	gt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for order
Condition	gt(Record4<T1,T2,T3,T4> record) Compare this row value expression with a record for order
Condition	gt(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for order
Condition	gt(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order
Condition	gt(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for order
Condition	in(Collection<? extends Row4<T1,T2,T3,T4>> rows) Compare this row value expression with a set of row value expressions for equality Row IN predicates can be simulated in those databases that do not support such predicates natively: (A, B) IN ((1, 2), (3, 4)) is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
Condition	in(Record4<T1,T2,T3,T4>... record) Compare this row value expression with a set of records for equality
Condition	in(Row4<T1,T2,T3,T4>... rows) Compare this row value expression with a set of row value expressions for equality
Condition	in(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for equality
Condition	le(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for order
Condition	le(Record4<T1,T2,T3,T4> record) Compare this row value expression with a record for order
Condition	le(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for order
Condition	le(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order
Condition	le(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for order
Condition	lessOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for order
Condition	lessOrEqual(Record4<T1,T2,T3,T4> record) Compare this row value expression with a record for order
Condition	lessOrEqual(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for order Row order comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) <= (1, 2) is equivalent to A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2)
Condition	lessOrEqual(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order
Condition	lessOrEqual(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for order
Condition	lessThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for order
Condition	lessThan(Record4<T1,T2,T3,T4> record) Compare this row value expression with a record for order
Condition	lessThan(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for order Row order comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B, C) < (1, 2, 3) is equivalent to A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3)
Condition	lessThan(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order
Condition	lessThan(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for order
Condition	lt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for order
Condition	lt(Record4<T1,T2,T3,T4> record) Compare this row value expression with a record for order
Condition	lt(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for order
Condition	lt(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order
Condition	lt(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for order
Condition	ne(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for
Condition	ne(Record4<T1,T2,T3,T4> record) Compare this row value expression with a record for non-equality
Condition	ne(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for non-equality
Condition	ne(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for non-equality
Condition	ne(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for non-equality
BetweenAndStep4<T1,T2,T3,T4>	notBetween(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4) Check if this row value expression is not within a range of two other row value expressions
BetweenAndStep4<T1,T2,T3,T4>	notBetween(Record4<T1,T2,T3,T4> minValue) Check if this row value expression is within a range of two records
Condition	notBetween(Record4<T1,T2,T3,T4> minValue, Record4<T1,T2,T3,T4> maxValue) Check if this row value expression is within a range of two records This is the same as calling notBetween(minValue).and(maxValue)
BetweenAndStep4<T1,T2,T3,T4>	notBetween(Row4<T1,T2,T3,T4> minValue) Check if this row value expression is not within a range of two other row value expressions
Condition	notBetween(Row4<T1,T2,T3,T4> minValue, Row4<T1,T2,T3,T4> maxValue) Check if this row value expression is not within a range of two other row value expressions This is the same as calling notBetween(minValue).and(maxValue) The 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
BetweenAndStep4<T1,T2,T3,T4>	notBetween(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4) Check if this row value expression is not within a range of two other row value expressions
BetweenAndStep4<T1,T2,T3,T4>	notBetweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4) Check if this row value expression is not within a symmetric range of two other row value expressions
BetweenAndStep4<T1,T2,T3,T4>	notBetweenSymmetric(Record4<T1,T2,T3,T4> minValue) Check if this row value expression is not within a symmetric range of two records
Condition	notBetweenSymmetric(Record4<T1,T2,T3,T4> minValue, Record4<T1,T2,T3,T4> maxValue) Check if this row value expression is not within a symmetric range of two records This is the same as calling notBetweenSymmetric(minValue).and(maxValue)
BetweenAndStep4<T1,T2,T3,T4>	notBetweenSymmetric(Row4<T1,T2,T3,T4> minValue) Check if this row value expression is not within a symmetric range of two other row value expressions
Condition	notBetweenSymmetric(Row4<T1,T2,T3,T4> minValue, Row4<T1,T2,T3,T4> maxValue) Check if this row value expression is not within a symmetric range of two other row value expressions This is the same as calling notBetweenSymmetric(minValue).and(maxValue) The 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
BetweenAndStep4<T1,T2,T3,T4>	notBetweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4) 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, Field<T4> t4) Compare this row value expression with another row value expression for non-equality
Condition	notEqual(Record4<T1,T2,T3,T4> record) Compare this row value expression with a record for non-equality
Condition	notEqual(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for non-equality Row non-equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) <> (1, 2) is equivalent to NOT(A = 1 AND B = 2)
Condition	notEqual(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for non-equality
Condition	notEqual(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for non-equality
Condition	notIn(Collection<? extends Row4<T1,T2,T3,T4>> rows) Compare this row value expression with a set of row value expressions for equality Row NOT IN predicates can be simulated in those databases that do not support such predicates natively: (A, B) NOT IN ((1, 2), (3, 4)) is equivalent to NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
Condition	notIn(Record4<T1,T2,T3,T4>... record) Compare this row value expression with a set of records for non-equality
Condition	notIn(Row4<T1,T2,T3,T4>... rows) Compare this row value expression with a set of row value expressions for equality
Condition	notIn(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for non-equality

Methods inherited from interface org.jooq.Row

dataType, dataType, dataTypes, field, field, field, fields, indexOf, indexOf, isNotNull, isNull, size, type, type, types

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Detail

field1

Field<T1> field1()

Get the first field

field2

Field<T2> field2()

Get the second field

field3

Field<T3> field3()

Get the third field

field4

Field<T4> field4()

Get the fourth field

equal

@Support
Condition equal(Row4<T1,T2,T3,T4> row)

Compare this row value expression with another row value expression for equality

Row equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) = (1, 2) is equivalent to A = 1 AND B = 2

equal

@Support
Condition equal(Record4<T1,T2,T3,T4> record)

Compare this row value expression with a record for equality

See Also:

equal(Row4)

equal

@Support
Condition equal(T1 t1,
                      T2 t2,
                      T3 t3,
                      T4 t4)

Compare this row value expression with another row value expression for equality

See Also:

equal(Row4)

equal

@Support
Condition equal(Field<T1> t1,
                      Field<T2> t2,
                      Field<T3> t3,
                      Field<T4> t4)

Compare this row value expression with another row value expression for equality

See Also:

equal(Row4)

equal

@Support(value={HSQLDB,MYSQL,ORACLE,POSTGRES})
Condition equal(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for equality

See Also:

equal(Row4)

eq

@Support
Condition eq(Row4<T1,T2,T3,T4> row)

Compare this row value expression with another row value expression for equality

See Also:

equal(Row4)

eq

@Support
Condition eq(Record4<T1,T2,T3,T4> record)

Compare this row value expression with a record for equality

See Also:

equal(Row4)

eq

@Support
Condition eq(T1 t1,
                   T2 t2,
                   T3 t3,
                   T4 t4)

Compare this row value expression with another row value expression for equality

See Also:

equal(Row4)

eq

@Support
Condition eq(Field<T1> t1,
                   Field<T2> t2,
                   Field<T3> t3,
                   Field<T4> t4)

Compare this row value expression with another row value expression for equality

See Also:

equal(Row4)

eq

@Support(value={HSQLDB,MYSQL,ORACLE,POSTGRES})
Condition eq(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for equality

See Also:

equal(Row4)

notEqual

@Support
Condition notEqual(Row4<T1,T2,T3,T4> row)

Compare this row value expression with another row value expression for non-equality

Row non-equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) <> (1, 2) is equivalent to NOT(A = 1 AND B = 2)

notEqual

@Support
Condition notEqual(Record4<T1,T2,T3,T4> record)

Compare this row value expression with a record for non-equality

See Also:

notEqual(Row4)

notEqual

@Support
Condition notEqual(T1 t1,
                         T2 t2,
                         T3 t3,
                         T4 t4)

Compare this row value expression with another row value expression for non-equality

See Also:

notEqual(Row4)

notEqual

@Support
Condition notEqual(Field<T1> t1,
                         Field<T2> t2,
                         Field<T3> t3,
                         Field<T4> t4)

Compare this row value expression with another row value expression for non-equality

See Also:

notEqual(Row4)

notEqual

@Support(value={HSQLDB,MYSQL,ORACLE,POSTGRES})
Condition notEqual(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for non-equality

See Also:

notEqual(Row4)

ne

@Support
Condition ne(Row4<T1,T2,T3,T4> row)

Compare this row value expression with another row value expression for non-equality

See Also:

notEqual(Row4)

ne

@Support
Condition ne(Record4<T1,T2,T3,T4> record)

Compare this row value expression with a record for non-equality

See Also:

notEqual(Row4)

ne

@Support
Condition ne(T1 t1,
                   T2 t2,
                   T3 t3,
                   T4 t4)

Compare this row value expression with another row value expression for non-equality

See Also:

notEqual(Row4)

ne

@Support
Condition ne(Field<T1> t1,
                   Field<T2> t2,
                   Field<T3> t3,
                   Field<T4> t4)

Compare this row value expression with another row value expression for

See Also:

notEqual(Row4)

ne

@Support(value={HSQLDB,MYSQL,ORACLE,POSTGRES})
Condition ne(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for non-equality

See Also:

notEqual(Row4)

lessThan

@Support
Condition lessThan(Row4<T1,T2,T3,T4> row)

Compare this row value expression with another row value expression for order

Row order comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B, C) < (1, 2, 3) is equivalent to A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3)

lessThan

@Support
Condition lessThan(Record4<T1,T2,T3,T4> record)

Compare this row value expression with a record for order

See Also:

lessThan(Row4)

lessThan

@Support
Condition lessThan(T1 t1,
                         T2 t2,
                         T3 t3,
                         T4 t4)

Compare this row value expression with another row value expression for order

See Also:

lessThan(Row4)

lessThan

@Support
Condition lessThan(Field<T1> t1,
                         Field<T2> t2,
                         Field<T3> t3,
                         Field<T4> t4)

Compare this row value expression with another row value expression for order

See Also:

lessThan(Row4)

lessThan

@Support(value={HSQLDB,MYSQL,POSTGRES})
Condition lessThan(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for order

See Also:

lessThan(Row4)

lt

@Support
Condition lt(Row4<T1,T2,T3,T4> row)

Compare this row value expression with another row value expression for order

See Also:

lessThan(Row4)

lt

@Support
Condition lt(Record4<T1,T2,T3,T4> record)

Compare this row value expression with a record for order

See Also:

lessThan(Row4)

lt

@Support
Condition lt(T1 t1,
                   T2 t2,
                   T3 t3,
                   T4 t4)

Compare this row value expression with another row value expression for order

See Also:

lessThan(Row4)

lt

@Support
Condition lt(Field<T1> t1,
                   Field<T2> t2,
                   Field<T3> t3,
                   Field<T4> t4)

Compare this row value expression with another row value expression for order

See Also:

lessThan(Row4)

lt

@Support(value={HSQLDB,MYSQL,POSTGRES})
Condition lt(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for order

See Also:

lessThan(Row4)

lessOrEqual

@Support
Condition lessOrEqual(Row4<T1,T2,T3,T4> row)

Compare this row value expression with another row value expression for order

Row order comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) <= (1, 2) is equivalent to A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2)

lessOrEqual

@Support
Condition lessOrEqual(Record4<T1,T2,T3,T4> record)

Compare this row value expression with a record for order

See Also:

lessOrEqual(Row4)

lessOrEqual

@Support
Condition lessOrEqual(T1 t1,
                            T2 t2,
                            T3 t3,
                            T4 t4)

Compare this row value expression with another row value expression for order

See Also:

lessOrEqual(Row4)

lessOrEqual

@Support
Condition lessOrEqual(Field<T1> t1,
                            Field<T2> t2,
                            Field<T3> t3,
                            Field<T4> t4)

Compare this row value expression with another row value expression for order

See Also:

lessOrEqual(Row4)

lessOrEqual

@Support(value={HSQLDB,MYSQL,POSTGRES})
Condition lessOrEqual(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for order

See Also:

lessOrEqual(Row4)

le

@Support
Condition le(Row4<T1,T2,T3,T4> row)

Compare this row value expression with another row value expression for order

See Also:

lessOrEqual(Row4)

le

@Support
Condition le(Record4<T1,T2,T3,T4> record)

Compare this row value expression with a record for order

See Also:

lessOrEqual(Row4)

le

@Support
Condition le(T1 t1,
                   T2 t2,
                   T3 t3,
                   T4 t4)

Compare this row value expression with another row value expression for order

See Also:

lessOrEqual(Row4)

le

@Support
Condition le(Field<T1> t1,
                   Field<T2> t2,
                   Field<T3> t3,
                   Field<T4> t4)

Compare this row value expression with another row value expression for order

See Also:

lessOrEqual(Row4)

le

@Support(value={HSQLDB,MYSQL,POSTGRES})
Condition le(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for order

See Also:

lessOrEqual(Row4)

greaterThan

@Support
Condition greaterThan(Row4<T1,T2,T3,T4> row)

Compare this row value expression with another row value expression for order

Row order comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B, C) > (1, 2, 3) is equivalent to A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3)

greaterThan

@Support
Condition greaterThan(Record4<T1,T2,T3,T4> record)

Compare this row value expression with a record for order

See Also:

greaterThan(Row4)

greaterThan

@Support
Condition greaterThan(T1 t1,
                            T2 t2,
                            T3 t3,
                            T4 t4)

Compare this row value expression with another row value expression for order

See Also:

greaterThan(Row4)

greaterThan

@Support
Condition greaterThan(Field<T1> t1,
                            Field<T2> t2,
                            Field<T3> t3,
                            Field<T4> t4)

Compare this row value expression with another row value expression for order

See Also:

greaterThan(Row4)

greaterThan

@Support(value={HSQLDB,MYSQL,POSTGRES})
Condition greaterThan(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for order

See Also:

greaterThan(Row4)

gt

@Support
Condition gt(Row4<T1,T2,T3,T4> row)

Compare this row value expression with another row value expression for order

See Also:

greaterThan(Row4)

gt

@Support
Condition gt(Record4<T1,T2,T3,T4> record)

Compare this row value expression with a record for order

See Also:

greaterThan(Row4)

gt

@Support
Condition gt(T1 t1,
                   T2 t2,
                   T3 t3,
                   T4 t4)

Compare this row value expression with another row value expression for order

See Also:

greaterThan(Row4)

gt

@Support
Condition gt(Field<T1> t1,
                   Field<T2> t2,
                   Field<T3> t3,
                   Field<T4> t4)

Compare this row value expression with another row value expression for order

See Also:

greaterThan(Row4)

gt

@Support(value={HSQLDB,MYSQL,POSTGRES})
Condition gt(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for order

See Also:

greaterThan(Row4)

greaterOrEqual

@Support
Condition greaterOrEqual(Row4<T1,T2,T3,T4> row)

Compare this row value expression with another row value expression for order

Row order comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) >= (1, 2) is equivalent to A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2)

greaterOrEqual

@Support
Condition greaterOrEqual(Record4<T1,T2,T3,T4> record)

Compare this row value expression with a record for order

See Also:

greaterOrEqual(Row4)

greaterOrEqual

@Support
Condition greaterOrEqual(T1 t1,
                               T2 t2,
                               T3 t3,
                               T4 t4)

Compare this row value expression with another row value expression for order

See Also:

greaterOrEqual(Row4)

greaterOrEqual

@Support
Condition greaterOrEqual(Field<T1> t1,
                               Field<T2> t2,
                               Field<T3> t3,
                               Field<T4> t4)

Compare this row value expression with another row value expression for order

See Also:

greaterOrEqual(Row4)

greaterOrEqual

@Support(value={HSQLDB,MYSQL,POSTGRES})
Condition greaterOrEqual(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for order

See Also:

greaterOrEqual(Row4)

ge

@Support
Condition ge(Row4<T1,T2,T3,T4> row)

Compare this row value expression with another row value expression for order

See Also:

greaterOrEqual(Row4)

ge

@Support
Condition ge(Record4<T1,T2,T3,T4> record)

Compare this row value expression with a record for order

See Also:

greaterOrEqual(Row4)

ge

@Support
Condition ge(T1 t1,
                   T2 t2,
                   T3 t3,
                   T4 t4)

Compare this row value expression with another row value expression for order

See Also:

greaterOrEqual(Row4)

ge

@Support
Condition ge(Field<T1> t1,
                   Field<T2> t2,
                   Field<T3> t3,
                   Field<T4> t4)

Compare this row value expression with another row value expression for order

See Also:

greaterOrEqual(Row4)

ge

@Support(value={HSQLDB,MYSQL,POSTGRES})
Condition ge(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for order

See Also:

greaterOrEqual(Row4)

between

@Support
BetweenAndStep4<T1,T2,T3,T4> between(T1 minValue1,
                                           T2 minValue2,
                                           T3 minValue3,
                                           T4 minValue4)

Check if this row value expression is within a range of two other row value expressions

See Also:

between(Row4, Row4)

between

@Support
BetweenAndStep4<T1,T2,T3,T4> between(Field<T1> minValue1,
                                           Field<T2> minValue2,
                                           Field<T3> minValue3,
                                           Field<T4> minValue4)

Check if this row value expression is within a range of two other row value expressions

See Also:

between(Row4, Row4)

between

@Support
BetweenAndStep4<T1,T2,T3,T4> between(Row4<T1,T2,T3,T4> minValue)

Check if this row value expression is within a range of two other row value expressions

See Also:

between(Row4, Row4)

between

@Support
BetweenAndStep4<T1,T2,T3,T4> between(Record4<T1,T2,T3,T4> minValue)

Check if this row value expression is within a range of two records

See Also:

between(Row4, Row4)

between

@Support
Condition between(Row4<T1,T2,T3,T4> minValue,
                        Row4<T1,T2,T3,T4> maxValue)

Check if this row value expression is within a range of two other row value expressions

This is the same as calling between(minValue).and(maxValue)

The 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

between

@Support
Condition between(Record4<T1,T2,T3,T4> minValue,
                        Record4<T1,T2,T3,T4> maxValue)

Check if this row value expression is within a range of two records

This is the same as calling between(minValue).and(maxValue)

See Also:

between(Row4, Row4)

betweenSymmetric

@Support
BetweenAndStep4<T1,T2,T3,T4> betweenSymmetric(T1 minValue1,
                                                    T2 minValue2,
                                                    T3 minValue3,
                                                    T4 minValue4)

Check if this row value expression is within a symmetric range of two other row value expressions

See Also:

betweenSymmetric(Row4, Row4)

betweenSymmetric

@Support
BetweenAndStep4<T1,T2,T3,T4> betweenSymmetric(Field<T1> minValue1,
                                                    Field<T2> minValue2,
                                                    Field<T3> minValue3,
                                                    Field<T4> minValue4)

Check if this row value expression is within a symmetric range of two other row value expressions

See Also:

betweenSymmetric(Row4, Row4)

betweenSymmetric

@Support
BetweenAndStep4<T1,T2,T3,T4> betweenSymmetric(Row4<T1,T2,T3,T4> minValue)

Check if this row value expression is within a symmetric range of two other row value expressions

See Also:

betweenSymmetric(Row4, Row4)

betweenSymmetric

@Support
BetweenAndStep4<T1,T2,T3,T4> betweenSymmetric(Record4<T1,T2,T3,T4> minValue)

Check if this row value expression is within a symmetric range of two records

See Also:

betweenSymmetric(Row4, Row4)

betweenSymmetric

@Support
Condition betweenSymmetric(Row4<T1,T2,T3,T4> minValue,
                                 Row4<T1,T2,T3,T4> maxValue)

Check if this row value expression is within a symmetric range of two other row value expressions

This is the same as calling betweenSymmetric(minValue).and(maxValue)

The 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

betweenSymmetric

@Support
Condition betweenSymmetric(Record4<T1,T2,T3,T4> minValue,
                                 Record4<T1,T2,T3,T4> maxValue)

Check if this row value expression is within a symmetric range of two records

This is the same as calling betweenSymmetric(minValue).and(maxValue)

See Also:

betweenSymmetric(Row4, Row4)

notBetween

@Support
BetweenAndStep4<T1,T2,T3,T4> notBetween(T1 minValue1,
                                              T2 minValue2,
                                              T3 minValue3,
                                              T4 minValue4)

Check if this row value expression is not within a range of two other row value expressions

See Also:

between(Row4, Row4)

notBetween

@Support
BetweenAndStep4<T1,T2,T3,T4> notBetween(Field<T1> minValue1,
                                              Field<T2> minValue2,
                                              Field<T3> minValue3,
                                              Field<T4> minValue4)

Check if this row value expression is not within a range of two other row value expressions

See Also:

notBetween(Row4, Row4)

notBetween

@Support
BetweenAndStep4<T1,T2,T3,T4> notBetween(Row4<T1,T2,T3,T4> minValue)

Check if this row value expression is not within a range of two other row value expressions

See Also:

notBetween(Row4, Row4)

notBetween

@Support
BetweenAndStep4<T1,T2,T3,T4> notBetween(Record4<T1,T2,T3,T4> minValue)

Check if this row value expression is within a range of two records

See Also:

notBetween(Row4, Row4)

notBetween

@Support
Condition notBetween(Row4<T1,T2,T3,T4> minValue,
                           Row4<T1,T2,T3,T4> maxValue)

Check if this row value expression is not within a range of two other row value expressions

This is the same as calling notBetween(minValue).and(maxValue)

The 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

notBetween

@Support
Condition notBetween(Record4<T1,T2,T3,T4> minValue,
                           Record4<T1,T2,T3,T4> maxValue)

Check if this row value expression is within a range of two records

This is the same as calling notBetween(minValue).and(maxValue)

See Also:

notBetween(Row4, Row4)

notBetweenSymmetric

@Support
BetweenAndStep4<T1,T2,T3,T4> notBetweenSymmetric(T1 minValue1,
                                                       T2 minValue2,
                                                       T3 minValue3,
                                                       T4 minValue4)

Check if this row value expression is not within a symmetric range of two other row value expressions

See Also:

notBetweenSymmetric(Row4, Row4)

notBetweenSymmetric

@Support
BetweenAndStep4<T1,T2,T3,T4> notBetweenSymmetric(Field<T1> minValue1,
                                                       Field<T2> minValue2,
                                                       Field<T3> minValue3,
                                                       Field<T4> minValue4)

Check if this row value expression is not within a symmetric range of two other row value expressions

See Also:

notBetweenSymmetric(Row4, Row4)

notBetweenSymmetric

@Support
BetweenAndStep4<T1,T2,T3,T4> notBetweenSymmetric(Row4<T1,T2,T3,T4> minValue)

Check if this row value expression is not within a symmetric range of two other row value expressions

See Also:

notBetweenSymmetric(Row4, Row4)

notBetweenSymmetric

@Support
BetweenAndStep4<T1,T2,T3,T4> notBetweenSymmetric(Record4<T1,T2,T3,T4> minValue)

Check if this row value expression is not within a symmetric range of two records

See Also:

notBetweenSymmetric(Row4, Row4)

notBetweenSymmetric

@Support
Condition notBetweenSymmetric(Row4<T1,T2,T3,T4> minValue,
                                    Row4<T1,T2,T3,T4> maxValue)

Check if this row value expression is not within a symmetric range of two other row value expressions

This is the same as calling notBetweenSymmetric(minValue).and(maxValue)

The 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

notBetweenSymmetric

@Support
Condition notBetweenSymmetric(Record4<T1,T2,T3,T4> minValue,
                                    Record4<T1,T2,T3,T4> maxValue)

Check if this row value expression is not within a symmetric range of two records

This is the same as calling notBetweenSymmetric(minValue).and(maxValue)

See Also:

notBetweenSymmetric(Row4, Row4)

in

@Support
Condition in(Collection<? extends Row4<T1,T2,T3,T4>> rows)

Compare this row value expression with a set of row value expressions for equality

Row IN predicates can be simulated in those databases that do not support such predicates natively: (A, B) IN ((1, 2), (3, 4)) is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)

in

@Support
Condition in(Row4<T1,T2,T3,T4>... rows)

Compare this row value expression with a set of row value expressions for equality

See Also:

in(Collection)

in

@Support
Condition in(Record4<T1,T2,T3,T4>... record)

Compare this row value expression with a set of records for equality

See Also:

in(Collection)

in

@Support(value={DB2,HSQLDB,MYSQL,ORACLE,POSTGRES})
Condition in(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for equality

See Also:

in(Collection)

notIn

@Support
Condition notIn(Collection<? extends Row4<T1,T2,T3,T4>> rows)

Compare this row value expression with a set of row value expressions for equality

Row NOT IN predicates can be simulated in those databases that do not support such predicates natively: (A, B) NOT IN ((1, 2), (3, 4)) is equivalent to NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))

notIn

@Support
Condition notIn(Row4<T1,T2,T3,T4>... rows)

Compare this row value expression with a set of row value expressions for equality

See Also:

notIn(Collection)

notIn

@Support
Condition notIn(Record4<T1,T2,T3,T4>... record)

Compare this row value expression with a set of records for non-equality

See Also:

notIn(Collection)

notIn

@Support(value={DB2,HSQLDB,MYSQL,ORACLE,POSTGRES})
Condition notIn(Select<? extends Record4<T1,T2,T3,T4>> select)

Compare this row value expression with a subselect for non-equality

See Also:

notIn(Collection)