public interface Row1<T1> extends Row
1
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)
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(Row1<T1> 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)
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)
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(Row1<T1> 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)
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

Condition 
in(Collection<? extends Row1<T1>> row)
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(Row1<T1>... 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)
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(Row1<T1> 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)
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)
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(Row1<T1> 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)
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 Row1<T1>> row)
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(Row1<T1>... 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(Row1<T1> 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)
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)
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(Row1<T1> 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)
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)
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(Row1<T1> 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)
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)
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(Row1<T1> 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)
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)
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 Row1<T1>> row)
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(Row1<T1>... 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 Row1<T1>> row)
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(Row1<T1>... 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.