org.jooq

Interface Row4<T1,T2,T3,T4>

All Superinterfaces:

Adapter, Attachable, QueryPart, Row, Serializable

public interface Row4<T1,T2,T3,T4>
extends Row

A model type for a row value expression with degree 4

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

Author:

Lukas Eder

Method Summary

Methods

Modifier and Type	Method and Description
Condition	eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for equality Row equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) = (1, 2) is equivalent to A = 1 AND B = 2
Condition	eq(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for equality Row equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) = (1, 2) is equivalent to A = 1 AND B = 2
Condition	eq(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for equality Row equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) = (1, 2) is equivalent to A = 1 AND B = 2
Condition	equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for equality Row equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) = (1, 2) is equivalent to A = 1 AND B = 2
Condition	equal(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for equality Row equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) = (1, 2) is equivalent to A = 1 AND B = 2
Condition	equal(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for equality Row equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) = (1, 2) is equivalent to A = 1 AND B = 2
Field<T1>	field1() Get the first field
Field<T2>	field2() Get the second field
Field<T3>	field3() Get the third field
Field<T4>	field4() Get the fourth field
Condition	in(Collection<? extends Row4<T1,T2,T3,T4>> rows) Compare this row value expression with a set of row value expressions for equality Row IN predicates can be simulated in those databases that do not support such predicates natively: (A, B) IN ((1, 2), (3, 4)) is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
Condition	in(Row4<T1,T2,T3,T4>... rows) Compare this row value expression with a set of row value expressions for equality Row IN predicates can be simulated in those databases that do not support such predicates natively: (A, B) IN ((1, 2), (3, 4)) is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
Condition	ne(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for non-equality Row non-equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) <> (1, 2) is equivalent to NOT(A = 1 AND B = 2)
Condition	ne(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for non-equality Row non-equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) <> (1, 2) is equivalent to NOT(A = 1 AND B = 2)
Condition	ne(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for non-equality Row non-equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) <> (1, 2) is equivalent to NOT(A = 1 AND B = 2)
Condition	notEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4) Compare this row value expression with another row value expression for non-equality Row non-equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) <> (1, 2) is equivalent to NOT(A = 1 AND B = 2)
Condition	notEqual(Row4<T1,T2,T3,T4> row) Compare this row value expression with another row value expression for non-equality Row non-equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) <> (1, 2) is equivalent to NOT(A = 1 AND B = 2)
Condition	notEqual(T1 t1, T2 t2, T3 t3, T4 t4) Compare this row value expression with another row value expression for non-equality Row non-equality comparison predicates can be simulated in those databases that do not support such predicates natively: (A, B) <> (1, 2) is equivalent to NOT(A = 1 AND B = 2)
Condition	notIn(Collection<? extends Row4<T1,T2,T3,T4>> rows) Compare this row value expression with a set of row value expressions for equality Row NOT IN predicates can be simulated in those databases that do not support such predicates natively: (A, B) NOT IN ((1, 2), (3, 4)) is equivalent to NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
Condition	notIn(Row4<T1,T2,T3,T4>... rows) Compare this row value expression with a set of row value expressions for equality Row NOT IN predicates can be simulated in those databases that do not support such predicates natively: (A, B) NOT IN ((1, 2), (3, 4)) is equivalent to NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))

Methods inherited from interface org.jooq.Row

getDegree, getField, getFields, in, notIn

Methods inherited from interface org.jooq.QueryPart

attach

Methods inherited from interface org.jooq.Adapter

internalAPI

Method Detail

field1

Field<T1> field1()

Get the first field

field2

Field<T2> field2()

Get the second field

field3

Field<T3> field3()

Get the third field

field4

Field<T4> field4()

Get the fourth field

equal

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

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

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

equal

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

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

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

equal

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

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

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

eq

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

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

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

eq

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

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

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

eq

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

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

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

notEqual

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

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

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

notEqual

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

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

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

notEqual

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

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

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

ne

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

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

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

ne

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

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

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

ne

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

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

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

in

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

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

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

in

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

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

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

notIn

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

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

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

notIn

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

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

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