- All Superinterfaces:
FieldOrRow
,Fields
,Named
,QueryPart
,Row
,SelectField<Record6<T1,
,T2, T3, T4, T5, T6>> SelectFieldOrAsterisk
,Serializable
,Typed<Record6<T1,
T2, T3, T4, T5, T6>>
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 TypeMethodDescriptionbetween
(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6) Check if this row value expression is within a range of two other row value expressions.Check if this row value expression is within a range of two records.@NotNull Condition
Check if this row value expression is within a range of two records.Check if this row value expression is within a range of two other row value expressions.@NotNull Condition
Check if this row value expression is within a range of two other row value expressions.Check if this row value expression is within a range of two other row value expressions.betweenSymmetric
(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6) Check if this row value expression is within a symmetric range of two other row value expressions.Check if this row value expression is within a symmetric range of two records.@NotNull Condition
Check if this row value expression is within a symmetric range of two records.Check if this row value expression is within a symmetric range of two other row value expressions.@NotNull Condition
Check if this row value expression is within a symmetric range of two other row value expressions.betweenSymmetric
(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6) Check if this row value expression is within a symmetric range of two other row value expressions.@NotNull Condition
compare
(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression using a dynamic comparator.@NotNull Condition
compare
(Comparator comparator, QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Compare this row value expression with a record using a dynamic comparator.@NotNull Condition
Compare this row value expression with another row value expression using a dynamic comparator.@NotNull Condition
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Compare this row value expression with another row value expression using a dynamic comparator.@NotNull Condition
Compare this row value expression with another row value expression for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a record for equality.@NotNull Condition
Compare this row value expression with another row value expression for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with another row value expression for equality.@NotNull Condition
Compare this row value expression with another row value expression for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a record for equality.@NotNull Condition
Compare this row value expression with another row value expression for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with another row value expression for equality.field1()
Get the first field.field2()
Get the second field.field3()
Get the third field.field4()
Get the fourth field.field5()
Get the fifth field.field6()
Get the sixth field.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
greaterOrEqual
(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
greaterThan
(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a set of row value expressions for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of row value expressions for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
isNotDistinctFrom
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
lessOrEqual
(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with another row value expression for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with another row value expression for order.<U> @NotNull SelectField<U>
mapping
(Class<U> uType, Function6<? super T1, ? super T2, ? super T3, ? super T4, ? super T5, ? super T6, ? extends U> function) A convenience method to define a localRecord6
to custom typeRecordMapper
that can be used when projectingRow
types inSELECT
orRETURNING
clauses.<U> @NotNull SelectField<U>
mapping
(Function6<? super T1, ? super T2, ? super T3, ? super T4, ? super T5, ? super T6, ? extends U> function) A convenience method to define a localRecord6
to custom typeRecordMapper
that can be used when projectingRow
types inSELECT
orRETURNING
clauses.@NotNull Condition
Compare this row value expression with another row value expression for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a record for non-equality.@NotNull Condition
Compare this row value expression with another row value expression for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with another row value expression for non-equality.notBetween
(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6) Check if this row value expression is not within a range of two other row value expressions.Check if this row value expression is within a range of two records.@NotNull Condition
Check if this row value expression is within a range of two records.Check if this row value expression is not within a range of two other row value expressions.@NotNull Condition
Check if this row value expression is not within a range of two other row value expressions.Check if this row value expression is not within a range of two other row value expressions.notBetweenSymmetric
(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6) Check if this row value expression is not within a symmetric range of two other row value expressions.Check if this row value expression is not within a symmetric range of two records.@NotNull Condition
Check if this row value expression is not within a symmetric range of two records.Check if this row value expression is not within a symmetric range of two other row value expressions.@NotNull Condition
Check if this row value expression is not within a symmetric range of two other row value expressions.notBetweenSymmetric
(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6) Check if this row value expression is not within a symmetric range of two other row value expressions.@NotNull Condition
Compare this row value expression with another row value expression for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a record for non-equality@NotNull Condition
Compare this row value expression with another row value expression for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with another row value expression for.@NotNull Condition
Compare this row value expression with a set of row value expressions for equality.@NotNull Condition
Compare this row value expression with a set of records for non-equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of row value expressions for equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.Methods inherited from interface org.jooq.Fields
dataType, dataType, dataType, dataTypes, field, field, field, field, field, field, field, field, field, field, fields, fields, fields, fields, fields, fieldsRow, fieldStream, indexOf, indexOf, indexOf, type, type, type, types
Methods inherited from interface org.jooq.Named
$name, getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedName
Methods inherited from interface org.jooq.QueryPart
$replace, $replace, $traverse, $traverse, equals, hashCode, toString
Methods inherited from interface org.jooq.SelectField
as, as, as
Methods inherited from interface org.jooq.Typed
$dataType, getBinding, getConverter, getDataType, getDataType, getType
-
Method Details
-
mapping
@NotNull @Internal <U> @NotNull SelectField<U> mapping(Function6<? super T1, ? super T2, ? super T3, ? super T4, ? super T5, ? super T6, ? extends U> function) A convenience method to define a localRecord6
to custom typeRecordMapper
that can be used when projectingRow
types inSELECT
orRETURNING
clauses.EXPERIMENTAL. Unlike
mapping(Class, Function6)
, this method attempts to work without an explicitClass
reference for the underlyingConverter.toType()
. There may be some edge cases where this doesn't work. Please report any bugs here: https://github.com/jOOQ/jOOQ/issues/new/chooseCombine this with e.g.
Functions.nullOnAllNull(Function6)
orFunctions.nullOnAnyNull(Function6)
to achievenull
safety when mapping nested rows fromLEFT JOIN
etc.Known issues include:
- When nesting rows in arrays, the class literal is required for reflective array creation.
-
mapping
@NotNull <U> @NotNull SelectField<U> mapping(Class<U> uType, Function6<? super T1, ? super T2, ? super T3, ? super T4, ? super T5, ? super T6, ? extends U> function) A convenience method to define a localRecord6
to custom typeRecordMapper
that can be used when projectingRow
types inSELECT
orRETURNING
clauses.Combine this with e.g.
Functions.nullOnAllNull(Function6)
orFunctions.nullOnAnyNull(Function6)
to achievenull
safety when mapping nested rows fromLEFT JOIN
etc. -
field1
Get the first field. -
field2
Get the second field. -
field3
Get the third field. -
field4
Get the fourth field. -
field5
Get the fifth field. -
field6
Get the sixth field. -
compare
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 -
compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, Record6<T1, T2, T3, T4, T5, T6> 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 -
compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6) 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 -
compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) 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 -
compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, Select<? extends Record6<T1, T2, T3, T4, T5, T6>> 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 -
compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> 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 -
equal
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 toA = 1 AND B = 2
-
equal
Compare this row value expression with a record for equality.- See Also:
-
equal
Compare this row value expression with another row value expression for equality.- See Also:
-
equal
@NotNull @Support @NotNull Condition equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for equality.- See Also:
-
equal
Compare this row value expression with a subselect for equality.- See Also:
-
equal
@NotNull @Support @NotNull Condition equal(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for equality. -
eq
Compare this row value expression with another row value expression for equality.- See Also:
-
eq
Compare this row value expression with a record for equality.- See Also:
-
eq
Compare this row value expression with another row value expression for equality.- See Also:
-
eq
@NotNull @Support @NotNull Condition eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for equality.- See Also:
-
eq
Compare this row value expression with a subselect for equality.- See Also:
-
eq
@NotNull @Support @NotNull Condition eq(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for equality. -
notEqual
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 toNOT(A = 1 AND B = 2)
-
notEqual
Compare this row value expression with a record for non-equality- See Also:
-
notEqual
Compare this row value expression with another row value expression for. non-equality- See Also:
-
notEqual
@NotNull @Support @NotNull Condition notEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for non-equality.- See Also:
-
notEqual
Compare this row value expression with a subselect for non-equality.- See Also:
-
notEqual
@NotNull @Support @NotNull Condition notEqual(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for non-equality. -
ne
Compare this row value expression with another row value expression for non-equality.- See Also:
-
ne
Compare this row value expression with a record for non-equality.- See Also:
-
ne
Compare this row value expression with another row value expression for non-equality.- See Also:
-
ne
@NotNull @Support @NotNull Condition ne(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for non-equality.- See Also:
-
ne
Compare this row value expression with a subselect for non-equality.- See Also:
-
ne
@NotNull @Support @NotNull Condition ne(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for non-equality. -
isDistinctFrom
Compare this row value expression with another row value expression for distinctness. -
isDistinctFrom
Compare this row value expression with another row value expression for distinctness. -
isDistinctFrom
Compare this row value expression with another row value expression for distinctness. -
isDistinctFrom
@NotNull @Support @NotNull Condition isDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for distinctness. -
isDistinctFrom
@NotNull @Support @NotNull Condition isDistinctFrom(Select<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with another row value expression for distinctness. -
isNotDistinctFrom
Compare this row value expression with another row value expression for distinctness. -
isNotDistinctFrom
Compare this row value expression with another row value expression for distinctness. -
isNotDistinctFrom
Compare this row value expression with another row value expression for distinctness. -
isNotDistinctFrom
@NotNull @Support @NotNull Condition isNotDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for distinctness. -
isNotDistinctFrom
@NotNull @Support @NotNull Condition isNotDistinctFrom(Select<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with another row value expression for distinctness. -
lessThan
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 toA < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3)
-
lessThan
Compare this row value expression with a record for order.- See Also:
-
lessThan
Compare this row value expression with another row value expression for order.- See Also:
-
lessThan
@NotNull @Support @NotNull Condition lessThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for order.- See Also:
-
lessThan
Compare this row value expression with a subselect for order.- See Also:
-
lessThan
@NotNull @Support @NotNull Condition lessThan(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order. -
lt
Compare this row value expression with another row value expression for order.- See Also:
-
lt
Compare this row value expression with a record for order.- See Also:
-
lt
Compare this row value expression with another row value expression for order.- See Also:
-
lt
@NotNull @Support @NotNull Condition lt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for order.- See Also:
-
lt
Compare this row value expression with a subselect for order.- See Also:
-
lt
@NotNull @Support @NotNull Condition lt(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order. -
lessOrEqual
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 toA < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2)
-
lessOrEqual
Compare this row value expression with a record for order.- See Also:
-
lessOrEqual
Compare this row value expression with another row value expression for order.- See Also:
-
lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for order.- See Also:
-
lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(Select<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order.- See Also:
-
lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order. -
le
Compare this row value expression with another row value expression for order.- See Also:
-
le
Compare this row value expression with a record for order.- See Also:
-
le
Compare this row value expression with another row value expression for order.- See Also:
-
le
@NotNull @Support @NotNull Condition le(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for order.- See Also:
-
le
Compare this row value expression with a subselect for order.- See Also:
-
le
@NotNull @Support @NotNull Condition le(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order. -
greaterThan
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 toA > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3)
-
greaterThan
Compare this row value expression with a record for order.- See Also:
-
greaterThan
Compare this row value expression with another row value expression for order.- See Also:
-
greaterThan
@NotNull @Support @NotNull Condition greaterThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for order.- See Also:
-
greaterThan
@NotNull @Support @NotNull Condition greaterThan(Select<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order.- See Also:
-
greaterThan
@NotNull @Support @NotNull Condition greaterThan(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order. -
gt
Compare this row value expression with another row value expression for order.- See Also:
-
gt
Compare this row value expression with a record for order.- See Also:
-
gt
Compare this row value expression with another row value expression for order.- See Also:
-
gt
@NotNull @Support @NotNull Condition gt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for order.- See Also:
-
gt
Compare this row value expression with a subselect for order.- See Also:
-
gt
@NotNull @Support @NotNull Condition gt(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order. -
greaterOrEqual
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 toA > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2)
-
greaterOrEqual
Compare this row value expression with a record for order.- See Also:
-
greaterOrEqual
Compare this row value expression with another row value expression for order.- See Also:
-
greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for order.- See Also:
-
greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(Select<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order.- See Also:
-
greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order. -
ge
Compare this row value expression with another row value expression for order.- See Also:
-
ge
Compare this row value expression with a record for order.- See Also:
-
ge
Compare this row value expression with another row value expression for order.- See Also:
-
ge
@NotNull @Support @NotNull Condition ge(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Compare this row value expression with another row value expression for order.- See Also:
-
ge
Compare this row value expression with a subselect for order.- See Also:
-
ge
@NotNull @Support @NotNull Condition ge(QuantifiedSelect<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Compare this row value expression with a subselect for order. -
between
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, betweenT3, T4, T5, T6> (T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6) Check if this row value expression is within a range of two other row value expressions.- See Also:
-
between
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, betweenT3, T4, T5, T6> (Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6) Check if this row value expression is within a range of two other row value expressions.- See Also:
-
between
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, betweenT3, T4, T5, T6> (Row6<T1, T2, T3, T4, T5, T6> minValue) Check if this row value expression is within a range of two other row value expressions.- See Also:
-
between
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, betweenT3, T4, T5, T6> (Record6<T1, T2, T3, T4, T5, T6> minValue) Check if this row value expression is within a range of two records.- See Also:
-
between
@NotNull @Support @NotNull Condition between(Row6<T1, T2, T3, T4, T5, T6> minValue, Row6<T1, T2, T3, T4, T5, T6> 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 expressionA >= B AND A <= C
for those SQL dialects that do not properly support theBETWEEN
predicate for row value expressions -
between
@NotNull @Support @NotNull Condition between(Record6<T1, T2, T3, T4, T5, T6> minValue, Record6<T1, T2, T3, T4, T5, T6> 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:
-
betweenSymmetric
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, betweenSymmetricT3, T4, T5, T6> (T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6) Check if this row value expression is within a symmetric range of two other row value expressions.- See Also:
-
betweenSymmetric
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, betweenSymmetricT3, T4, T5, T6> (Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6) Check if this row value expression is within a symmetric range of two other row value expressions.- See Also:
-
betweenSymmetric
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, betweenSymmetricT3, T4, T5, T6> (Row6<T1, T2, T3, T4, T5, T6> minValue) Check if this row value expression is within a symmetric range of two other row value expressions.- See Also:
-
betweenSymmetric
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, betweenSymmetricT3, T4, T5, T6> (Record6<T1, T2, T3, T4, T5, T6> minValue) Check if this row value expression is within a symmetric range of two records.- See Also:
-
betweenSymmetric
@NotNull @Support @NotNull Condition betweenSymmetric(Row6<T1, T2, T3, T4, T5, T6> minValue, Row6<T1, T2, T3, T4, T5, T6> 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 theBETWEEN
predicate for row value expressions -
betweenSymmetric
@NotNull @Support @NotNull Condition betweenSymmetric(Record6<T1, T2, T3, T4, T5, T6> minValue, Record6<T1, T2, T3, T4, T5, T6> 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:
-
notBetween
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, notBetweenT3, T4, T5, T6> (T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6) Check if this row value expression is not within a range of two other row value expressions.- See Also:
-
notBetween
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, notBetweenT3, T4, T5, T6> (Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6) Check if this row value expression is not within a range of two other row value expressions.- See Also:
-
notBetween
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, notBetweenT3, T4, T5, T6> (Row6<T1, T2, T3, T4, T5, T6> minValue) Check if this row value expression is not within a range of two other row value expressions.- See Also:
-
notBetween
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, notBetweenT3, T4, T5, T6> (Record6<T1, T2, T3, T4, T5, T6> minValue) Check if this row value expression is within a range of two records.- See Also:
-
notBetween
@NotNull @Support @NotNull Condition notBetween(Row6<T1, T2, T3, T4, T5, T6> minValue, Row6<T1, T2, T3, T4, T5, T6> 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 expressionA < B OR A > C
for those SQL dialects that do not properly support theBETWEEN
predicate for row value expressions -
notBetween
@NotNull @Support @NotNull Condition notBetween(Record6<T1, T2, T3, T4, T5, T6> minValue, Record6<T1, T2, T3, T4, T5, T6> 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:
-
notBetweenSymmetric
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, notBetweenSymmetricT3, T4, T5, T6> (T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6) Check if this row value expression is not within a symmetric range of two other row value expressions.- See Also:
-
notBetweenSymmetric
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, notBetweenSymmetricT3, T4, T5, T6> (Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6) Check if this row value expression is not within a symmetric range of two other row value expressions.- See Also:
-
notBetweenSymmetric
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, notBetweenSymmetricT3, T4, T5, T6> (Row6<T1, T2, T3, T4, T5, T6> minValue) Check if this row value expression is not within a symmetric range of two other row value expressions.- See Also:
-
notBetweenSymmetric
@NotNull @Support @NotNull BetweenAndStep6<T1,T2, notBetweenSymmetricT3, T4, T5, T6> (Record6<T1, T2, T3, T4, T5, T6> minValue) Check if this row value expression is not within a symmetric range of two records.- See Also:
-
notBetweenSymmetric
@NotNull @Support @NotNull Condition notBetweenSymmetric(Row6<T1, T2, T3, T4, T5, T6> minValue, Row6<T1, T2, T3, T4, T5, T6> 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 theBETWEEN
predicate for row value expressions -
notBetweenSymmetric
@NotNull @Support @NotNull Condition notBetweenSymmetric(Record6<T1, T2, T3, T4, T5, T6> minValue, Record6<T1, T2, T3, T4, T5, T6> 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:
-
in
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables
-
in
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables
-
in
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables
-
in
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables
- See Also:
-
in
Compare this row value expression with a subselect for equality.- See Also:
-
notIn
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 toNOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4)))
, which is equivalent toNOT((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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables
-
notIn
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 toNOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4)))
, which is equivalent toNOT((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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables
-
notIn
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables
-
notIn
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables
- See Also:
-
notIn
Compare this row value expression with a subselect for non-equality.- See Also:
-
set
@NotNull @Support({AURORA_POSTGRES,DB2,EXASOL,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,YUGABYTEDB}) @NotNull Statement set(Row6<T1, T2, T3, T4, T5, T6> row) Assign a value to this set of variables. -
set
@NotNull @Support({AURORA_POSTGRES,DB2,EXASOL,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,YUGABYTEDB}) @NotNull Statement set(Record6<T1, T2, T3, T4, T5, T6> record) Assign a value to this set of variables. -
set
@NotNull @Support({AURORA_POSTGRES,DB2,EXASOL,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,YUGABYTEDB}) @NotNull Statement set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6) Assign a value to this set of variables. -
set
@NotNull @Support({AURORA_POSTGRES,DB2,EXASOL,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,YUGABYTEDB}) @NotNull Statement set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6) Assign a value to this set of variables. -
set
@NotNull @Support({AURORA_POSTGRES,DB2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,YUGABYTEDB}) @NotNull Statement set(Select<? extends Record6<T1, T2, T3, T4, T5, T6>> value) Assign a value to this set of variables.
-