Uses of Interface
org.jooq.Record2

Packages that use Record2

Package	Description
org.jooq	The org.jooq package contains jOOQ's public API.
org.jooq.impl	The org.jooq.impl package contains jOOQ's implementation classes.

Uses of Record2 in org.jooq

Methods in org.jooq with type parameters of type Record2

Modifier and Type	Method and Description
<R extends Record2<?,?>> CommonTableExpression<R>	DerivedColumnList2.as(Select<R> select) Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

Methods in org.jooq that return Record2

Modifier and Type	Method and Description
<T1,T2> Record2<T1,T2>	Record.into(Field<T1> field1, Field<T2> field2) Copy this record into a new record holding only a subset of the previous fields.
<T1,T2> Record2<T1,T2>	DSLContext.newRecord(Field<T1> field1, Field<T2> field2) Create a new empty Record.
Record2<T1,T2>	Record2.value1(T1 value) Set the first value.
Record2<T1,T2>	Record2.value2(T2 value) Set the second value.
Record2<T1,T2>	Record2.values(T1 t1, T2 t2) Set all values.

Methods in org.jooq that return types with arguments of type Record2

Modifier and Type	Method and Description
<T1,T2> Result<Record2<T1,T2>>	Result.into(Field<T1> field1, Field<T2> field2) Copy all records from this result into a new result with new records holding only a subset of the previous fields.
<T1,T2> Result<Record2<T1,T2>>	DSLContext.newResult(Field<T1> field1, Field<T2> field2) Create a new empty Result.
<T1,T2> UpdateResultStep<Record2<T1,T2>>	UpdateReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2) Configure the UPDATE statement to return a list of fields in R.
<T1,T2> InsertResultStep<Record2<T1,T2>>	InsertReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2) Configure the INSERT statement to return a list of fields in R.
<T1,T2> DeleteResultStep<Record2<T1,T2>>	DeleteReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2) Configure the DELETE statement to return a list of fields in R.
<T1,T2> SelectSelectStep<Record2<T1,T2>>	WithStep.select(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL select statement.
<T1,T2> SelectSelectStep<Record2<T1,T2>>	DSLContext.select(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL select statement.
<T1,T2> SelectSelectStep<Record2<T1,T2>>	WithStep.selectDistinct(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL select statement.
<T1,T2> SelectSelectStep<Record2<T1,T2>>	DSLContext.selectDistinct(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL select statement.

Methods in org.jooq with parameters of type Record2

Modifier and Type	Method and Description
Condition	BetweenAndStep2.and(Record2<T1,T2> maxValue) Create a condition to check this field against some bounds
BetweenAndStep2<T1,T2>	Row2.between(Record2<T1,T2> minValue) Check if this row value expression is within a range of two records.
Condition	Row2.between(Record2<T1,T2> minValue, Record2<T1,T2> maxValue) Check if this row value expression is within a range of two records.
Condition	Row2.between(Record2<T1,T2> minValue, Record2<T1,T2> maxValue) Check if this row value expression is within a range of two records.
BetweenAndStep2<T1,T2>	Row2.betweenSymmetric(Record2<T1,T2> minValue) Check if this row value expression is within a symmetric range of two records.
Condition	Row2.betweenSymmetric(Record2<T1,T2> minValue, Record2<T1,T2> maxValue) Check if this row value expression is within a symmetric range of two records.
Condition	Row2.betweenSymmetric(Record2<T1,T2> minValue, Record2<T1,T2> maxValue) Check if this row value expression is within a symmetric range of two records.
Condition	Row2.compare(Comparator comparator, Record2<T1,T2> record) Compare this row value expression with a record using a dynamic comparator.
Condition	Row2.eq(Record2<T1,T2> record) Compare this row value expression with a record for equality.
Condition	Row2.equal(Record2<T1,T2> record) Compare this row value expression with a record for equality.
Condition	Row2.ge(Record2<T1,T2> record) Compare this row value expression with a record for order.
Condition	Row2.greaterOrEqual(Record2<T1,T2> record) Compare this row value expression with a record for order.
Condition	Row2.greaterThan(Record2<T1,T2> record) Compare this row value expression with a record for order.
Condition	Row2.gt(Record2<T1,T2> record) Compare this row value expression with a record for order.
Condition	Row2.in(Record2<T1,T2>... record) Compare this row value expression with a set of records for equality.
Condition	Row2.isDistinctFrom(Record2<T1,T2> record) Compare this row value expression with another row value expression for distinctness.
Condition	Row2.isNotDistinctFrom(Record2<T1,T2> record) Compare this row value expression with another row value expression for distinctness.
Condition	Row2.le(Record2<T1,T2> record) Compare this row value expression with a record for order.
Condition	Row2.lessOrEqual(Record2<T1,T2> record) Compare this row value expression with a record for order.
Condition	Row2.lessThan(Record2<T1,T2> record) Compare this row value expression with a record for order.
Condition	Row2.lt(Record2<T1,T2> record) Compare this row value expression with a record for order.
Condition	Row2.ne(Record2<T1,T2> record) Compare this row value expression with a record for non-equality.
BetweenAndStep2<T1,T2>	Row2.notBetween(Record2<T1,T2> minValue) Check if this row value expression is within a range of two records.
Condition	Row2.notBetween(Record2<T1,T2> minValue, Record2<T1,T2> maxValue) Check if this row value expression is within a range of two records.
Condition	Row2.notBetween(Record2<T1,T2> minValue, Record2<T1,T2> maxValue) Check if this row value expression is within a range of two records.
BetweenAndStep2<T1,T2>	Row2.notBetweenSymmetric(Record2<T1,T2> minValue) Check if this row value expression is not within a symmetric range of two records.
Condition	Row2.notBetweenSymmetric(Record2<T1,T2> minValue, Record2<T1,T2> maxValue) Check if this row value expression is not within a symmetric range of two records.
Condition	Row2.notBetweenSymmetric(Record2<T1,T2> minValue, Record2<T1,T2> maxValue) Check if this row value expression is not within a symmetric range of two records.
Condition	Row2.notEqual(Record2<T1,T2> record) Compare this row value expression with a record for non-equality
Condition	Row2.notIn(Record2<T1,T2>... record) Compare this row value expression with a set of records for non-equality.

Method parameters in org.jooq with type arguments of type Record2

Modifier and Type	Method and Description
<T1,T2> void	UpdateQuery.addValues(Row2<T1,T2> row, Select<? extends Record2<T1,T2>> select) Specify a multi-column set clause for the UPDATE statement.
WithStep	WithAsStep2.as(Select<? extends Record2<?,?>> select) Associate a subselect with a common table expression's table and column names.
Condition	Row2.compare(Comparator comparator, QuantifiedSelect<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row2.compare(Comparator comparator, Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row2.eq(QuantifiedSelect<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for equality.
Condition	Row2.eq(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for equality.
Condition	Row2.equal(QuantifiedSelect<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for equality.
Condition	Row2.equal(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for equality.
Condition	Row2.ge(QuantifiedSelect<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.ge(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.greaterOrEqual(QuantifiedSelect<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.greaterOrEqual(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.greaterThan(QuantifiedSelect<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.greaterThan(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.gt(QuantifiedSelect<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.gt(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.in(Result<? extends Record2<T1,T2>> result) Compare this row value expression with a set of records for equality.
Condition	Row2.in(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for equality.
Condition	Row2.le(QuantifiedSelect<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.le(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.lessOrEqual(QuantifiedSelect<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.lessOrEqual(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.lessThan(QuantifiedSelect<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.lessThan(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.lt(QuantifiedSelect<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.lt(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row2.ne(QuantifiedSelect<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row2.ne(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row2.notEqual(QuantifiedSelect<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row2.notEqual(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row2.notIn(Result<? extends Record2<T1,T2>> result) Compare this row value expression with a set of records for equality.
Condition	Row2.notIn(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for non-equality.
Merge<R>	MergeValuesStep2.select(Select<? extends Record2<T1,T2>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
InsertOnDuplicateStep<R>	InsertValuesStep2.select(Select<? extends Record2<T1,T2>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
<T1,T2> UpdateFromStep<R>	UpdateSetFirstStep.set(Row2<T1,T2> row, Select<? extends Record2<T1,T2>> select) Specify a multi-column set clause for the UPDATE statement.

Uses of Record2 in org.jooq.impl

Methods in org.jooq.impl that return Record2

Modifier and Type	Method and Description
<T1,T2> Record2<T1,T2>	DefaultDSLContext.newRecord(Field<T1> field1, Field<T2> field2)

Methods in org.jooq.impl that return types with arguments of type Record2

Modifier and Type	Method and Description
<T1,T2> Result<Record2<T1,T2>>	DefaultDSLContext.newResult(Field<T1> field1, Field<T2> field2)
static <T1,T2> RecordType<Record2<T1,T2>>	DSL.recordType(Field<T1> field1, Field<T2> field2) Create a RecordType of degree 2.
static <T1,T2> Field<Record2<T1,T2>>	DSL.rowField(Row2<T1,T2> row) EXPERIMENTAL: Turn a row value expression of degree 2 into a Field.
static <T1,T2> SelectSelectStep<Record2<T1,T2>>	DSL.select(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL subselect statement.
<T1,T2> SelectSelectStep<Record2<T1,T2>>	DefaultDSLContext.select(SelectField<T1> field1, SelectField<T2> field2)
static <T1,T2> SelectSelectStep<Record2<T1,T2>>	DSL.selectDistinct(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL subselect statement.
<T1,T2> SelectSelectStep<Record2<T1,T2>>	DefaultDSLContext.selectDistinct(SelectField<T1> field1, SelectField<T2> field2)
static <T1,T2> Table<Record2<T1,T2>>	DSL.values(Row2<T1,T2>... rows) Create a VALUES() expression of degree 2.