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 and 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 and Description
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 and Description
<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> UpdateResultStep<Record1<T1>>	UpdateReturningStep.returningResult(SelectField<T1> field1) Configure the UPDATE 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> DeleteResultStep<Record1<T1>>	DeleteReturningStep.returningResult(SelectField<T1> field1) Configure the DELETE statement to return a list of fields in R.
<T1> SelectSelectStep<Record1<T1>>	WithStep.select(SelectField<T1> field1) Create a new DSL select statement.
<T1> SelectSelectStep<Record1<T1>>	DSLContext.select(SelectField<T1> field1) Create a new DSL select statement.
SelectSelectStep<Record1<Integer>>	WithStep.selectCount() Create a new DSL select statement for COUNT(*).
SelectSelectStep<Record1<Integer>>	DSLContext.selectCount() Create a new DSL select statement for COUNT(*).
<T1> SelectSelectStep<Record1<T1>>	WithStep.selectDistinct(SelectField<T1> field1) Create a new DSL select statement.
<T1> SelectSelectStep<Record1<T1>>	DSLContext.selectDistinct(SelectField<T1> field1) Create a new DSL select statement.
SelectSelectStep<Record1<Integer>>	WithStep.selectOne() Create a new DSL select statement for a constant 1 literal.
SelectSelectStep<Record1<Integer>>	DSLContext.selectOne() Create a new DSL select statement for a constant 1 literal.
SelectSelectStep<Record1<Integer>>	WithStep.selectZero() Create a new DSL select statement for a constant 0 literal.
SelectSelectStep<Record1<Integer>>	DSLContext.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 and 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.
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.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.
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.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 and 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	Row1.compare(Comparator comparator, QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a 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, Select<? extends Record1<T1>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Field.eq(QuantifiedSelect<? extends Record1<T>> query) this = [quantifier] (Select<?
Condition	Row1.eq(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for equality.
Condition	Field.eq(Select<? extends Record1<T>> query) this = (Select<?
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	Row1.equal(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for equality.
Condition	Field.equal(Select<? extends Record1<T>> query) this = (Select<?
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	Row1.ge(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Field.ge(Select<? extends Record1<T>> query) this >= (Select<?
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	Row1.greaterOrEqual(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Field.greaterOrEqual(Select<? extends Record1<T>> query) this >= (Select<?
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	Row1.greaterThan(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Field.greaterThan(Select<? extends Record1<T>> query) this > (Select<?
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	Row1.gt(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Field.gt(Select<? extends Record1<T>> query) this > (Select<?
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	Row1.in(Result<? extends Record1<T1>> result) Compare this row value expression with a set of records for equality.
Condition	Field.in(Select<? extends Record1<T>> query) Create a condition to check this field against a subquery.
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	Row1.le(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Field.le(Select<? extends Record1<T>> query) this <= (Select<?
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	Row1.lessOrEqual(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Field.lessOrEqual(Select<? extends Record1<T>> query) this <= (Select<?
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	Row1.lessThan(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Field.lessThan(Select<? extends Record1<T>> query) this < (Select<?
Condition	Row1.lessThan(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Field.lt(QuantifiedSelect<? extends Record1<T>> query) this < [quantifier] (Select<?
Condition	Row1.lt(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Field.lt(Select<? extends Record1<T>> query) this < (Select<?
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 !
Condition	Row1.ne(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for non-equality.
Condition	Field.ne(Select<? extends Record1<T>> query) this !
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 !
Condition	Row1.notEqual(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for non-equality.
Condition	Field.notEqual(Select<? extends Record1<T>> query) this !
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	Row1.notIn(Result<? extends Record1<T1>> result) Compare this row value expression with a set of records for equality.
Condition	Field.notIn(Select<? extends Record1<T>> query) Create a condition to check this field against a subquery.
Condition	Row1.notIn(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for non-equality.
Field<T>	CaseConditionStep.otherwise(Select<? extends Record1<T>> result) Add an else clause to the already constructed case statement
Merge<R>	MergeValuesStep1.select(Select<? extends Record1<T1>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
InsertOnDuplicateStep<R>	InsertValuesStep1.select(Select<? extends Record1<T1>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
<T> UpdateSetMoreStep<R>	UpdateSetStep.set(Field<T> field, Select<? extends Record1<T>> value) Set a value for a field in the UPDATE statement.
<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.
<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> InsertSetMoreStep<R>	InsertSetStep.set(Field<T> field, Select<? extends Record1<T>> value) Set a value for a field in the INSERT statement.
<T> InsertSetMoreStep<R>	InsertSetMoreStep.set(Field<T> field, Select<? extends Record1<T>> value) Set a value for a field in the INSERT statement.
<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 clause.
<T1> UpdateFromStep<R>	UpdateSetFirstStep.set(Row1<T1> row, Select<? extends Record1<T1>> select) Specify a multi-column set clause for the UPDATE statement.
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> CaseConditionStep<T>	Case.when(Condition condition, Select<? extends Record1<T>> result) This construct can be used to create expressions of the type CASE WHEN x < 1 THEN 'one' WHEN x >= 2 THEN 'two' ELSE 'three' END
<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 and 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 and Description
<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 and 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(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(T... array) Create an ANY quantified select to be used in quantified comparison predicate expressions.
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, 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, 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) A table function generating a series of values from from to to (inclusive).
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, 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, 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, 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, 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) A table function generating a series of values from from to to (inclusive).
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, int to, int 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.
static <T1> SelectSelectStep<Record1<T1>>	DSL.select(SelectField<T1> field1) Create a new DSL subselect statement.
<T1> SelectSelectStep<Record1<T1>>	DefaultDSLContext.select(SelectField<T1> field1)
static SelectSelectStep<Record1<Integer>>	DSL.selectCount() Create a new DSL subselect statement for COUNT(*).
SelectSelectStep<Record1<Integer>>	DefaultDSLContext.selectCount()
static <T1> SelectSelectStep<Record1<T1>>	DSL.selectDistinct(SelectField<T1> field1) Create a new DSL subselect statement.
<T1> SelectSelectStep<Record1<T1>>	DefaultDSLContext.selectDistinct(SelectField<T1> field1)
static SelectSelectStep<Record1<Integer>>	DSL.selectOne() Create a new DSL subselect statement for a constant 1 literal.
SelectSelectStep<Record1<Integer>>	DefaultDSLContext.selectOne()
static SelectSelectStep<Record1<Integer>>	DSL.selectZero() Create a new DSL subselect statement for a constant 0 literal.
SelectSelectStep<Record1<Integer>>	DefaultDSLContext.selectZero()
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 and 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 and Description
static <T> Field<T[]>	PostgresDSL.array(Select<? extends Record1<T>> select) The PostgreSQL array(select) function.