Uses of Interface
org.jooq.Record1
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of Record1 in org.jooq
Modifier and TypeMethodDescription<R extends Record1<?>>
@NotNull CommonTableExpression<R> DerivedColumnList1.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
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 theDerivedColumnList
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 theDerivedColumnList
to form a common table expression.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.DSLContext.fetchValues
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return all values for the only column.Records.intoArray
(E[] a) Create a collector that can collectRecord1
resulting from a single columnResultQuery
into an array of that column's type.Create a collector that can collectRecord
resulting from aResultQuery
into an array of a mapped type.Records.intoList()
Create a collector that can collectRecord1
resulting from a single columnResultQuery
into aList
of that column's type.Records.intoSet()
Create a collector that can collectRecord1
resulting from a single columnResultQuery
into aSet
of that column's type.static final <T1,
R extends Record1<T1>, U>
RecordMapper<R, U> Create aRecordMapper
that can map fromRecord1
to a user type in a type safe way.Modifier and TypeMethodDescription<T1> @NotNull Record1
<T1> DSLContext.fetchSingle
(SelectField<T1> field1) Execute and return exactly one record forThe inverse operation ofRecord.into(Field)
.<T1> @NotNull Record1
<T1> Copy this record into a new record holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<T1> @NotNull Record1
<T1> Create a new emptyRecord
.Set the first value.Set all values.Set a value into this record, usingFields.field(Field)
for lookup.Set a value into this record, usingFields.field(Field)
for lookup.Modifier and TypeMethodDescription<T1> @NotNull CloseableResultQuery
<Record1<T1>> <T1> @NotNull ResultQuery
<Record1<T1>> 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.Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.Create a new emptyResult
.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.Modifier and TypeMethodDescription@NotNull Condition
Create a condition to check this field against some bounds@NotNull BetweenAndStep1
<T1> Check if this row value expression is within a range of two records.@NotNull Condition
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
Compare this row value expression with a record for equality.@NotNull Condition
Compare this row value expression with a record for equality.@NotNull Condition
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
Compare this row value expression with a record for order.@NotNull Condition
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
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
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
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
Compare this row value expression with a record for non-equality@NotNull Condition
Compare this row value expression with a set of records for non-equality.@NotNull Statement
Assign a value to this set of variables.@NotNull InsertValuesStep1
<R, T1> 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.Modifier and TypeMethodDescription<T1> void
Specify a multi-column set clause for theUPDATE
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.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.Add an else clause to the already constructed case statement@NotNull Condition
Field.eq
(QuantifiedSelect<? extends Record1<T>> arg2) TheEQ
operator.@NotNull Condition
TheEQ
operator.@NotNull Condition
Row1.eq
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Field.equal
(QuantifiedSelect<? extends Record1<T>> arg2) TheEQUAL
operator, an alias for theEQ
operator.@NotNull Condition
TheEQUAL
operator, an alias for theEQ
operator.@NotNull Condition
Row1.equal
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
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) TheGE
operator.@NotNull Condition
TheGE
operator.@NotNull Condition
Row1.ge
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Field.greaterOrEqual
(QuantifiedSelect<? extends Record1<T>> arg2) TheGREATER_OR_EQUAL
operator, an alias for theGE
operator.@NotNull Condition
Field.greaterOrEqual
(Select<? extends Record1<T>> arg2) TheGREATER_OR_EQUAL
operator, an alias for theGE
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) TheGREATER_THAN
operator, an alias for theGT
operator.@NotNull Condition
Field.greaterThan
(Select<? extends Record1<T>> arg2) TheGREATER_THAN
operator, an alias for theGT
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) TheGT
operator.@NotNull Condition
TheGT
operator.@NotNull Condition
Row1.gt
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Create a condition to check this field against several values from a previous query.@NotNull Condition
TheIN
operator.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Field.isDistinctFrom
(Select<? extends Record1<T>> arg2) TheIS_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) TheIS_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) TheLE
operator.@NotNull Condition
TheLE
operator.@NotNull Condition
Row1.le
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Field.lessOrEqual
(QuantifiedSelect<? extends Record1<T>> arg2) TheLESS_OR_EQUAL
operator, an alias for theLE
operator.@NotNull Condition
Field.lessOrEqual
(Select<? extends Record1<T>> arg2) TheLESS_OR_EQUAL
operator, an alias for theLE
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) TheLESS_THAN
operator, an alias for theLT
operator.@NotNull Condition
TheLESS_THAN
operator, an alias for theLT
operator.@NotNull Condition
Row1.lessThan
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull LikeEscapeStep
Field.like
(QuantifiedSelect<? extends Record1<String>> pattern) TheLIKE
operator.@NotNull Condition
Field.lt
(QuantifiedSelect<? extends Record1<T>> arg2) TheLT
operator.@NotNull Condition
TheLT
operator.@NotNull Condition
Row1.lt
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Field.ne
(QuantifiedSelect<? extends Record1<T>> arg2) TheNE
operator.@NotNull Condition
TheNE
operator.@NotNull Condition
Row1.ne
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Field.notEqual
(QuantifiedSelect<? extends Record1<T>> arg2) TheNOT_EQUAL
operator, an alias for theNE
operator.@NotNull Condition
TheNOT_EQUAL
operator, an alias for theNE
operator.@NotNull Condition
Row1.notEqual
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Create a condition to check this field against several values from a previous query.@NotNull Condition
TheNOT_IN
operator.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull LikeEscapeStep
Field.notLike
(QuantifiedSelect<? extends Record1<String>> pattern) TheNOT_LIKE
operator.@NotNull LikeEscapeStep
Field.notSimilarTo
(QuantifiedSelect<? extends Record1<String>> pattern) TheNOT_SIMILAR_TO
operator.Add an else clause to the already constructed case statement@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statementDeprecated, for removal: This API element is subject to removal in a future version.@NotNull Statement
Initialise this declaration.<T> @NotNull InsertOnDuplicateSetMoreStep
<R> Set values forUPDATE
in theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT … DO UPDATE
clause.<T> @NotNull InsertSetMoreStep
<R> Set a value for a field in theINSERT
statement.<T> @NotNull InsertSetMoreStep
<R> Set a value for a field in theINSERT
statement.<T> @NotNull MergeMatchedSetMoreStep
<R> Set values forUPDATE
in theMERGE
statement'sWHEN MATCHED
clause.<T> @NotNull MergeNotMatchedSetMoreStep
<R> Set values forINSERT
in theMERGE
statement'sWHEN NOT MATCHED
clause.@NotNull Statement
Assign a value to this set of variables.<T1> @NotNull UpdateFromStep
<R> Specify a multi-column set clause for theUPDATE
statement.<T> @NotNull UpdateSetMoreStep
<R> Set a value for a field in theUPDATE
statement.@NotNull Statement
Assign a value to this variable.@NotNull LikeEscapeStep
Field.similarTo
(QuantifiedSelect<? extends Record1<String>> pattern) TheSIMILAR_TO
operator.<T> @NotNull JSONEntry
<T> 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> This construct can be used to create expressions of the type<T> @NotNull CaseConditionStep
<T> This construct can be used to create expressions of the type@NotNull CaseConditionStep
<T> Compare a condition to the already constructed case statement, return result if the condition holds true@NotNull CaseConditionStep
<T> Compare a condition to the already constructed case statement, return result if the condition holds true<T> @NotNull CaseWhenStep
<V, T> Compare a value to the already constructed case statement, return result if values are equal.<T> @NotNull CaseWhenStep
<V, T> Compare a value to the already constructed case statement, return result if values are equal. -
Uses of Record1 in org.jooq.impl
Modifier and TypeMethodDescriptionDefaultDSLContext.fetchOptionalValue
(ResultQuery<R> query) <T,
R extends Record1<T>>
TDefaultDSLContext.fetchValue
(ResultQuery<R> query) DefaultDSLContext.fetchValues
(ResultQuery<R> query) Modifier and TypeMethodDescription<T1> Record1
<T1> DefaultDSLContext.fetchSingle
(SelectField<T1> field1) <T1> Record1
<T1> Modifier and TypeMethodDescriptiondefault QuantifiedSelect
<? extends Record1<String>> QOM.LikeQuantified.$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()
QOM.ArrayQuery.$query()
static <T> @NotNull QuantifiedSelect
<Record1<T>> Create anALL
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect
<Record1<T>> 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>> Create anANY
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect
<Record1<T>> 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.DSL.generateSeries
(int from, int to) A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries
(int from, int to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(int from, int to, Field<Integer> step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(int from, Field<Integer> to) A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries
(int from, Field<Integer> to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(int from, Field<Integer> to, Field<Integer> step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(Field<Integer> from, int to) A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries
(Field<Integer> from, int to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(Field<Integer> from, int to, Field<Integer> step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(Field<Integer> from, Field<Integer> to) A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries
(Field<Integer> from, Field<Integer> to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static <T1> @NotNull ArrayAggOrderByStep
<Result<Record1<T1>>> DSL.multisetAgg
(SelectField<T1> field1) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1> @NotNull ArrayAggOrderByStep
<Result<Record1<T1>>> DSL.multisetAggDistinct
(SelectField<T1> field1) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.SequenceImpl.nextvals
(int size) static <T1> @NotNull RecordType
<Record1<T1>> DSL.recordType
(Field<T1> field1) Create aRecordType
of degree1
.Deprecated, for removal: This API element is subject to removal in a future version.- [#11812] - 3.15.0 - UseRow1
as aSelectField
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.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.DefaultDSLContext.selectOne()
static @NotNull SelectSelectStep
<Record1<Integer>> DSL.selectOne()
Create a new DSL subselect statement for a constant1
literal.DefaultDSLContext.selectZero()
static @NotNull SelectSelectStep
<Record1<Integer>> DSL.selectZero()
Create a new DSL subselect statement for a constant0
literal.Create aVALUES()
expression of degree1
.Modifier and TypeMethodDescriptiondefault @NotNull QOM.LikeQuantified
QOM.LikeQuantified.$pattern
(QuantifiedSelect<? extends Record1<String>> 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[]> The PostgreSQLarray(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> 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> A constructor for JSON entries to be used withDSL.jsonObject(JSONEntry...)
.static <T> @NotNull JSONEntry
<T> A constructor for JSON entries to be used withDSL.jsonObject(JSONEntry...)
.static @NotNull JSONObjectNullStep
<JSON> DSL.jsonObject
(Field<String> key, Select<? extends Record1<?>> value) The JSON object constructor.static <T> @NotNull CaseConditionStep
<T> Initialise aCase
statement.static <T> @NotNull CaseConditionStep
<T> Initialise aCase
statement.
DSLContext.mergeInto(Table)