Uses of Interface
org.jooq.Record1
-
Packages that use Record1 Package Description org.jooq Theorg.jooqpackage contains jOOQ's public API.org.jooq.impl Theorg.jooq.implpackage contains jOOQ's implementation classes.org.jooq.util.postgres Theorg.jooq.util.asepackage contains classes related to theSQLDialect.POSTGRESdialect. -
-
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 theDerivedColumnListto form a common table expression.<R extends Record1<?>>
@NotNull CommonTableExpression<R>DerivedColumnList1. asMaterialized(Select<R> select)Specify a materialized subselect to refer to by theDerivedColumnListto 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 theDerivedColumnListto form a common table expression.<T,R extends Record1<T>>
@NotNull Optional<T>DSLContext. fetchOptionalValue(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return a single value.<T,R extends Record1<T>>
TDSLContext. fetchValue(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return a single value.<T,R extends Record1<T>>
@NotNull List<T>DSLContext. fetchValues(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand 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 JSONclause.@NotNull SelectForJSONStep<Record1<JSONB>>SelectForStep. forJSONB()Add a SQL Server-styleFOR JSONclause.@NotNull SelectForXMLStep<Record1<XML>>SelectForStep. forXML()Add a SQL Server-styleFOR XMLclause.<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 theDELETEstatement to return a list of fields inR.<T1> @NotNull InsertResultStep<Record1<T1>>InsertReturningStep. returningResult(SelectField<T1> field1)Configure theINSERTstatement to return a list of fields inR.<T1> @NotNull UpdateResultStep<Record1<T1>>UpdateReturningStep. returningResult(SelectField<T1> field1)Configure theUPDATEstatement 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 constant1literal.@NotNull SelectSelectStep<Record1<Integer>>WithStep. selectOne()Create a new DSL select statement for a constant1literal.@NotNull SelectSelectStep<Record1<Integer>>DSLContext. selectZero()Create a new DSL select statement for a constant0literal.@NotNull SelectSelectStep<Record1<Integer>>WithStep. selectZero()Create a new DSL select statement for a constant0literal.Methods in org.jooq with parameters of type Record1 Modifier and Type Method Description @NotNull ConditionBetweenAndStep1. 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 ConditionRow1. 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 ConditionRow1. betweenSymmetric(Record1<T1> minValue, Record1<T1> maxValue)Check if this row value expression is within a symmetric range of two records.@NotNull ConditionRow1. compare(Comparator comparator, Record1<T1> record)Compare this row value expression with a record using a dynamic comparator.@NotNull ConditionRow1. eq(Record1<T1> record)Compare this row value expression with a record for equality.@NotNull ConditionRow1. equal(Record1<T1> record)Compare this row value expression with a record for equality.@NotNull ConditionRow1. ge(Record1<T1> record)Compare this row value expression with a record for order.@NotNull ConditionRow1. greaterOrEqual(Record1<T1> record)Compare this row value expression with a record for order.@NotNull ConditionRow1. greaterThan(Record1<T1> record)Compare this row value expression with a record for order.@NotNull ConditionRow1. gt(Record1<T1> record)Compare this row value expression with a record for order.@NotNull ConditionRow1. in(Record1<T1>... record)Compare this row value expression with a set of records for equality.@NotNull ConditionRow1. isDistinctFrom(Record1<T1> record)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow1. isNotDistinctFrom(Record1<T1> record)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow1. le(Record1<T1> record)Compare this row value expression with a record for order.@NotNull ConditionRow1. lessOrEqual(Record1<T1> record)Compare this row value expression with a record for order.@NotNull ConditionRow1. lessThan(Record1<T1> record)Compare this row value expression with a record for order.@NotNull ConditionRow1. lt(Record1<T1> record)Compare this row value expression with a record for order.@NotNull ConditionRow1. 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 ConditionRow1. 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 ConditionRow1. notBetweenSymmetric(Record1<T1> minValue, Record1<T1> maxValue)Check if this row value expression is not within a symmetric range of two records.@NotNull ConditionRow1. notEqual(Record1<T1> record)Compare this row value expression with a record for non-equality@NotNull ConditionRow1. 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> voidUpdateQuery. addValues(Row1<T1> row, Select<? extends Record1<T1>> select)Specify a multi-column set clause for theUPDATEstatement.@NotNull WithStepWithAsStep1. as(Select<? extends Record1<?>> select)Associate a subselect with a common table expression's table and column names.@NotNull WithStepWithAsStep1. asMaterialized(Select<? extends Record1<?>> select)Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStepWithAsStep1. asNotMaterialized(Select<? extends Record1<?>> select)Associate a non-materialized subselect with a common table expression's table and column names.@NotNull ConditionField. compare(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query)Compare this field with a quantified subselect using a dynamic comparator.@NotNull ConditionField. compare(Comparator comparator, Select<? extends Record1<T>> query)Compare this field with a subselect using a dynamic comparator.@NotNull ConditionRow1. compare(Comparator comparator, QuantifiedSelect<? extends Record1<T1>> select)Compare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionRow1. 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 ConditionField. eq(QuantifiedSelect<? extends Record1<T>> query)this = [quantifier] (Select<?> ...).@NotNull ConditionField. eq(Select<? extends Record1<T>> query)this = (Select<?> ...).@NotNull ConditionRow1. eq(QuantifiedSelect<? extends Record1<T1>> select)Compare this row value expression with a subselect for equality.@NotNull ConditionRow1. eq(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for equality.@NotNull ConditionField. equal(QuantifiedSelect<? extends Record1<T>> query)this = [quantifier] (Select<?> ...).@NotNull ConditionField. equal(Select<? extends Record1<T>> query)this = (Select<?> ...).@NotNull ConditionRow1. equal(QuantifiedSelect<? extends Record1<T1>> select)Compare this row value expression with a subselect for equality.@NotNull ConditionRow1. equal(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for equality.<T> TDSLContext. 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 ConditionField. ge(QuantifiedSelect<? extends Record1<T>> query)this >= [quantifier] (Select<?> ...).@NotNull ConditionField. ge(Select<? extends Record1<T>> query)this >= (Select<?> ...).@NotNull ConditionRow1. ge(QuantifiedSelect<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow1. ge(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionField. greaterOrEqual(QuantifiedSelect<? extends Record1<T>> query)this >= [quantifier] (Select<?> ...).@NotNull ConditionField. greaterOrEqual(Select<? extends Record1<T>> query)this >= (Select<?> ...).@NotNull ConditionRow1. greaterOrEqual(QuantifiedSelect<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow1. greaterOrEqual(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionField. greaterThan(QuantifiedSelect<? extends Record1<T>> query)this > [quantifier] (Select<?> ...).@NotNull ConditionField. greaterThan(Select<? extends Record1<T>> query)this > (Select<?> ...).@NotNull ConditionRow1. greaterThan(QuantifiedSelect<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow1. greaterThan(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionField. gt(QuantifiedSelect<? extends Record1<T>> query)this > [quantifier] (Select<?> ...).@NotNull ConditionField. gt(Select<? extends Record1<T>> query)this > (Select<?> ...).@NotNull ConditionRow1. gt(QuantifiedSelect<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow1. gt(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionField. in(Result<? extends Record1<T>> result)Create a condition to check this field against several values from a previous query.@NotNull ConditionField. in(Select<? extends Record1<T>> query)Create a condition to check this field against a subquery.@NotNull ConditionRow1. in(Result<? extends Record1<T1>> result)Compare this row value expression with a set of records for equality.@NotNull ConditionRow1. in(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for equality.@NotNull ConditionField. isDistinctFrom(Select<? extends Record1<T>> select)Create a condition to check if this field isDISTINCTfrom another field.@NotNull ConditionRow1. isDistinctFrom(Select<? extends Record1<T1>> select)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionField. isNotDistinctFrom(Select<? extends Record1<T>> select)Create a condition to check if this field isNOT DISTINCTfrom another field.@NotNull ConditionRow1. isNotDistinctFrom(Select<? extends Record1<T1>> select)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionField. le(QuantifiedSelect<? extends Record1<T>> query)this <= [quantifier] (Select<?> ...).@NotNull ConditionField. le(Select<? extends Record1<T>> query)this <= (Select<?> ...).@NotNull ConditionRow1. le(QuantifiedSelect<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow1. le(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionField. lessOrEqual(QuantifiedSelect<? extends Record1<T>> query)this <= [quantifier] (Select<?> ...).@NotNull ConditionField. lessOrEqual(Select<? extends Record1<T>> query)this <= (Select<?> ...).@NotNull ConditionRow1. lessOrEqual(QuantifiedSelect<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow1. lessOrEqual(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionField. lessThan(QuantifiedSelect<? extends Record1<T>> query)this < [quantifier] (Select<?> ...).@NotNull ConditionField. lessThan(Select<? extends Record1<T>> query)this < (Select<?> ...).@NotNull ConditionRow1. lessThan(QuantifiedSelect<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow1. lessThan(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull LikeEscapeStepField. like(QuantifiedSelect<Record1<String>> query)Create a condition to pattern-check this field against a quantified select.@NotNull ConditionField. lt(QuantifiedSelect<? extends Record1<T>> query)this < [quantifier] (Select<?> ...).@NotNull ConditionField. lt(Select<? extends Record1<T>> query)this < (Select<?> ...).@NotNull ConditionRow1. lt(QuantifiedSelect<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow1. lt(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for order.@NotNull ConditionField. ne(QuantifiedSelect<? extends Record1<T>> query)this != [quantifier] (Select<?> ...).@NotNull ConditionField. ne(Select<? extends Record1<T>> query)this != (Select<?> ...).@NotNull ConditionRow1. ne(QuantifiedSelect<? extends Record1<T1>> select)Compare this row value expression with a subselect for non-equality.@NotNull ConditionRow1. ne(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for non-equality.@NotNull ConditionField. notEqual(QuantifiedSelect<? extends Record1<T>> query)this != [quantifier] (Select<?> ...).@NotNull ConditionField. notEqual(Select<? extends Record1<T>> query)this != (Select<?> ...).@NotNull ConditionRow1. notEqual(QuantifiedSelect<? extends Record1<T1>> select)Compare this row value expression with a subselect for non-equality.@NotNull ConditionRow1. notEqual(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for non-equality.@NotNull ConditionField. notIn(Result<? extends Record1<T>> result)Create a condition to check this field against several values from a previous query.@NotNull ConditionField. notIn(Select<? extends Record1<T>> query)Create a condition to check this field against a subquery.@NotNull ConditionRow1. notIn(Result<? extends Record1<T1>> result)Compare this row value expression with a set of records for equality.@NotNull ConditionRow1. notIn(Select<? extends Record1<T1>> select)Compare this row value expression with a subselect for non-equality.@NotNull LikeEscapeStepField. 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 aSELECTstatement as the source of values for theINSERTstatement@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 StatementDeclaration. 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 forUPDATEin theINSERTstatement'sON DUPLICATE KEY UPDATEorON CONFLICT ...<T> @NotNull InsertSetMoreStep<R>InsertSetMoreStep. set(Field<T> field, Select<? extends Record1<T>> value)Set a value for a field in theINSERTstatement.<T> @NotNull InsertSetMoreStep<R>InsertSetStep. set(Field<T> field, Select<? extends Record1<T>> value)Set a value for a field in theINSERTstatement.<T> @NotNull MergeMatchedSetMoreStep<R>MergeMatchedSetStep. set(Field<T> field, Select<? extends Record1<T>> value)Set values forUPDATEin theMERGEstatement'sWHEN MATCHEDclause.<T> @NotNull MergeNotMatchedSetMoreStep<R>MergeNotMatchedSetStep. set(Field<T> field, Select<? extends Record1<T>> value)Set values forINSERTin theMERGEstatement'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 theUPDATEstatement.<T> @NotNull UpdateSetMoreStep<R>UpdateSetStep. set(Field<T> field, Select<? extends Record1<T>> value)Set a value for a field in theUPDATEstatement.@NotNull StatementVariable. set(Select<? extends Record1<T>> value)Assign a value to this variable.<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 anALLquantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>DSL. all(Field<T>... fields)Create anALLquantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>DSL. all(T... array)Create anALLquantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>DSL. any(Field<T[]> array)Create anANYquantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>DSL. any(Field<T>... fields)Create anANYquantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>DSL. any(T... array)Create anANYquantified 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 fromfromtoto(inclusive).static @NotNull Table<Record1<Integer>>DSL. generateSeries(int from, int to, int step)A table function generating a series of values fromfromtoto(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 fromfromtoto(inclusive), increasing values bystep.static @NotNull Table<Record1<Integer>>DSL. generateSeries(int from, Field<Integer> to)A table function generating a series of values fromfromtoto(inclusive).static @NotNull Table<Record1<Integer>>DSL. generateSeries(int from, Field<Integer> to, int step)A table function generating a series of values fromfromtoto(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 fromfromtoto(inclusive), increasing values bystep.static @NotNull Table<Record1<Integer>>DSL. generateSeries(Field<Integer> from, int to)A table function generating a series of values fromfromtoto(inclusive).static @NotNull Table<Record1<Integer>>DSL. generateSeries(Field<Integer> from, int to, int step)A table function generating a series of values fromfromtoto(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 fromfromtoto(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 fromfromtoto(inclusive).static @NotNull Table<Record1<Integer>>DSL. generateSeries(Field<Integer> from, Field<Integer> to, int step)A table function generating a series of values fromfromtoto(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 fromfromtoto(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 aRecordTypeof degree1.static <T1> @NotNull Field<Record1<T1>>DSL. rowField(Row1<T1> row)EXPERIMENTAL: Turn a row value expression of degree1into 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 constant1literal.SelectSelectStep<Record1<Integer>>DefaultDSLContext. selectZero()static @NotNull SelectSelectStep<Record1<Integer>>DSL. selectZero()Create a new DSL subselect statement for a constant0literal.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> TDefaultDSLContext. 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 aCasestatement.static <T> @NotNull CaseConditionStep<T>DSL. when(Field<Boolean> condition, Select<? extends Record1<T>> result)Initialise aCasestatement. -
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.
-