Uses of Interface
org.jooq.Record2

Packages that use Record2

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This 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	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	Description
<T1,T2> Record2<T1,T2>	DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2)	Execute and return exactly one record for
<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	Description
<T1,T2> ResultQuery<Record2<T1,T2>>	ResultQuery.coerce(Field<T1> field1, Field<T2> field2)	Coerce the result record type of this query to that of a set of fields.
<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> 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> 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> 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> 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.select(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.
<T1,T2> SelectSelectStep<Record2<T1,T2>>	WithStep.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	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.
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.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.
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.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	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.
InsertOnDuplicateStep<R>	InsertValuesStep2.select(Select<? extends Record2<T1,T2>> select)	Use a SELECT statement as the source of values for the INSERT statement
Merge<R>	MergeValuesStep2.select(Select<? extends Record2<T1,T2>> select)	Use a SELECT statement as the source of values for the MERGE statement
<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	Description
<T1,T2> Record2<T1,T2>	DefaultDSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2)
<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	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.
<T1,T2> SelectSelectStep<Record2<T1,T2>>	DefaultDSLContext.select(SelectField<T1> field1, SelectField<T2> field2)
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.selectDistinct(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.
static <T1,T2> Table<Record2<T1,T2>>	DSL.values(Row2<T1,T2>... rows)	Create a VALUES() expression of degree 2.