org.jooq

Interface RowN

All Superinterfaces:

Adapter, Attachable, QueryPart, Row, Serializable

public interface RowN
extends Row

A model type for a row value expression with degree N > 8

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<?>... values) 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(Object... values) 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(RowN 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(Field<?>... fields) 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(Object... values) 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(RowN 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	in(Collection<? extends RowN> 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(RowN... 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<?>... values) 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(Object... values) 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(RowN 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(Field<?>... values) 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(Object... values) 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(RowN 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	notIn(Collection<? extends RowN> 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(RowN... 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

equal

@Support
Condition equal(RowN 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(Object... values)

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<?>... fields)

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(RowN 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(Object... values)

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<?>... values)

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(RowN 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(Object... values)

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<?>... values)

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(RowN 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(Object... values)

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<?>... values)

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 RowN> 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(RowN... 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 RowN> 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(RowN... 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))