Module org.jooq

Package org.jooq

Interface Row7<T1,T2,T3,T4,T5,T6,T7>

All Superinterfaces:

FieldOrRow, QueryPart, Row, Serializable

public interface Row7<T1,T2,T3,T4,T5,T6,T7>
extends Row

A row value expression.

Row value expressions are mainly useful for use in predicates, when comparing several values in one go, which can be more elegant than expanding the row value expression predicate in other equivalent syntaxes. This is especially true for non-equality predicates. For instance, the following two predicates are equivalent in SQL:

 (A, B) > (X, Y)
 (A > X) OR (A = X AND B > Y)
 

Example:

 // Assuming import static org.jooq.impl.DSL.*;

 using(configuration)
    .select()
    .from(CUSTOMER)
    .where(row(CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME).in(
        select(ACTOR.FIRST_NAME, ACTOR.LAST_NAME).from(ACTOR)
    ))
    .fetch();
 

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.

Instances can be created using DSL.row(Object...) and overloads.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7)	Check if this row value expression is within a range of two other row value expressions.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	between(Record7<T1,T2,T3,T4,T5,T6,T7> minValue)	Check if this row value expression is within a range of two records.
Condition	between(Record7<T1,T2,T3,T4,T5,T6,T7> minValue, Record7<T1,T2,T3,T4,T5,T6,T7> maxValue)	Check if this row value expression is within a range of two records.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	between(Row7<T1,T2,T3,T4,T5,T6,T7> minValue)	Check if this row value expression is within a range of two other row value expressions.
Condition	between(Row7<T1,T2,T3,T4,T5,T6,T7> minValue, Row7<T1,T2,T3,T4,T5,T6,T7> maxValue)	Check if this row value expression is within a range of two other row value expressions.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7)	Check if this row value expression is within a range of two other row value expressions.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7)	Check if this row value expression is within a symmetric range of two other row value expressions.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	betweenSymmetric(Record7<T1,T2,T3,T4,T5,T6,T7> minValue)	Check if this row value expression is within a symmetric range of two records.
Condition	betweenSymmetric(Record7<T1,T2,T3,T4,T5,T6,T7> minValue, Record7<T1,T2,T3,T4,T5,T6,T7> maxValue)	Check if this row value expression is within a symmetric range of two records.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	betweenSymmetric(Row7<T1,T2,T3,T4,T5,T6,T7> minValue)	Check if this row value expression is within a symmetric range of two other row value expressions.
Condition	betweenSymmetric(Row7<T1,T2,T3,T4,T5,T6,T7> minValue, Row7<T1,T2,T3,T4,T5,T6,T7> maxValue)	Check if this row value expression is within a symmetric range of two other row value expressions.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7)	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, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression using a dynamic comparator.
Condition	compare(Comparator comparator, QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect using a dynamic comparator.
Condition	compare(Comparator comparator, Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with a record using a dynamic comparator.
Condition	compare(Comparator comparator, Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression using a dynamic comparator.
Condition	compare(Comparator comparator, Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect using a dynamic comparator.
Condition	compare(Comparator comparator, T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	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, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for equality.
Condition	eq(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for equality.
Condition	eq(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with a record for equality.
Condition	eq(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for equality.
Condition	eq(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for equality.
Condition	eq(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	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, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for equality.
Condition	equal(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for equality.
Condition	equal(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with a record for equality.
Condition	equal(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for equality.
Condition	equal(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for equality.
Condition	equal(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	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.
Field<T5>	field5()	Get the fifth field.
Field<T6>	field6()	Get the sixth field.
Field<T7>	field7()	Get the seventh field.
Condition	ge(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for order.
Condition	ge(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	ge(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with a record for order.
Condition	ge(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for order.
Condition	ge(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	ge(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	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, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for order.
Condition	greaterOrEqual(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	greaterOrEqual(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with a record for order.
Condition	greaterOrEqual(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for order.
Condition	greaterOrEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	greaterOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	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, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for order.
Condition	greaterThan(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	greaterThan(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with a record for order.
Condition	greaterThan(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for order.
Condition	greaterThan(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	greaterThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	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, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for order.
Condition	gt(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	gt(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with a record for order.
Condition	gt(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for order.
Condition	gt(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	gt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	Compare this row value expression with another row value expression for order.
Condition	in(Collection<? extends Row7<T1,T2,T3,T4,T5,T6,T7>> rows)	Compare this row value expression with a set of row value expressions for equality.
Condition	in(Record7<T1,T2,T3,T4,T5,T6,T7>... record)	Compare this row value expression with a set of records for equality.
Condition	in(Result<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> result)	Compare this row value expression with a set of records for equality.
Condition	in(Row7<T1,T2,T3,T4,T5,T6,T7>... rows)	Compare this row value expression with a set of row value expressions for equality.
Condition	in(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for equality.
Condition	isDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for distinctness.
Condition	isDistinctFrom(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with another row value expression for distinctness.
Condition	isDistinctFrom(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for distinctness.
Condition	isDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	Compare this row value expression with another row value expression for distinctness.
Condition	isNotDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for distinctness.
Condition	isNotDistinctFrom(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with another row value expression for distinctness.
Condition	isNotDistinctFrom(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for distinctness.
Condition	isNotDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	Compare this row value expression with another row value expression for distinctness.
Condition	le(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for order.
Condition	le(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	le(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with a record for order.
Condition	le(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for order.
Condition	le(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	le(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	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, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for order.
Condition	lessOrEqual(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	lessOrEqual(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with a record for order.
Condition	lessOrEqual(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for order.
Condition	lessOrEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	lessOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	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, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for order.
Condition	lessThan(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	lessThan(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with a record for order.
Condition	lessThan(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for order.
Condition	lessThan(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	lessThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	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, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for order.
Condition	lt(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	lt(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with a record for order.
Condition	lt(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for order.
Condition	lt(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
Condition	lt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	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, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for non-equality.
Condition	ne(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for non-equality.
Condition	ne(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with a record for non-equality.
Condition	ne(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for non-equality.
Condition	ne(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for non-equality.
Condition	ne(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	Compare this row value expression with another row value expression for non-equality.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	notBetween(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7)	Check if this row value expression is not within a range of two other row value expressions.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	notBetween(Record7<T1,T2,T3,T4,T5,T6,T7> minValue)	Check if this row value expression is within a range of two records.
Condition	notBetween(Record7<T1,T2,T3,T4,T5,T6,T7> minValue, Record7<T1,T2,T3,T4,T5,T6,T7> maxValue)	Check if this row value expression is within a range of two records.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	notBetween(Row7<T1,T2,T3,T4,T5,T6,T7> minValue)	Check if this row value expression is not within a range of two other row value expressions.
Condition	notBetween(Row7<T1,T2,T3,T4,T5,T6,T7> minValue, Row7<T1,T2,T3,T4,T5,T6,T7> maxValue)	Check if this row value expression is not within a range of two other row value expressions.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	notBetween(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7)	Check if this row value expression is not within a range of two other row value expressions.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	notBetweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7)	Check if this row value expression is not within a symmetric range of two other row value expressions.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	notBetweenSymmetric(Record7<T1,T2,T3,T4,T5,T6,T7> minValue)	Check if this row value expression is not within a symmetric range of two records.
Condition	notBetweenSymmetric(Record7<T1,T2,T3,T4,T5,T6,T7> minValue, Record7<T1,T2,T3,T4,T5,T6,T7> maxValue)	Check if this row value expression is not within a symmetric range of two records.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	notBetweenSymmetric(Row7<T1,T2,T3,T4,T5,T6,T7> minValue)	Check if this row value expression is not within a symmetric range of two other row value expressions.
Condition	notBetweenSymmetric(Row7<T1,T2,T3,T4,T5,T6,T7> minValue, Row7<T1,T2,T3,T4,T5,T6,T7> maxValue)	Check if this row value expression is not within a symmetric range of two other row value expressions.
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7>	notBetweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7)	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, Field<T5> t5, Field<T6> t6, Field<T7> t7)	Compare this row value expression with another row value expression for non-equality.
Condition	notEqual(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for non-equality.
Condition	notEqual(Record7<T1,T2,T3,T4,T5,T6,T7> record)	Compare this row value expression with a record for non-equality
Condition	notEqual(Row7<T1,T2,T3,T4,T5,T6,T7> row)	Compare this row value expression with another row value expression for non-equality.
Condition	notEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for non-equality.
Condition	notEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)	Compare this row value expression with another row value expression for.
Condition	notIn(Collection<? extends Row7<T1,T2,T3,T4,T5,T6,T7>> rows)	Compare this row value expression with a set of row value expressions for equality.
Condition	notIn(Record7<T1,T2,T3,T4,T5,T6,T7>... record)	Compare this row value expression with a set of records for non-equality.
Condition	notIn(Result<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> result)	Compare this row value expression with a set of records for equality.
Condition	notIn(Row7<T1,T2,T3,T4,T5,T6,T7>... rows)	Compare this row value expression with a set of row value expressions for equality.
Condition	notIn(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for non-equality.

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Methods inherited from interface org.jooq.Row

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

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.

field5

Field<T5> field5()

Get the fifth field.

field6

Field<T6> field6()

Get the sixth field.

field7

Field<T7> field7()

Get the seventh field.

compare

@Support
Condition compare(Comparator comparator,
                  Row7<T1,T2,T3,T4,T5,T6,T7> row)

Compare this row value expression with another row value expression using a dynamic comparator.

See the explicit comparison methods for details. Note, not all Comparator types are supported

See Also:

equal(Row7), notEqual(Row7), lessThan(Row7), lessOrEqual(Row7), greaterThan(Row7), greaterOrEqual(Row7)

compare

@Support
Condition compare(Comparator comparator,
                  Record7<T1,T2,T3,T4,T5,T6,T7> record)

Compare this row value expression with a record using a dynamic comparator.

See the explicit comparison methods for details. Note, not all Comparator types are supported

See Also:

equal(Record7), notEqual(Record7), lessThan(Record7), lessOrEqual(Record7), greaterThan(Record7), greaterOrEqual(Record7)

compare

@Support
Condition compare(Comparator comparator,
                  T1 t1,
                  T2 t2,
                  T3 t3,
                  T4 t4,
                  T5 t5,
                  T6 t6,
                  T7 t7)

Compare this row value expression with another row value expression using a dynamic comparator.

See the explicit comparison methods for details. Note, not all Comparator types are supported

See Also:

equal(Row7), notEqual(Row7), lessThan(Row7), lessOrEqual(Row7), greaterThan(Row7), greaterOrEqual(Row7)

compare

@Support
Condition compare(Comparator comparator,
                  Field<T1> t1,
                  Field<T2> t2,
                  Field<T3> t3,
                  Field<T4> t4,
                  Field<T5> t5,
                  Field<T6> t6,
                  Field<T7> t7)

Compare this row value expression with another row value expression using a dynamic comparator.

See the explicit comparison methods for details. Note, not all Comparator types are supported

See Also:

equal(Row7), notEqual(Row7), lessThan(Row7), lessOrEqual(Row7), greaterThan(Row7), greaterOrEqual(Row7)

compare

@Support
Condition compare(Comparator comparator,
                  Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect using a dynamic comparator.

See the explicit comparison methods for details. Note, not all Comparator types are supported

See Also:

equal(Select), notEqual(Select), lessThan(Select), lessOrEqual(Select), greaterThan(Select), greaterOrEqual(Select)

compare

@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES,SYBASE,VERTICA})
Condition compare(Comparator comparator,
                  QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect using a dynamic comparator.

See the explicit comparison methods for details. Note, not all Comparator types are supported

See Also:

equal(Select), notEqual(Select), lessThan(Select), lessOrEqual(Select), greaterThan(Select), greaterOrEqual(Select)

equal

@Support
Condition equal(Row7<T1,T2,T3,T4,T5,T6,T7> row)

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

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

equal

@Support
Condition equal(Record7<T1,T2,T3,T4,T5,T6,T7> record)

Compare this row value expression with a record for equality.

See Also:

equal(Row7)

equal

@Support
Condition equal(T1 t1,
                T2 t2,
                T3 t3,
                T4 t4,
                T5 t5,
                T6 t6,
                T7 t7)

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

See Also:

equal(Row7)

equal

@Support
Condition equal(Field<T1> t1,
                Field<T2> t2,
                Field<T3> t3,
                Field<T4> t4,
                Field<T5> t5,
                Field<T6> t6,
                Field<T7> t7)

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

See Also:

equal(Row7)

equal

@Support
Condition equal(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for equality.

See Also:

equal(Row7)

equal

@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES,SYBASE,VERTICA})
Condition equal(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for equality.

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

eq

@Support
Condition eq(Row7<T1,T2,T3,T4,T5,T6,T7> row)

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

See Also:

equal(Row7)

eq

@Support
Condition eq(Record7<T1,T2,T3,T4,T5,T6,T7> record)

Compare this row value expression with a record for equality.

See Also:

equal(Row7)

eq

@Support
Condition eq(T1 t1,
             T2 t2,
             T3 t3,
             T4 t4,
             T5 t5,
             T6 t6,
             T7 t7)

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

See Also:

equal(Row7)

eq

@Support
Condition eq(Field<T1> t1,
             Field<T2> t2,
             Field<T3> t3,
             Field<T4> t4,
             Field<T5> t5,
             Field<T6> t6,
             Field<T7> t7)

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

See Also:

equal(Row7)

eq

@Support
Condition eq(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for equality.

See Also:

equal(Row7)

eq

@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES,SYBASE,VERTICA})
Condition eq(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for equality.

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

notEqual

@Support
Condition notEqual(Row7<T1,T2,T3,T4,T5,T6,T7> row)

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

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)

notEqual

@Support
Condition notEqual(Record7<T1,T2,T3,T4,T5,T6,T7> record)

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

See Also:

notEqual(Row7)

notEqual

@Support
Condition notEqual(T1 t1,
                   T2 t2,
                   T3 t3,
                   T4 t4,
                   T5 t5,
                   T6 t6,
                   T7 t7)

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

See Also:

notEqual(Row7)

notEqual

@Support
Condition notEqual(Field<T1> t1,
                   Field<T2> t2,
                   Field<T3> t3,
                   Field<T4> t4,
                   Field<T5> t5,
                   Field<T6> t6,
                   Field<T7> t7)

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

See Also:

notEqual(Row7)

notEqual

@Support
Condition notEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

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

See Also:

notEqual(Row7)

notEqual

@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES,REDSHIFT,SYBASE})
Condition notEqual(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

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

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

ne

@Support
Condition ne(Row7<T1,T2,T3,T4,T5,T6,T7> row)

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

See Also:

notEqual(Row7)

ne

@Support
Condition ne(Record7<T1,T2,T3,T4,T5,T6,T7> record)

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

See Also:

notEqual(Row7)

ne

@Support
Condition ne(T1 t1,
             T2 t2,
             T3 t3,
             T4 t4,
             T5 t5,
             T6 t6,
             T7 t7)

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

See Also:

notEqual(Row7)

ne

@Support
Condition ne(Field<T1> t1,
             Field<T2> t2,
             Field<T3> t3,
             Field<T4> t4,
             Field<T5> t5,
             Field<T6> t6,
             Field<T7> t7)

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

See Also:

notEqual(Row7)

ne

@Support
Condition ne(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

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

See Also:

notEqual(Row7)

ne

@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HANA,HSQLDB,INGRES,ORACLE,POSTGRES,REDSHIFT,SYBASE})
Condition ne(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

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

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

isDistinctFrom

@Support
Condition isDistinctFrom(Row7<T1,T2,T3,T4,T5,T6,T7> row)

Compare this row value expression with another row value expression for distinctness.

isDistinctFrom

@Support
Condition isDistinctFrom(Record7<T1,T2,T3,T4,T5,T6,T7> record)

Compare this row value expression with another row value expression for distinctness.

isDistinctFrom

@Support
Condition isDistinctFrom(T1 t1,
                         T2 t2,
                         T3 t3,
                         T4 t4,
                         T5 t5,
                         T6 t6,
                         T7 t7)

Compare this row value expression with another row value expression for distinctness.

isDistinctFrom

@Support
Condition isDistinctFrom(Field<T1> t1,
                         Field<T2> t2,
                         Field<T3> t3,
                         Field<T4> t4,
                         Field<T5> t5,
                         Field<T6> t6,
                         Field<T7> t7)

Compare this row value expression with another row value expression for distinctness.

isNotDistinctFrom

@Support
Condition isNotDistinctFrom(Row7<T1,T2,T3,T4,T5,T6,T7> row)

Compare this row value expression with another row value expression for distinctness.

isNotDistinctFrom

@Support
Condition isNotDistinctFrom(Record7<T1,T2,T3,T4,T5,T6,T7> record)

Compare this row value expression with another row value expression for distinctness.

isNotDistinctFrom

@Support
Condition isNotDistinctFrom(T1 t1,
                            T2 t2,
                            T3 t3,
                            T4 t4,
                            T5 t5,
                            T6 t6,
                            T7 t7)

Compare this row value expression with another row value expression for distinctness.

isNotDistinctFrom

@Support
Condition isNotDistinctFrom(Field<T1> t1,
                            Field<T2> t2,
                            Field<T3> t3,
                            Field<T4> t4,
                            Field<T5> t5,
                            Field<T6> t6,
                            Field<T7> t7)

Compare this row value expression with another row value expression for distinctness.

lessThan

@Support
Condition lessThan(Row7<T1,T2,T3,T4,T5,T6,T7> row)

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

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)

lessThan

@Support
Condition lessThan(Record7<T1,T2,T3,T4,T5,T6,T7> record)

Compare this row value expression with a record for order.

See Also:

lessThan(Row7)

lessThan

@Support
Condition lessThan(T1 t1,
                   T2 t2,
                   T3 t3,
                   T4 t4,
                   T5 t5,
                   T6 t6,
                   T7 t7)

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

See Also:

lessThan(Row7)

lessThan

@Support
Condition lessThan(Field<T1> t1,
                   Field<T2> t2,
                   Field<T3> t3,
                   Field<T4> t4,
                   Field<T5> t5,
                   Field<T6> t6,
                   Field<T7> t7)

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

See Also:

lessThan(Row7)

lessThan

@Support
Condition lessThan(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

lessThan(Row7)

lessThan

@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE})
Condition lessThan(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

lt

@Support
Condition lt(Row7<T1,T2,T3,T4,T5,T6,T7> row)

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

See Also:

lessThan(Row7)

lt

@Support
Condition lt(Record7<T1,T2,T3,T4,T5,T6,T7> record)

Compare this row value expression with a record for order.

See Also:

lessThan(Row7)

lt

@Support
Condition lt(T1 t1,
             T2 t2,
             T3 t3,
             T4 t4,
             T5 t5,
             T6 t6,
             T7 t7)

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

See Also:

lessThan(Row7)

lt

@Support
Condition lt(Field<T1> t1,
             Field<T2> t2,
             Field<T3> t3,
             Field<T4> t4,
             Field<T5> t5,
             Field<T6> t6,
             Field<T7> t7)

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

See Also:

lessThan(Row7)

lt

@Support
Condition lt(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

lessThan(Row7)

lt

@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE})
Condition lt(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

lessOrEqual

@Support
Condition lessOrEqual(Row7<T1,T2,T3,T4,T5,T6,T7> row)

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

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)

lessOrEqual

@Support
Condition lessOrEqual(Record7<T1,T2,T3,T4,T5,T6,T7> record)

Compare this row value expression with a record for order.

See Also:

lessOrEqual(Row7)

lessOrEqual

@Support
Condition lessOrEqual(T1 t1,
                      T2 t2,
                      T3 t3,
                      T4 t4,
                      T5 t5,
                      T6 t6,
                      T7 t7)

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

See Also:

lessOrEqual(Row7)

lessOrEqual

@Support
Condition lessOrEqual(Field<T1> t1,
                      Field<T2> t2,
                      Field<T3> t3,
                      Field<T4> t4,
                      Field<T5> t5,
                      Field<T6> t6,
                      Field<T7> t7)

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

See Also:

lessOrEqual(Row7)

lessOrEqual

@Support
Condition lessOrEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

lessOrEqual(Row7)

lessOrEqual

@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE})
Condition lessOrEqual(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

le

@Support
Condition le(Row7<T1,T2,T3,T4,T5,T6,T7> row)

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

See Also:

lessOrEqual(Row7)

le

@Support
Condition le(Record7<T1,T2,T3,T4,T5,T6,T7> record)

Compare this row value expression with a record for order.

See Also:

lessOrEqual(Row7)

le

@Support
Condition le(T1 t1,
             T2 t2,
             T3 t3,
             T4 t4,
             T5 t5,
             T6 t6,
             T7 t7)

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

See Also:

lessOrEqual(Row7)

le

@Support
Condition le(Field<T1> t1,
             Field<T2> t2,
             Field<T3> t3,
             Field<T4> t4,
             Field<T5> t5,
             Field<T6> t6,
             Field<T7> t7)

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

See Also:

lessOrEqual(Row7)

le

@Support
Condition le(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

lessOrEqual(Row7)

le

@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE})
Condition le(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

greaterThan

@Support
Condition greaterThan(Row7<T1,T2,T3,T4,T5,T6,T7> row)

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

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)

greaterThan

@Support
Condition greaterThan(Record7<T1,T2,T3,T4,T5,T6,T7> record)

Compare this row value expression with a record for order.

See Also:

greaterThan(Row7)

greaterThan

@Support
Condition greaterThan(T1 t1,
                      T2 t2,
                      T3 t3,
                      T4 t4,
                      T5 t5,
                      T6 t6,
                      T7 t7)

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

See Also:

greaterThan(Row7)

greaterThan

@Support
Condition greaterThan(Field<T1> t1,
                      Field<T2> t2,
                      Field<T3> t3,
                      Field<T4> t4,
                      Field<T5> t5,
                      Field<T6> t6,
                      Field<T7> t7)

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

See Also:

greaterThan(Row7)

greaterThan

@Support
Condition greaterThan(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

greaterThan(Row7)

greaterThan

@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE})
Condition greaterThan(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

gt

@Support
Condition gt(Row7<T1,T2,T3,T4,T5,T6,T7> row)

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

See Also:

greaterThan(Row7)

gt

@Support
Condition gt(Record7<T1,T2,T3,T4,T5,T6,T7> record)

Compare this row value expression with a record for order.

See Also:

greaterThan(Row7)

gt

@Support
Condition gt(T1 t1,
             T2 t2,
             T3 t3,
             T4 t4,
             T5 t5,
             T6 t6,
             T7 t7)

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

See Also:

greaterThan(Row7)

gt

@Support
Condition gt(Field<T1> t1,
             Field<T2> t2,
             Field<T3> t3,
             Field<T4> t4,
             Field<T5> t5,
             Field<T6> t6,
             Field<T7> t7)

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

See Also:

greaterThan(Row7)

gt

@Support
Condition gt(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

greaterThan(Row7)

gt

@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE})
Condition gt(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

greaterOrEqual

@Support
Condition greaterOrEqual(Row7<T1,T2,T3,T4,T5,T6,T7> row)

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

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)

greaterOrEqual

@Support
Condition greaterOrEqual(Record7<T1,T2,T3,T4,T5,T6,T7> record)

Compare this row value expression with a record for order.

See Also:

greaterOrEqual(Row7)

greaterOrEqual

@Support
Condition greaterOrEqual(T1 t1,
                         T2 t2,
                         T3 t3,
                         T4 t4,
                         T5 t5,
                         T6 t6,
                         T7 t7)

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

See Also:

greaterOrEqual(Row7)

greaterOrEqual

@Support
Condition greaterOrEqual(Field<T1> t1,
                         Field<T2> t2,
                         Field<T3> t3,
                         Field<T4> t4,
                         Field<T5> t5,
                         Field<T6> t6,
                         Field<T7> t7)

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

See Also:

greaterOrEqual(Row7)

greaterOrEqual

@Support
Condition greaterOrEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

greaterOrEqual(Row7)

greaterOrEqual

@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE})
Condition greaterOrEqual(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

ge

@Support
Condition ge(Row7<T1,T2,T3,T4,T5,T6,T7> row)

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

See Also:

greaterOrEqual(Row7)

ge

@Support
Condition ge(Record7<T1,T2,T3,T4,T5,T6,T7> record)

Compare this row value expression with a record for order.

See Also:

greaterOrEqual(Row7)

ge

@Support
Condition ge(T1 t1,
             T2 t2,
             T3 t3,
             T4 t4,
             T5 t5,
             T6 t6,
             T7 t7)

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

See Also:

greaterOrEqual(Row7)

ge

@Support
Condition ge(Field<T1> t1,
             Field<T2> t2,
             Field<T3> t3,
             Field<T4> t4,
             Field<T5> t5,
             Field<T6> t6,
             Field<T7> t7)

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

See Also:

greaterOrEqual(Row7)

ge

@Support
Condition ge(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

greaterOrEqual(Row7)

ge

@Support({ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,FIREBIRD,H2,HSQLDB,INGRES,POSTGRES,SYBASE})
Condition ge(QuantifiedSelect<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for order.

See Also:

DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)

between

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> between(T1 minValue1,
                                                                                  T2 minValue2,
                                                                                  T3 minValue3,
                                                                                  T4 minValue4,
                                                                                  T5 minValue5,
                                                                                  T6 minValue6,
                                                                                  T7 minValue7)

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

See Also:

between(Row7, Row7)

between

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> between(Field<T1> minValue1,
                                                                                  Field<T2> minValue2,
                                                                                  Field<T3> minValue3,
                                                                                  Field<T4> minValue4,
                                                                                  Field<T5> minValue5,
                                                                                  Field<T6> minValue6,
                                                                                  Field<T7> minValue7)

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

See Also:

between(Row7, Row7)

between

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> between(Row7<T1,T2,T3,T4,T5,T6,T7> minValue)

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

See Also:

between(Row7, Row7)

between

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> between(Record7<T1,T2,T3,T4,T5,T6,T7> minValue)

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

See Also:

between(Row7, Row7)

between

@Support
Condition between(Row7<T1,T2,T3,T4,T5,T6,T7> minValue,
                  Row7<T1,T2,T3,T4,T5,T6,T7> 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(Record7<T1,T2,T3,T4,T5,T6,T7> minValue,
                  Record7<T1,T2,T3,T4,T5,T6,T7> 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(Row7, Row7)

betweenSymmetric

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> betweenSymmetric(T1 minValue1,
                                                                                           T2 minValue2,
                                                                                           T3 minValue3,
                                                                                           T4 minValue4,
                                                                                           T5 minValue5,
                                                                                           T6 minValue6,
                                                                                           T7 minValue7)

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

See Also:

betweenSymmetric(Row7, Row7)

betweenSymmetric

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> betweenSymmetric(Field<T1> minValue1,
                                                                                           Field<T2> minValue2,
                                                                                           Field<T3> minValue3,
                                                                                           Field<T4> minValue4,
                                                                                           Field<T5> minValue5,
                                                                                           Field<T6> minValue6,
                                                                                           Field<T7> minValue7)

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

See Also:

betweenSymmetric(Row7, Row7)

betweenSymmetric

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> betweenSymmetric(Row7<T1,T2,T3,T4,T5,T6,T7> minValue)

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

See Also:

betweenSymmetric(Row7, Row7)

betweenSymmetric

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> betweenSymmetric(Record7<T1,T2,T3,T4,T5,T6,T7> minValue)

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

See Also:

betweenSymmetric(Row7, Row7)

betweenSymmetric

@Support
Condition betweenSymmetric(Row7<T1,T2,T3,T4,T5,T6,T7> minValue,
                           Row7<T1,T2,T3,T4,T5,T6,T7> 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(Record7<T1,T2,T3,T4,T5,T6,T7> minValue,
                           Record7<T1,T2,T3,T4,T5,T6,T7> 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(Row7, Row7)

notBetween

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> notBetween(T1 minValue1,
                                                                                     T2 minValue2,
                                                                                     T3 minValue3,
                                                                                     T4 minValue4,
                                                                                     T5 minValue5,
                                                                                     T6 minValue6,
                                                                                     T7 minValue7)

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

See Also:

between(Row7, Row7)

notBetween

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> notBetween(Field<T1> minValue1,
                                                                                     Field<T2> minValue2,
                                                                                     Field<T3> minValue3,
                                                                                     Field<T4> minValue4,
                                                                                     Field<T5> minValue5,
                                                                                     Field<T6> minValue6,
                                                                                     Field<T7> minValue7)

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

See Also:

notBetween(Row7, Row7)

notBetween

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> notBetween(Row7<T1,T2,T3,T4,T5,T6,T7> minValue)

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

See Also:

notBetween(Row7, Row7)

notBetween

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> notBetween(Record7<T1,T2,T3,T4,T5,T6,T7> minValue)

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

See Also:

notBetween(Row7, Row7)

notBetween

@Support
Condition notBetween(Row7<T1,T2,T3,T4,T5,T6,T7> minValue,
                     Row7<T1,T2,T3,T4,T5,T6,T7> 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(Record7<T1,T2,T3,T4,T5,T6,T7> minValue,
                     Record7<T1,T2,T3,T4,T5,T6,T7> 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(Row7, Row7)

notBetweenSymmetric

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> notBetweenSymmetric(T1 minValue1,
                                                                                              T2 minValue2,
                                                                                              T3 minValue3,
                                                                                              T4 minValue4,
                                                                                              T5 minValue5,
                                                                                              T6 minValue6,
                                                                                              T7 minValue7)

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

See Also:

notBetweenSymmetric(Row7, Row7)

notBetweenSymmetric

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> notBetweenSymmetric(Field<T1> minValue1,
                                                                                              Field<T2> minValue2,
                                                                                              Field<T3> minValue3,
                                                                                              Field<T4> minValue4,
                                                                                              Field<T5> minValue5,
                                                                                              Field<T6> minValue6,
                                                                                              Field<T7> minValue7)

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

See Also:

notBetweenSymmetric(Row7, Row7)

notBetweenSymmetric

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> notBetweenSymmetric(Row7<T1,T2,T3,T4,T5,T6,T7> minValue)

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

See Also:

notBetweenSymmetric(Row7, Row7)

notBetweenSymmetric

@Support
BetweenAndStep7<T1,T2,T3,T4,T5,T6,T7> notBetweenSymmetric(Record7<T1,T2,T3,T4,T5,T6,T7> minValue)

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

See Also:

notBetweenSymmetric(Row7, Row7)

notBetweenSymmetric

@Support
Condition notBetweenSymmetric(Row7<T1,T2,T3,T4,T5,T6,T7> minValue,
                              Row7<T1,T2,T3,T4,T5,T6,T7> 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(Record7<T1,T2,T3,T4,T5,T6,T7> minValue,
                              Record7<T1,T2,T3,T4,T5,T6,T7> 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(Row7, Row7)

in

@Support
Condition in(Collection<? extends Row7<T1,T2,T3,T4,T5,T6,T7>> rows)

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

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

Note that generating dynamic SQL with arbitrary-length IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• IN predicates on temporary tables
• IN predicates on unnested array bind variables

in

@Support
Condition in(Result<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> result)

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

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

Note that generating dynamic SQL with arbitrary-length IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• IN predicates on temporary tables
• IN predicates on unnested array bind variables

in

@Support
Condition in(Row7<T1,T2,T3,T4,T5,T6,T7>... rows)

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

Note that generating dynamic SQL with arbitrary-length IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• IN predicates on temporary tables
• IN predicates on unnested array bind variables

See Also:

in(Collection)

in

@Support
Condition in(Record7<T1,T2,T3,T4,T5,T6,T7>... record)

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

Note that generating dynamic SQL with arbitrary-length IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• IN predicates on temporary tables
• IN predicates on unnested array bind variables

See Also:

in(Collection)

in

@Support
Condition in(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

Compare this row value expression with a subselect for equality.

See Also:

in(Collection)

notIn

@Support
Condition notIn(Collection<? extends Row7<T1,T2,T3,T4,T5,T6,T7>> rows)

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

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

Note that generating dynamic SQL with arbitrary-length NOT IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• NOT IN predicates on temporary tables
• NOT IN predicates on unnested array bind variables

notIn

@Support
Condition notIn(Result<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> result)

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

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

Note that generating dynamic SQL with arbitrary-length NOT IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• NOT IN predicates on temporary tables
• NOT IN predicates on unnested array bind variables

notIn

@Support
Condition notIn(Row7<T1,T2,T3,T4,T5,T6,T7>... rows)

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

Note that generating dynamic SQL with arbitrary-length NOT IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• NOT IN predicates on temporary tables
• NOT IN predicates on unnested array bind variables

See Also:

notIn(Collection)

notIn

@Support
Condition notIn(Record7<T1,T2,T3,T4,T5,T6,T7>... record)

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

Note that generating dynamic SQL with arbitrary-length NOT IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:

• NOT IN predicates on temporary tables
• NOT IN predicates on unnested array bind variables

See Also:

notIn(Collection)

notIn

@Support
Condition notIn(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)

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

See Also:

notIn(Collection)