public interface Row5<T1,T2,T3,T4,T5> extends Row
5
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.
Modifier and Type  Method and Description 

Condition 
eq(Field<T1> t1,
Field<T2> t2,
Field<T3> t3,
Field<T4> t4,
Field<T5> t5)
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(Row5<T1,T2,T3,T4,T5> 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,
T5 t5)
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,
Field<T5> t5)
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(Row5<T1,T2,T3,T4,T5> 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,
T5 t5)
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

Field<T5> 
field5()
Get the fifth field

Condition 
in(Collection<? extends Row5<T1,T2,T3,T4,T5>> 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(Row5<T1,T2,T3,T4,T5>... 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,
Field<T5> t5)
Compare this row value expression with another row value expression for nonequality
Row nonequality 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(Row5<T1,T2,T3,T4,T5> row)
Compare this row value expression with another row value expression for nonequality
Row nonequality 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,
T5 t5)
Compare this row value expression with another row value expression for nonequality
Row nonequality 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,
Field<T5> t5)
Compare this row value expression with another row value expression for nonequality
Row nonequality 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(Row5<T1,T2,T3,T4,T5> row)
Compare this row value expression with another row value expression for nonequality
Row nonequality 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,
T5 t5)
Compare this row value expression with another row value expression for nonequality
Row nonequality 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 Row5<T1,T2,T3,T4,T5>> 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(Row5<T1,T2,T3,T4,T5>... 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)) 
internalAPI
@Support Condition equal(Row5<T1,T2,T3,T4,T5> row)
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
@Support Condition equal(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5)
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
@Support Condition equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5)
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
@Support Condition eq(Row5<T1,T2,T3,T4,T5> row)
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
@Support Condition eq(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5)
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
@Support Condition eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5)
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
@Support Condition notEqual(Row5<T1,T2,T3,T4,T5> row)
Row nonequality 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)
@Support Condition notEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5)
Row nonequality 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)
@Support Condition notEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5)
Row nonequality 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)
@Support Condition ne(Row5<T1,T2,T3,T4,T5> row)
Row nonequality 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)
@Support Condition ne(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5)
Row nonequality 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)
@Support Condition ne(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5)
Row nonequality 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)
@Support Condition in(Collection<? extends Row5<T1,T2,T3,T4,T5>> rows)
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)
@Support Condition in(Row5<T1,T2,T3,T4,T5>... rows)
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)
@Support Condition notIn(Collection<? extends Row5<T1,T2,T3,T4,T5>> rows)
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))
@Support Condition notIn(Row5<T1,T2,T3,T4,T5>... rows)
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))
Copyright © 2013. All Rights Reserved.