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.org.jooq.util.postgres This package contains classes related to theSQLDialect.POSTGRES
dialect family. -
-
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(Select<R> select)
Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record1<?>>
@NotNull CommonTableExpression<R>DerivedColumnList1. asMaterialized(Select<R> select)
Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record1<?>>
@NotNull CommonTableExpression<R>DerivedColumnList1. asNotMaterialized(Select<R> select)
Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<T,R extends Record1<T>>
@NotNull Optional<T>DSLContext. fetchOptionalValue(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a single value.<T,R extends Record1<T>>
TDSLContext. fetchValue(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a single value.<T,R extends Record1<T>>
@NotNull List<T>DSLContext. fetchValues(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return all values for the only column.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 ofRecord.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.<T1> @NotNull Record1<T1>
DSLContext. newRecord(Field<T1> field1)
Create a new emptyRecord
.@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.<T,U>
@NotNull Record1<T1>Record1. with(Field<T> field, U value, Converter<? extends T,? super U> converter)
Set a value into this record.Methods in org.jooq that return types with arguments of type Record1 Modifier and Type Method Description <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-styleFOR JSON
clause.@NotNull SelectForJSONStep<Record1<JSONB>>
SelectForStep. forJSONB()
Add a SQL Server-styleFOR JSON
clause.@NotNull SelectForXMLStep<Record1<XML>>
SelectForStep. forXML()
Add a SQL Server-styleFOR 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.<T1> @NotNull Result<Record1<T1>>
DSLContext. newResult(Field<T1> field1)
Create a new emptyResult
.@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 theDELETE
statement to return a list of fields inR
.<T1> @NotNull InsertResultStep<Record1<T1>>
InsertReturningStep. returningResult(SelectField<T1> field1)
Configure theINSERT
statement to return a list of fields inR
.<T1> @NotNull UpdateResultStep<Record1<T1>>
UpdateReturningStep. returningResult(SelectField<T1> field1)
Configure theUPDATE
statement to return a list of fields inR
.<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 forCOUNT(*)
.@NotNull SelectSelectStep<Record1<Integer>>
WithStep. selectCount()
Create a new DSL select statement forCOUNT(*)
.<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 constant1
literal.@NotNull SelectSelectStep<Record1<Integer>>
WithStep. selectOne()
Create a new DSL select statement for a constant1
literal.@NotNull SelectSelectStep<Record1<Integer>>
DSLContext. selectZero()
Create a new DSL select statement for a constant0
literal.@NotNull SelectSelectStep<Record1<Integer>>
WithStep. selectZero()
Create a new DSL select statement for a constant0
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.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 theUPDATE
statement.@NotNull WithStep
WithAsStep1. as(Select<? extends Record1<?>> select)
Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep1. asMaterialized(Select<? extends Record1<?>> select)
Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep1. asNotMaterialized(Select<? extends Record1<?>> select)
Associate a non-materialized subselect with a common table expression's table and column names.@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>> query)
this = [quantifier] (Select<?> ...)
.@NotNull Condition
Field. eq(Select<? extends Record1<T>> query)
this = (Select<?> ...)
.@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>> query)
this = [quantifier] (Select<?> ...)
.@NotNull Condition
Field. equal(Select<? extends Record1<T>> query)
this = (Select<?> ...)
.@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>> query)
this >= [quantifier] (Select<?> ...)
.@NotNull Condition
Field. ge(Select<? extends Record1<T>> query)
this >= (Select<?> ...)
.@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>> query)
this >= [quantifier] (Select<?> ...)
.@NotNull Condition
Field. greaterOrEqual(Select<? extends Record1<T>> query)
this >= (Select<?> ...)
.@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>> query)
this > [quantifier] (Select<?> ...)
.@NotNull Condition
Field. greaterThan(Select<? extends Record1<T>> query)
this > (Select<?> ...)
.@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>> query)
this > [quantifier] (Select<?> ...)
.@NotNull Condition
Field. gt(Select<? extends Record1<T>> query)
this > (Select<?> ...)
.@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>> query)
Create a condition to check this field against a subquery.@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>> select)
Create a condition to check if this field isDISTINCT
from another field.@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>> select)
Create a condition to check if this field isNOT DISTINCT
from another field.@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>> query)
this <= [quantifier] (Select<?> ...)
.@NotNull Condition
Field. le(Select<? extends Record1<T>> query)
this <= (Select<?> ...)
.@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>> query)
this <= [quantifier] (Select<?> ...)
.@NotNull Condition
Field. lessOrEqual(Select<? extends Record1<T>> query)
this <= (Select<?> ...)
.@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>> query)
this < [quantifier] (Select<?> ...)
.@NotNull Condition
Field. lessThan(Select<? extends Record1<T>> query)
this < (Select<?> ...)
.@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<Record1<String>> query)
Create a condition to pattern-check this field against a quantified select.@NotNull Condition
Field. lt(QuantifiedSelect<? extends Record1<T>> query)
this < [quantifier] (Select<?> ...)
.@NotNull Condition
Field. lt(Select<? extends Record1<T>> query)
this < (Select<?> ...)
.@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>> query)
this != [quantifier] (Select<?> ...)
.@NotNull Condition
Field. ne(Select<? extends Record1<T>> query)
this != (Select<?> ...)
.@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. notEqual(QuantifiedSelect<? extends Record1<T>> query)
this != [quantifier] (Select<?> ...)
.@NotNull Condition
Field. notEqual(Select<? extends Record1<T>> query)
this != (Select<?> ...)
.@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>> query)
Create a condition to check this field against a subquery.@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<Record1<String>> query)
Create a condition to pattern-check this field against a quantified select.@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 aSELECT
statement as the source of values for theINSERT
statement@NotNull Merge<R>
MergeValuesStep1. select(Select<? extends Record1<T1>> select)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.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 forUPDATE
in theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT ...
<T> @NotNull InsertSetMoreStep<R>
InsertSetMoreStep. set(Field<T> field, Select<? extends Record1<T>> value)
Set a value for a field in theINSERT
statement.<T> @NotNull InsertSetMoreStep<R>
InsertSetStep. set(Field<T> field, Select<? extends Record1<T>> value)
Set a value for a field in theINSERT
statement.<T> @NotNull MergeMatchedSetMoreStep<R>
MergeMatchedSetStep. set(Field<T> field, Select<? extends Record1<T>> value)
Set values forUPDATE
in theMERGE
statement'sWHEN MATCHED
clause.<T> @NotNull MergeNotMatchedSetMoreStep<R>
MergeNotMatchedSetStep. set(Field<T> field, Select<? extends Record1<T>> value)
Set values forINSERT
in theMERGE
statement'sWHEN NOT MATCHED clause.
<T1> @NotNull UpdateFromStep<R>
UpdateSetFirstStep. set(Row1<T1> row, Select<? extends Record1<T1>> select)
Specify a multi-column set clause for theUPDATE
statement.<T> @NotNull UpdateSetMoreStep<R>
UpdateSetStep. set(Field<T> field, Select<? extends Record1<T>> value)
Set a value for a field in theUPDATE
statement.@NotNull Statement
Variable. set(Select<? extends Record1<T>> value)
Assign a value to this variable.<T> @NotNull JSONEntry<T>
JSONEntryValueStep. value(Select<? extends Record1<T>> value)
The JSON entry value.<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>>
TDefaultDSLContext. 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> @NotNull QuantifiedSelect<Record1<T>>
DSL. all(Field<T[]> array)
Create anALL
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>
DSL. all(Field<T>... fields)
Create anALL
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>
DSL. all(T... array)
Create anALL
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>
DSL. any(Field<T[]> array)
Create anANY
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>
DSL. any(Field<T>... fields)
Create anANY
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>
DSL. any(T... array)
Create anANY
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 fromfrom
toto
(inclusive).static @NotNull Table<Record1<Integer>>
DSL. generateSeries(int from, int to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static @NotNull Table<Record1<Integer>>
DSL. generateSeries(int from, int to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static @NotNull Table<Record1<Integer>>
DSL. generateSeries(int from, Field<Integer> to)
A table function generating a series of values fromfrom
toto
(inclusive).static @NotNull Table<Record1<Integer>>
DSL. generateSeries(int from, Field<Integer> to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static @NotNull Table<Record1<Integer>>
DSL. generateSeries(int from, Field<Integer> to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static @NotNull Table<Record1<Integer>>
DSL. generateSeries(Field<Integer> from, int to)
A table function generating a series of values fromfrom
toto
(inclusive).static @NotNull Table<Record1<Integer>>
DSL. generateSeries(Field<Integer> from, int to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static @NotNull Table<Record1<Integer>>
DSL. generateSeries(Field<Integer> from, int to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static @NotNull Table<Record1<Integer>>
DSL. generateSeries(Field<Integer> from, Field<Integer> to)
A table function generating a series of values fromfrom
toto
(inclusive).static @NotNull Table<Record1<Integer>>
DSL. generateSeries(Field<Integer> from, Field<Integer> to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static @NotNull Table<Record1<Integer>>
DSL. generateSeries(Field<Integer> from, Field<Integer> to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.<T1> Result<Record1<T1>>
DefaultDSLContext. newResult(Field<T1> field1)
Select<Record1<T>>
SequenceImpl. nextvals(int size)
static <T1> @NotNull RecordType<Record1<T1>>
DSL. recordType(Field<T1> field1)
Create aRecordType
of degree1
.static <T1> @NotNull Field<Record1<T1>>
DSL. rowField(Row1<T1> row)
EXPERIMENTAL: Turn a row value expression of degree1
into aField
.<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 forCOUNT(*)
.<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 constant1
literal.SelectSelectStep<Record1<Integer>>
DefaultDSLContext. selectZero()
static @NotNull SelectSelectStep<Record1<Integer>>
DSL. selectZero()
Create a new DSL subselect statement for a constant0
literal.static <T1> @NotNull Table<Record1<T1>>
DSL. values(Row1<T1>... rows)
Create aVALUES()
expression of degree1
.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> @NotNull Field<T>
DSL. field(Select<? extends Record1<T>> select)
Transform a subquery into a correlated subquery.static <T> @NotNull CaseConditionStep<T>
DSL. when(Condition condition, Select<? extends Record1<T>> result)
Initialise aCase
statement.static <T> @NotNull CaseConditionStep<T>
DSL. when(Field<Boolean> condition, Select<? extends Record1<T>> result)
Initialise aCase
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> @NotNull Field<T[]>
PostgresDSL. array(Select<? extends Record1<T>> select)
The PostgreSQLarray(select)
function.
-