Uses of Interface
org.jooq.Record1

Packages that use Record1

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

Uses of Record1 in org.jooq

Methods in org.jooq with type parameters of type Record1

Modifier and Type	Method	Description
<R extends Record1<?>> @NotNull CommonTableExpression<R>	DerivedColumnList1.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record1<?>> @NotNull CommonTableExpression<R>	DerivedColumnList1.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record1<?>> @NotNull CommonTableExpression<R>	DerivedColumnList1.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<T, R extends Record1<T>> @NotNull 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>> @NotNull List<T>	DSLContext.fetchValues(ResultQuery<R> query)	Execute a ResultQuery in the context of this DSLContext and return all values for the only column.
static final <E, R extends Record1<E>> Collector<R,?,E[]>	Records.intoArray(E[] a)	Create a collector that can collect Record1 resulting from a single column ResultQuery into an array of that column's type.
static final <E, R extends Record1<E>> Collector<R,?,E[]>	Records.intoArray(Class<? extends E> componentType)	Create a collector that can collect Record resulting from a ResultQuery into an array of a mapped type.
static final <E, R extends Record1<E>> Collector<R,?,List<E>>	Records.intoList()	Create a collector that can collect Record1 resulting from a single column ResultQuery into a List of that column's type.
static final <E, R extends Record1<E>> Collector<R,?,Set<E>>	Records.intoSet()	Create a collector that can collect Record1 resulting from a single column ResultQuery into a Set of that column's type.
static final <T1, R extends Record1<T1>, U> RecordMapper<R,U>	Records.mapping(Function1<? super T1,? extends U> function)	Create a RecordMapper that can map from Record1 to a user type in a type safe way.

Methods in org.jooq that return Record1

Modifier and Type	Method	Description
<T1> @NotNull Record1<T1>	DSLContext.fetchSingle(SelectField<T1> field1)	Execute and return exactly one record for
@Nullable Record1<T>	Field.from(Record record)	The inverse operation of Record.into(Field).
<T1> @NotNull Record1<T1>	Record.into(Field<T1> field1)	Copy this record into a new record holding only a subset of the previous fields, using Fields.field(Field) for lookup.
<T1> @NotNull Record1<T1>	DSLContext.newRecord(Field<T1> field1)	Create a new empty Record.
@NotNull Record1<T1>	Record1.value1(T1 value)	Set the first value.
@NotNull Record1<T1>	Record1.values(T1 t1)	Set all values.
<T> @NotNull Record1<T1>	Record1.with(Field<T> field, T value)	Set a value into this record, using Fields.field(Field) for lookup.
<T, U> @NotNull Record1<T1>	Record1.with(Field<T> field, U value, Converter<? extends T,? super U> converter)	Set a value into this record, using Fields.field(Field) for lookup.

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

Modifier and Type	Method	Description
<T1> @NotNull CloseableResultQuery<Record1<T1>>	CloseableResultQuery.coerce(Field<T1> field1)
<T1> @NotNull ResultQuery<Record1<T1>>	ResultQuery.coerce(Field<T1> field1)	Coerce the result record type of this query to that of a set of fields.
@NotNull SelectForJSONStep<Record1<JSON>>	SelectForStep.forJSON()	Add a SQL Server-style FOR JSON clause.
@NotNull SelectForJSONStep<Record1<JSONB>>	SelectForStep.forJSONB()	Add a SQL Server-style FOR JSON clause.
@NotNull SelectForXMLStep<Record1<XML>>	SelectForStep.forXML()	Add a SQL Server-style FOR XML clause.
<T1> @NotNull 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, using Fields.field(Field) for lookup.
<T1> @NotNull Result<Record1<T1>>	DSLContext.newResult(Field<T1> field1)	Create a new empty Result.
@NotNull Select<Record1<T>>	Sequence.nextvals(int size)	An expression to increment the sequence and get the next values.
<T1> @NotNull DeleteResultStep<Record1<T1>>	DeleteReturningStep.returningResult(SelectField<T1> field1)	Configure the DELETE statement to return a list of fields in R.
<T1> @NotNull InsertResultStep<Record1<T1>>	InsertReturningStep.returningResult(SelectField<T1> field1)	Configure the INSERT statement to return a list of fields in R.
<T1> @NotNull UpdateResultStep<Record1<T1>>	UpdateReturningStep.returningResult(SelectField<T1> field1)	Configure the UPDATE statement to return a list of fields in R.
<T1> @NotNull SelectSelectStep<Record1<T1>>	DSLContext.select(SelectField<T1> field1)	Create a new DSL select statement.
<T1> @NotNull SelectSelectStep<Record1<T1>>	WithStep.select(SelectField<T1> field1)	Create a new DSL select statement.
@NotNull SelectSelectStep<Record1<Integer>>	DSLContext.selectCount()	Create a new DSL select statement for COUNT(*).
@NotNull SelectSelectStep<Record1<Integer>>	WithStep.selectCount()	Create a new DSL select statement for COUNT(*).
<T1> @NotNull SelectSelectStep<Record1<T1>>	DSLContext.selectDistinct(SelectField<T1> field1)	Create a new DSL select statement.
<T1> @NotNull SelectSelectStep<Record1<T1>>	WithStep.selectDistinct(SelectField<T1> field1)	Create a new DSL select statement.
@NotNull SelectSelectStep<Record1<Integer>>	DSLContext.selectOne()	Create a new DSL select statement for a constant 1 literal.
@NotNull SelectSelectStep<Record1<Integer>>	WithStep.selectOne()	Create a new DSL select statement for a constant 1 literal.
@NotNull SelectSelectStep<Record1<Integer>>	DSLContext.selectZero()	Create a new DSL select statement for a constant 0 literal.
@NotNull 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
@NotNull Condition	BetweenAndStep1.and(Record1<T1> maxValue)	Create a condition to check this field against some bounds
@NotNull BetweenAndStep1<T1>	Row1.between(Record1<T1> minValue)	Check if this row value expression is within a range of two records.
@NotNull Condition	Row1.between(Record1<T1> minValue, Record1<T1> maxValue)	Check if this row value expression is within a range of two records.
@NotNull BetweenAndStep1<T1>	Row1.betweenSymmetric(Record1<T1> minValue)	Check if this row value expression is within a symmetric range of two records.
@NotNull Condition	Row1.betweenSymmetric(Record1<T1> minValue, Record1<T1> maxValue)	Check if this row value expression is within a symmetric range of two records.
@NotNull Condition	Row1.compare(Comparator comparator, Record1<T1> record)	Compare this row value expression with a record using a dynamic comparator.
@NotNull Condition	Row1.eq(Record1<T1> record)	Compare this row value expression with a record for equality.
@NotNull Condition	Row1.equal(Record1<T1> record)	Compare this row value expression with a record for equality.
@NotNull Condition	Row1.ge(Record1<T1> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row1.greaterOrEqual(Record1<T1> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row1.greaterThan(Record1<T1> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row1.gt(Record1<T1> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row1.in(Record1<T1>... record)	Compare this row value expression with a set of records for equality.
@NotNull Condition	Row1.isDistinctFrom(Record1<T1> record)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row1.isNotDistinctFrom(Record1<T1> record)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row1.le(Record1<T1> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row1.lessOrEqual(Record1<T1> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row1.lessThan(Record1<T1> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row1.lt(Record1<T1> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row1.ne(Record1<T1> record)	Compare this row value expression with a record for non-equality.
@NotNull BetweenAndStep1<T1>	Row1.notBetween(Record1<T1> minValue)	Check if this row value expression is within a range of two records.
@NotNull Condition	Row1.notBetween(Record1<T1> minValue, Record1<T1> maxValue)	Check if this row value expression is within a range of two records.
@NotNull BetweenAndStep1<T1>	Row1.notBetweenSymmetric(Record1<T1> minValue)	Check if this row value expression is not within a symmetric range of two records.
@NotNull Condition	Row1.notBetweenSymmetric(Record1<T1> minValue, Record1<T1> maxValue)	Check if this row value expression is not within a symmetric range of two records.
@NotNull Condition	Row1.notEqual(Record1<T1> record)	Compare this row value expression with a record for non-equality
@NotNull Condition	Row1.notIn(Record1<T1>... record)	Compare this row value expression with a set of records for non-equality.
@NotNull Statement	Row1.set(Record1<T1> record)	Assign a value to this set of variables.
@NotNull InsertValuesStep1<R,T1>	InsertValuesStep1.values(Record1<T1> values)	Add a single row of values to the insert statement.
@NotNull InsertValuesStep1<R,T1>	InsertValuesStep1.valuesOfRecords(Record1<T1>... values)	Add multiple rows of values to the insert statement.

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.
@NotNull WithStep	WithAsStep1.as(ResultQuery<? extends Record1<?>> query)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep1.asMaterialized(ResultQuery<? extends Record1<?>> query)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep1.asNotMaterialized(ResultQuery<? extends Record1<?>> query)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull Condition	Field.binaryLike(QuantifiedSelect<? extends Record1<byte[]>> pattern)	The BINARY_LIKE operator.
@NotNull Condition	Field.compare(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query)	Compare this field with a quantified subselect using a dynamic comparator.
@NotNull Condition	Field.compare(Comparator comparator, Select<? extends Record1<T>> query)	Compare this field with a subselect using a dynamic comparator.
@NotNull Condition	Row1.compare(Comparator comparator, QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row1.compare(Comparator comparator, Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Field<T>	CaseConditionStep.else_(Select<? extends Record1<T>> result)	Add an else clause to the already constructed case statement
@NotNull Condition	Field.eq(QuantifiedSelect<? extends Record1<T>> arg2)	The EQ operator.
@NotNull Condition	Field.eq(Select<? extends Record1<T>> arg2)	The EQ operator.
@NotNull Condition	Row1.eq(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row1.eq(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Field.equal(QuantifiedSelect<? extends Record1<T>> arg2)	The EQUAL operator, an alias for the EQ operator.
@NotNull Condition	Field.equal(Select<? extends Record1<T>> arg2)	The EQUAL operator, an alias for the EQ operator.
@NotNull Condition	Row1.equal(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for equality.
@NotNull 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> @NotNull List<T>	DSLContext.fetchValues(Table<? extends Record1<T>> table)	Fetch all values from a single column table.
@NotNull Condition	Field.ge(QuantifiedSelect<? extends Record1<T>> arg2)	The GE operator.
@NotNull Condition	Field.ge(Select<? extends Record1<T>> arg2)	The GE operator.
@NotNull Condition	Row1.ge(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row1.ge(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Field.greaterOrEqual(QuantifiedSelect<? extends Record1<T>> arg2)	The GREATER_OR_EQUAL operator, an alias for the GE operator.
@NotNull Condition	Field.greaterOrEqual(Select<? extends Record1<T>> arg2)	The GREATER_OR_EQUAL operator, an alias for the GE operator.
@NotNull Condition	Row1.greaterOrEqual(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row1.greaterOrEqual(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Field.greaterThan(QuantifiedSelect<? extends Record1<T>> arg2)	The GREATER_THAN operator, an alias for the GT operator.
@NotNull Condition	Field.greaterThan(Select<? extends Record1<T>> arg2)	The GREATER_THAN operator, an alias for the GT operator.
@NotNull Condition	Row1.greaterThan(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row1.greaterThan(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Field.gt(QuantifiedSelect<? extends Record1<T>> arg2)	The GT operator.
@NotNull Condition	Field.gt(Select<? extends Record1<T>> arg2)	The GT operator.
@NotNull Condition	Row1.gt(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row1.gt(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Field.in(Result<? extends Record1<T>> result)	Create a condition to check this field against several values from a previous query.
@NotNull Condition	Field.in(Select<? extends Record1<T>> arg2)	The IN operator.
@NotNull Condition	Row1.in(Result<? extends Record1<T1>> result)	Compare this row value expression with a set of records for equality.
@NotNull Condition	Row1.in(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Field.isDistinctFrom(Select<? extends Record1<T>> arg2)	The IS_DISTINCT_FROM operator.
@NotNull Condition	Row1.isDistinctFrom(Select<? extends Record1<T1>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Field.isNotDistinctFrom(Select<? extends Record1<T>> arg2)	The IS_NOT_DISTINCT_FROM operator.
@NotNull Condition	Row1.isNotDistinctFrom(Select<? extends Record1<T1>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Field.le(QuantifiedSelect<? extends Record1<T>> arg2)	The LE operator.
@NotNull Condition	Field.le(Select<? extends Record1<T>> arg2)	The LE operator.
@NotNull Condition	Row1.le(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row1.le(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Field.lessOrEqual(QuantifiedSelect<? extends Record1<T>> arg2)	The LESS_OR_EQUAL operator, an alias for the LE operator.
@NotNull Condition	Field.lessOrEqual(Select<? extends Record1<T>> arg2)	The LESS_OR_EQUAL operator, an alias for the LE operator.
@NotNull Condition	Row1.lessOrEqual(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row1.lessOrEqual(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Field.lessThan(QuantifiedSelect<? extends Record1<T>> arg2)	The LESS_THAN operator, an alias for the LT operator.
@NotNull Condition	Field.lessThan(Select<? extends Record1<T>> arg2)	The LESS_THAN operator, an alias for the LT operator.
@NotNull Condition	Row1.lessThan(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row1.lessThan(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull LikeEscapeStep	Field.like(QuantifiedSelect<? extends Record1<String>> pattern)	The LIKE operator.
@NotNull Condition	Field.lt(QuantifiedSelect<? extends Record1<T>> arg2)	The LT operator.
@NotNull Condition	Field.lt(Select<? extends Record1<T>> arg2)	The LT operator.
@NotNull Condition	Row1.lt(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row1.lt(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Field.ne(QuantifiedSelect<? extends Record1<T>> arg2)	The NE operator.
@NotNull Condition	Field.ne(Select<? extends Record1<T>> arg2)	The NE operator.
@NotNull Condition	Row1.ne(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row1.ne(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Field.notBinaryLike(QuantifiedSelect<? extends Record1<byte[]>> pattern)	The NOT_BINARY_LIKE operator.
@NotNull Condition	Field.notEqual(QuantifiedSelect<? extends Record1<T>> arg2)	The NOT_EQUAL operator, an alias for the NE operator.
@NotNull Condition	Field.notEqual(Select<? extends Record1<T>> arg2)	The NOT_EQUAL operator, an alias for the NE operator.
@NotNull Condition	Row1.notEqual(QuantifiedSelect<? extends Record1<T1>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row1.notEqual(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Field.notIn(Result<? extends Record1<T>> result)	Create a condition to check this field against several values from a previous query.
@NotNull Condition	Field.notIn(Select<? extends Record1<T>> arg2)	The NOT_IN operator.
@NotNull Condition	Row1.notIn(Result<? extends Record1<T1>> result)	Compare this row value expression with a set of records for equality.
@NotNull Condition	Row1.notIn(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull LikeEscapeStep	Field.notLike(QuantifiedSelect<? extends Record1<String>> pattern)	The NOT_LIKE operator.
@NotNull LikeEscapeStep	Field.notSimilarTo(QuantifiedSelect<? extends Record1<String>> pattern)	The NOT_SIMILAR_TO operator.
@NotNull Field<T>	CaseConditionStep.otherwise(Select<? extends Record1<T>> result)	Add an else clause to the already constructed case statement
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep1.select(Select<? extends Record1<T1>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull Merge<R>	MergeValuesStep1.select(Select<? extends Record1<T1>> select)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Statement	Declaration.set(Select<? extends Record1<T>> value)	Initialise this declaration.
<T> @NotNull 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 … DO UPDATE clause.
<T> @NotNull InsertSetMoreStep<R>	InsertSetMoreStep.set(Field<T> field, Select<? extends Record1<T>> value)	Set a value for a field in the INSERT statement.
<T> @NotNull InsertSetMoreStep<R>	InsertSetStep.set(Field<T> field, Select<? extends Record1<T>> value)	Set a value for a field in the INSERT statement.
<T> @NotNull 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> @NotNull 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.
@NotNull Statement	Row1.set(Select<? extends Record1<T1>> value)	Assign a value to this set of variables.
<T1> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row1<T1> row, Select<? extends Record1<T1>> select)	Specify a multi-column set clause for the UPDATE statement.
<T> @NotNull UpdateSetMoreStep<R>	UpdateSetStep.set(Field<T> field, Select<? extends Record1<T>> value)	Set a value for a field in the UPDATE statement.
@NotNull Statement	Variable.set(Select<? extends Record1<T>> value)	Assign a value to this variable.
@NotNull LikeEscapeStep	Field.similarTo(QuantifiedSelect<? extends Record1<String>> pattern)	The SIMILAR_TO operator.
<T> @NotNull JSONEntry<T>	JSONEntryValueStep.value(Select<? extends Record1<T>> value)	The JSON entry value.
@NotNull InsertValuesStep1<R,T1>	InsertValuesStep1.valuesOfRecords(Collection<? extends Record1<T1>> values)	Add multiple rows of values to the insert statement.
<T> @NotNull CaseConditionStep<T>	Case.when(Condition condition, Select<? extends Record1<T>> result)	This construct can be used to create expressions of the type
<T> @NotNull CaseConditionStep<T>	Case.when(Field<Boolean> condition, Select<? extends Record1<T>> result)	This construct can be used to create expressions of the type
@NotNull 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
@NotNull CaseConditionStep<T>	CaseConditionStep.when(Field<Boolean> condition, Select<? extends Record1<T>> result)	Compare a condition to the already constructed case statement, return result if the condition holds true
<T> @NotNull 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> @NotNull 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
default QuantifiedSelect<? extends Record1<byte[]>>	QOM.BinaryLikeQuantified.$pattern()
default QuantifiedSelect<? extends Record1<String>>	QOM.LikeQuantified.$pattern()
default QuantifiedSelect<? extends Record1<byte[]>>	QOM.NotBinaryLikeQuantified.$pattern()
default QuantifiedSelect<? extends Record1<String>>	QOM.NotLikeQuantified.$pattern()
default QuantifiedSelect<? extends Record1<String>>	QOM.NotSimilarToQuantified.$pattern()
default QuantifiedSelect<? extends Record1<String>>	QOM.SimilarToQuantified.$pattern()
@NotNull Select<? extends Record1<T>>	QOM.ArrayQuery.$query()
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.all(Field<T[]> array)	Create an ALL quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.all(Field<T>... fields)	Create an ALL quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.all(T... array)	Create an ALL quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.any(Field<T[]> array)	Create an ANY quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.any(Field<T>... fields)	Create an ANY quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.any(T... array)	Create an ANY quantified select to be used in quantified comparison predicate expressions.
static @NotNull Table<Record1<Integer>>	DSL.generateSeries(int from, int to)	A table function generating a series of values from from to to (inclusive).
static @NotNull 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 @NotNull 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 @NotNull Table<Record1<Integer>>	DSL.generateSeries(int from, Field<Integer> to)	A table function generating a series of values from from to to (inclusive).
static @NotNull 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 @NotNull 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 @NotNull Table<Record1<Integer>>	DSL.generateSeries(Field<Integer> from, int to)	A table function generating a series of values from from to to (inclusive).
static @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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 @NotNull 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.
static <T1> @NotNull ArrayAggOrderByStep<Result<Record1<T1>>>	DSL.multisetAgg(SelectField<T1> field1)	Get the MULTISET_AGG aggregate function to nest group contents.
static <T1> @NotNull ArrayAggOrderByStep<Result<Record1<T1>>>	DSL.multisetAggDistinct(SelectField<T1> field1)	Get the MULTISET_AGG(DISTINCT) aggregate function to nest group contents.
<T1> Result<Record1<T1>>	DefaultDSLContext.newResult(Field<T1> field1)
final Select<Record1<T>>	SequenceImpl.nextvals(int size)
static <T1> @NotNull RecordType<Record1<T1>>	DSL.recordType(Field<T1> field1)	Create a RecordType of degree 1.
static <T1> @NotNull Field<Record1<T1>>	DSL.rowField(Row1<T1> row)	Deprecated, for removal: This API element is subject to removal in a future version. - [#11812] - 3.15.0 - Use Row1 as a SelectField directly, instead.
<T1> SelectSelectStep<Record1<T1>>	DefaultDSLContext.select(SelectField<T1> field1)
static <T1> @NotNull SelectSelectStep<Record1<T1>>	DSL.select(SelectField<T1> field1)	Create a new DSL subselect statement.
SelectSelectStep<Record1<Integer>>	DefaultDSLContext.selectCount()
static @NotNull SelectSelectStep<Record1<Integer>>	DSL.selectCount()	Create a new DSL subselect statement for COUNT(*).
<T1> SelectSelectStep<Record1<T1>>	DefaultDSLContext.selectDistinct(SelectField<T1> field1)
static <T1> @NotNull SelectSelectStep<Record1<T1>>	DSL.selectDistinct(SelectField<T1> field1)	Create a new DSL subselect statement.
SelectSelectStep<Record1<Integer>>	DefaultDSLContext.selectOne()
static @NotNull SelectSelectStep<Record1<Integer>>	DSL.selectOne()	Create a new DSL subselect statement for a constant 1 literal.
SelectSelectStep<Record1<Integer>>	DefaultDSLContext.selectZero()
static @NotNull SelectSelectStep<Record1<Integer>>	DSL.selectZero()	Create a new DSL subselect statement for a constant 0 literal.
static <T1> @NotNull 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
default @NotNull QOM.BinaryLikeQuantified	QOM.BinaryLikeQuantified.$pattern(QuantifiedSelect<? extends Record1<byte[]>> newPattern)
default @NotNull QOM.LikeQuantified	QOM.LikeQuantified.$pattern(QuantifiedSelect<? extends Record1<String>> newPattern)
default @NotNull QOM.NotBinaryLikeQuantified	QOM.NotBinaryLikeQuantified.$pattern(QuantifiedSelect<? extends Record1<byte[]>> newPattern)
default @NotNull QOM.NotLikeQuantified	QOM.NotLikeQuantified.$pattern(QuantifiedSelect<? extends Record1<String>> newPattern)
default @NotNull QOM.NotSimilarToQuantified	QOM.NotSimilarToQuantified.$pattern(QuantifiedSelect<? extends Record1<String>> newPattern)
default @NotNull QOM.SimilarToQuantified	QOM.SimilarToQuantified.$pattern(QuantifiedSelect<? extends Record1<String>> newPattern)
static <T> @NotNull Field<T[]>	DSL.array(Select<? extends Record1<T>> select)	The PostgreSQL array(select) function.
<T> T	DefaultDSLContext.fetchValue(Table<? extends Record1<T>> table)
<T> List<T>	DefaultDSLContext.fetchValues(Table<? extends Record1<T>> table)
static <T> @NotNull Field<T>	DSL.field(Select<? extends Record1<T>> select)	Transform a subquery into a correlated subquery.
static @NotNull JSONObjectNullStep<JSONB>	DSL.jsonbObject(Field<String> key, Select<? extends Record1<?>> value)	The JSON object constructor.
static <T> @NotNull JSONEntry<T>	DSL.jsonEntry(String key, Select<? extends Record1<T>> value)	A constructor for JSON entries to be used with DSL.jsonObject(JSONEntry...).
static <T> @NotNull JSONEntry<T>	DSL.jsonEntry(Field<String> key, Select<? extends Record1<T>> value)	A constructor for JSON entries to be used with DSL.jsonObject(JSONEntry...).
static @NotNull JSONObjectNullStep<JSON>	DSL.jsonObject(Field<String> key, Select<? extends Record1<?>> value)	The JSON object constructor.
static <T> @NotNull CaseConditionStep<T>	DSL.when(Condition condition, Select<? extends Record1<T>> result)	Initialise a Case statement.
static <T> @NotNull CaseConditionStep<T>	DSL.when(Field<Boolean> condition, Select<? extends Record1<T>> result)	Initialise a Case statement.