Uses of Interface
org.jooq.Record1

Packages that use Record1

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.
org.jooq.util.postgres	The org.jooq.util.ase package contains classes related to the SQLDialect.POSTGRES dialect.

Uses of Record1 in org.jooq

Methods in org.jooq with type parameters of type Record1

Modifier and Type	Method	Description
<R extends Record1<?>> CommonTableExpression<R>	DerivedColumnList1.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<T,R extends Record1<T>> Optional<T>	DSLContext.fetchOptionalValue(ResultQuery<R> query)	Execute a ResultQuery in the context of this DSLContext and return a single value.
<T,R extends Record1<T>> T	DSLContext.fetchValue(ResultQuery<R> query)	Execute a ResultQuery in the context of this DSLContext and return a single value.
<T,R extends Record1<T>> List<T>	DSLContext.fetchValues(ResultQuery<R> query)	Execute a ResultQuery in the context of this DSLContext and return all values for the only column.

Methods in org.jooq that return Record1

Modifier and Type	Method	Description
<T1> Record1<T1>	DSLContext.fetchSingle(SelectField<T1> field1)	Execute and return exactly one record for
Record1<T>	Field.from(Record record)	The inverse operation of Record.into(Field).
<T1> Record1<T1>	Record.into(Field<T1> field1)	Copy this record into a new record holding only a subset of the previous fields.
<T1> Record1<T1>	DSLContext.newRecord(Field<T1> field1)	Create a new empty Record.
Record1<T1>	Record1.value1(T1 value)	Set the first value.
Record1<T1>	Record1.values(T1 t1)	Set all values.

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

Modifier and Type	Method	Description
<T1> ResultQuery<Record1<T1>>	ResultQuery.coerce(Field<T1> field1)	Coerce the result record type of this query to that of a set of fields.
<T1> Result<Record1<T1>>	Result.into(Field<T1> field1)	Copy all records from this result into a new result with new records holding only a subset of the previous fields.
<T1> Result<Record1<T1>>	DSLContext.newResult(Field<T1> field1)	Create a new empty Result.
<T1> DeleteResultStep<Record1<T1>>	DeleteReturningStep.returningResult(SelectField<T1> field1)	Configure the DELETE statement to return a list of fields in R.
<T1> InsertResultStep<Record1<T1>>	InsertReturningStep.returningResult(SelectField<T1> field1)	Configure the INSERT statement to return a list of fields in R.
<T1> UpdateResultStep<Record1<T1>>	UpdateReturningStep.returningResult(SelectField<T1> field1)	Configure the UPDATE statement to return a list of fields in R.
<T1> SelectSelectStep<Record1<T1>>	DSLContext.select(SelectField<T1> field1)	Create a new DSL select statement.
<T1> SelectSelectStep<Record1<T1>>	WithStep.select(SelectField<T1> field1)	Create a new DSL select statement.
SelectSelectStep<Record1<Integer>>	DSLContext.selectCount()	Create a new DSL select statement for COUNT(*).
SelectSelectStep<Record1<Integer>>	WithStep.selectCount()	Create a new DSL select statement for COUNT(*).
<T1> SelectSelectStep<Record1<T1>>	DSLContext.selectDistinct(SelectField<T1> field1)	Create a new DSL select statement.
<T1> SelectSelectStep<Record1<T1>>	WithStep.selectDistinct(SelectField<T1> field1)	Create a new DSL select statement.
SelectSelectStep<Record1<Integer>>	DSLContext.selectOne()	Create a new DSL select statement for a constant 1 literal.
SelectSelectStep<Record1<Integer>>	WithStep.selectOne()	Create a new DSL select statement for a constant 1 literal.
SelectSelectStep<Record1<Integer>>	DSLContext.selectZero()	Create a new DSL select statement for a constant 0 literal.
SelectSelectStep<Record1<Integer>>	WithStep.selectZero()	Create a new DSL select statement for a constant 0 literal.

Methods in org.jooq with parameters of type Record1

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

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

Modifier and Type	Method	Description
<T1> void	UpdateQuery.addValues(Row1<T1> row, Select<? extends Record1<T1>> select)	Specify a multi-column set clause for the UPDATE statement.
WithStep	WithAsStep1.as(Select<? extends Record1<?>> select)	Associate a subselect with a common table expression's table and column names.
Condition	Field.compare(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query)	Compare this field with a quantified subselect using a dynamic comparator.
Condition	Field.compare(Comparator comparator, Select<? extends Record1<T>> query)	Compare this field with a subselect using a dynamic comparator.
Condition	Row1.compare(Comparator comparator, QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row1.compare(Comparator comparator, Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect using a dynamic comparator.
Field<T>	CaseConditionStep.else_(Select<? extends Record1<T>> result)	Add an else clause to the already constructed case statement
Condition	Field.eq(QuantifiedSelect<? extends Record1<T>> query)	this = [quantifier] (Select<?> ...).
Condition	Field.eq(Select<? extends Record1<T>> query)	this = (Select<?> ...).
Condition	Row1.eq(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for equality.
Condition	Row1.eq(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for equality.
Condition	Field.equal(QuantifiedSelect<? extends Record1<T>> query)	this = [quantifier] (Select<?> ...).
Condition	Field.equal(Select<? extends Record1<T>> query)	this = (Select<?> ...).
Condition	Row1.equal(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for equality.
Condition	Row1.equal(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for equality.
<T> T	DSLContext.fetchValue(Table<? extends Record1<T>> table)	Fetch a single value from a single column table.
<T> List<T>	DSLContext.fetchValues(Table<? extends Record1<T>> table)	Fetch all values from a single column table.
Condition	Field.ge(QuantifiedSelect<? extends Record1<T>> query)	this >= [quantifier] (Select<?> ...).
Condition	Field.ge(Select<? extends Record1<T>> query)	this >= (Select<?> ...).
Condition	Row1.ge(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Row1.ge(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Field.greaterOrEqual(QuantifiedSelect<? extends Record1<T>> query)	this >= [quantifier] (Select<?> ...).
Condition	Field.greaterOrEqual(Select<? extends Record1<T>> query)	this >= (Select<?> ...).
Condition	Row1.greaterOrEqual(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Row1.greaterOrEqual(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Field.greaterThan(QuantifiedSelect<? extends Record1<T>> query)	this > [quantifier] (Select<?> ...).
Condition	Field.greaterThan(Select<? extends Record1<T>> query)	this > (Select<?> ...).
Condition	Row1.greaterThan(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Row1.greaterThan(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Field.gt(QuantifiedSelect<? extends Record1<T>> query)	this > [quantifier] (Select<?> ...).
Condition	Field.gt(Select<? extends Record1<T>> query)	this > (Select<?> ...).
Condition	Row1.gt(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Row1.gt(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Field.in(Result<? extends Record1<T>> result)	Create a condition to check this field against several values from a previous query.
Condition	Field.in(Select<? extends Record1<T>> query)	Create a condition to check this field against a subquery.
Condition	Row1.in(Result<? extends Record1<T1>> result)	Compare this row value expression with a set of records for equality.
Condition	Row1.in(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for equality.
Condition	Field.le(QuantifiedSelect<? extends Record1<T>> query)	this <= [quantifier] (Select<?> ...).
Condition	Field.le(Select<? extends Record1<T>> query)	this <= (Select<?> ...).
Condition	Row1.le(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Row1.le(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Field.lessOrEqual(QuantifiedSelect<? extends Record1<T>> query)	this <= [quantifier] (Select<?> ...).
Condition	Field.lessOrEqual(Select<? extends Record1<T>> query)	this <= (Select<?> ...).
Condition	Row1.lessOrEqual(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Row1.lessOrEqual(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Field.lessThan(QuantifiedSelect<? extends Record1<T>> query)	this < [quantifier] (Select<?> ...).
Condition	Field.lessThan(Select<? extends Record1<T>> query)	this < (Select<?> ...).
Condition	Row1.lessThan(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Row1.lessThan(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
LikeEscapeStep	Field.like(QuantifiedSelect<Record1<String>> query)	Create a condition to pattern-check this field against a quantified select.
Condition	Field.lt(QuantifiedSelect<? extends Record1<T>> query)	this < [quantifier] (Select<?> ...).
Condition	Field.lt(Select<? extends Record1<T>> query)	this < (Select<?> ...).
Condition	Row1.lt(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Row1.lt(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
Condition	Field.ne(QuantifiedSelect<? extends Record1<T>> query)	this != [quantifier] (Select<?> ...).
Condition	Field.ne(Select<? extends Record1<T>> query)	this != (Select<?> ...).
Condition	Row1.ne(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for non-equality.
Condition	Row1.ne(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for non-equality.
Condition	Field.notEqual(QuantifiedSelect<? extends Record1<T>> query)	this != [quantifier] (Select<?> ...).
Condition	Field.notEqual(Select<? extends Record1<T>> query)	this != (Select<?> ...).
Condition	Row1.notEqual(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for non-equality.
Condition	Row1.notEqual(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for non-equality.
Condition	Field.notIn(Result<? extends Record1<T>> result)	Create a condition to check this field against several values from a previous query.
Condition	Field.notIn(Select<? extends Record1<T>> query)	Create a condition to check this field against a subquery.
Condition	Row1.notIn(Result<? extends Record1<T1>> result)	Compare this row value expression with a set of records for equality.
Condition	Row1.notIn(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for non-equality.
LikeEscapeStep	Field.notLike(QuantifiedSelect<Record1<String>> query)	Create a condition to pattern-check this field against a quantified select.
Field<T>	CaseConditionStep.otherwise(Select<? extends Record1<T>> result)	Add an else clause to the already constructed case statement
InsertOnDuplicateStep<R>	InsertValuesStep1.select(Select<? extends Record1<T1>> select)	Use a SELECT statement as the source of values for the INSERT statement
Merge<R>	MergeValuesStep1.select(Select<? extends Record1<T1>> select)	Use a SELECT statement as the source of values for the MERGE statement
Statement	Declaration.set(Select<? extends Record1<T>> value)	Initialise this declaration.
<T> InsertOnDuplicateSetMoreStep<R>	InsertOnDuplicateSetStep.set(Field<T> field, Select<? extends Record1<T>> value)	Set values for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT ...
<T> InsertSetMoreStep<R>	InsertSetMoreStep.set(Field<T> field, Select<? extends Record1<T>> value)	Set a value for a field in the INSERT statement.
<T> InsertSetMoreStep<R>	InsertSetStep.set(Field<T> field, Select<? extends Record1<T>> value)	Set a value for a field in the INSERT statement.
<T> MergeMatchedSetMoreStep<R>	MergeMatchedSetStep.set(Field<T> field, Select<? extends Record1<T>> value)	Set values for UPDATE in the MERGE statement's WHEN MATCHED clause.
<T> MergeNotMatchedSetMoreStep<R>	MergeNotMatchedSetStep.set(Field<T> field, Select<? extends Record1<T>> value)	Set values for INSERT in the MERGE statement's WHEN NOT MATCHED clause.
<T1> UpdateFromStep<R>	UpdateSetFirstStep.set(Row1<T1> row, Select<? extends Record1<T1>> select)	Specify a multi-column set clause for the UPDATE statement.
<T> UpdateSetMoreStep<R>	UpdateSetStep.set(Field<T> field, Select<? extends Record1<T>> value)	Set a value for a field in the UPDATE statement.
Statement	Variable.set(Select<? extends Record1<T>> value)	Assign a value to this variable.
<T> CaseConditionStep<T>	Case.when(Condition condition, Select<? extends Record1<T>> result)	This construct can be used to create expressions of the type
CaseConditionStep<T>	CaseConditionStep.when(Condition condition, Select<? extends Record1<T>> result)	Compare a condition to the already constructed case statement, return result if the condition holds true
<T> CaseWhenStep<V,T>	CaseValueStep.when(Field<V> compareValue, Select<? extends Record1<T>> result)	Compare a value to the already constructed case statement, return result if values are equal.
<T> CaseWhenStep<V,T>	CaseValueStep.when(V compareValue, Select<? extends Record1<T>> result)	Compare a value to the already constructed case statement, return result if values are equal.

Uses of Record1 in org.jooq.impl

Methods in org.jooq.impl with type parameters of type Record1

Modifier and Type	Method	Description
<T,R extends Record1<T>> Optional<T>	DefaultDSLContext.fetchOptionalValue(ResultQuery<R> query)
<T,R extends Record1<T>> T	DefaultDSLContext.fetchValue(ResultQuery<R> query)
<T,R extends Record1<T>> List<T>	DefaultDSLContext.fetchValues(ResultQuery<R> query)

Methods in org.jooq.impl that return Record1

Modifier and Type	Method	Description
<T1> Record1<T1>	DefaultDSLContext.fetchSingle(SelectField<T1> field1)
<T1> Record1<T1>	DefaultDSLContext.newRecord(Field<T1> field1)

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

Modifier and Type	Method	Description
static <T> QuantifiedSelect<Record1<T>>	DSL.all(Field<T[]> array)	Create an ALL quantified select to be used in quantified comparison predicate expressions.
static <T> QuantifiedSelect<Record1<T>>	DSL.all(Field<T>... fields)	Create an ALL quantified select to be used in quantified comparison predicate expressions.
static <T> QuantifiedSelect<Record1<T>>	DSL.all(T... array)	Create an ALL quantified select to be used in quantified comparison predicate expressions.
static <T> QuantifiedSelect<Record1<T>>	DSL.any(Field<T[]> array)	Create an ANY quantified select to be used in quantified comparison predicate expressions.
static <T> QuantifiedSelect<Record1<T>>	DSL.any(Field<T>... fields)	Create an ANY quantified select to be used in quantified comparison predicate expressions.
static <T> QuantifiedSelect<Record1<T>>	DSL.any(T... array)	Create an ANY quantified select to be used in quantified comparison predicate expressions.
static Table<Record1<Integer>>	DSL.generateSeries(int from, int to)	A table function generating a series of values from from to to (inclusive).
static Table<Record1<Integer>>	DSL.generateSeries(int from, int to, int step)	A table function generating a series of values from from to to (inclusive), increasing values by step.
static Table<Record1<Integer>>	DSL.generateSeries(int from, int to, Field<Integer> step)	A table function generating a series of values from from to to (inclusive), increasing values by step.
static Table<Record1<Integer>>	DSL.generateSeries(int from, Field<Integer> to)	A table function generating a series of values from from to to (inclusive).
static Table<Record1<Integer>>	DSL.generateSeries(int from, Field<Integer> to, int step)	A table function generating a series of values from from to to (inclusive), increasing values by step.
static Table<Record1<Integer>>	DSL.generateSeries(int from, Field<Integer> to, Field<Integer> step)	A table function generating a series of values from from to to (inclusive), increasing values by step.
static Table<Record1<Integer>>	DSL.generateSeries(Field<Integer> from, int to)	A table function generating a series of values from from to to (inclusive).
static Table<Record1<Integer>>	DSL.generateSeries(Field<Integer> from, int to, int step)	A table function generating a series of values from from to to (inclusive), increasing values by step.
static Table<Record1<Integer>>	DSL.generateSeries(Field<Integer> from, int to, Field<Integer> step)	A table function generating a series of values from from to to (inclusive), increasing values by step.
static Table<Record1<Integer>>	DSL.generateSeries(Field<Integer> from, Field<Integer> to)	A table function generating a series of values from from to to (inclusive).
static Table<Record1<Integer>>	DSL.generateSeries(Field<Integer> from, Field<Integer> to, int step)	A table function generating a series of values from from to to (inclusive), increasing values by step.
static Table<Record1<Integer>>	DSL.generateSeries(Field<Integer> from, Field<Integer> to, Field<Integer> step)	A table function generating a series of values from from to to (inclusive), increasing values by step.
<T1> Result<Record1<T1>>	DefaultDSLContext.newResult(Field<T1> field1)
static <T1> RecordType<Record1<T1>>	DSL.recordType(Field<T1> field1)	Create a RecordType of degree 1.
static <T1> Field<Record1<T1>>	DSL.rowField(Row1<T1> row)	EXPERIMENTAL: Turn a row value expression of degree 1 into a Field.
<T1> SelectSelectStep<Record1<T1>>	DefaultDSLContext.select(SelectField<T1> field1)
static <T1> SelectSelectStep<Record1<T1>>	DSL.select(SelectField<T1> field1)	Create a new DSL subselect statement.
SelectSelectStep<Record1<Integer>>	DefaultDSLContext.selectCount()
static SelectSelectStep<Record1<Integer>>	DSL.selectCount()	Create a new DSL subselect statement for COUNT(*).
<T1> SelectSelectStep<Record1<T1>>	DefaultDSLContext.selectDistinct(SelectField<T1> field1)
static <T1> SelectSelectStep<Record1<T1>>	DSL.selectDistinct(SelectField<T1> field1)	Create a new DSL subselect statement.
SelectSelectStep<Record1<Integer>>	DefaultDSLContext.selectOne()
static SelectSelectStep<Record1<Integer>>	DSL.selectOne()	Create a new DSL subselect statement for a constant 1 literal.
SelectSelectStep<Record1<Integer>>	DefaultDSLContext.selectZero()
static SelectSelectStep<Record1<Integer>>	DSL.selectZero()	Create a new DSL subselect statement for a constant 0 literal.
static <T1> Table<Record1<T1>>	DSL.values(Row1<T1>... rows)	Create a VALUES() expression of degree 1.

Method parameters in org.jooq.impl with type arguments of type Record1

Modifier and Type	Method	Description
<T> T	DefaultDSLContext.fetchValue(Table<? extends Record1<T>> table)
<T> List<T>	DefaultDSLContext.fetchValues(Table<? extends Record1<T>> table)
static <T> Field<T>	DSL.field(Select<? extends Record1<T>> select)	Transform a subquery into a correlated subquery.
static <T> CaseConditionStep<T>	DSL.when(Condition condition, Select<? extends Record1<T>> result)	Initialise a Case statement.

Uses of Record1 in org.jooq.util.postgres

Method parameters in org.jooq.util.postgres with type arguments of type Record1

Modifier and Type	Method	Description
static <T> Field<T[]>	PostgresDSL.array(Select<? extends Record1<T>> select)	The PostgreSQL array(select) function.