Uses of Interface
org.jooq.SelectFieldOrAsterisk
Packages that use SelectFieldOrAsterisk
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of SelectFieldOrAsterisk in org.jooq
Subinterfaces of SelectFieldOrAsterisk in org.jooqModifier and TypeInterfaceDescriptioninterfaceThe step in the specification of aggregate functions where the SQL:2003 standardFILTER clausecan be added.interfaceAn aggregate function.interfaceThe SQL standardARRAY_AGG()function.interfaceAn unqualified asterisk.interfaceThe final step in creating a case statement of the typeinterfaceCaseWhenStep<V,T>The final step in creating a case statement of the typeinterfaceField<T>A column expression.interfaceMySQL'sGROUP_CONCATfunction.interfaceMySQL'sGROUP_CONCATfunction.interfaceA step in the construction ofDSL.jsonArrayAgg(Field)orDSL.jsonbArrayAgg(Field)functions where theNULLclause can be defined.interfaceA step in the construction ofDSL.jsonArrayAgg(Field)orDSL.jsonbArrayAgg(Field)functions where theORDER BYclause can be defined.interfaceA step in the construction ofDSL.jsonArrayAgg(Field)orDSL.jsonbArrayAgg(Field)functions where theRETURNINGclause can be defined.interfaceA step in the construction of theJSON ARRAYfunction.interfaceA step in the construction of theJSON ARRAYfunction.interfaceA step in the construction ofDSL.jsonObjectAgg(JSONEntry)orDSL.jsonbObjectAgg(JSONEntry)functions where theNULLclause can be defined.interfaceA step in the construction ofDSL.jsonObjectAgg(JSONEntry)orDSL.jsonbObjectAgg(JSONEntry)functions where theRETURNINGclause can be defined.interfaceA step in the construction of theJSON OBJECTfunction.interfaceA step in the construction of theJSON OBJECTfunction.interfaceA step in the construction ofDSL.jsonValue(Field, Field)orDSL.jsonbValue(Field, Field)functions where theON EMPTYandON ERRORclauses can be defined.interfaceA step in the construction of theJSON VALUEfunction.interfaceParam<T>A named parameter and/or bind value.interfaceParameter<T>A parameter to a stored procedure or function.interfaceinterfaceA qualified asterisk.interfaceRow1<T1>A row value expression.interfaceRow10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>A row value expression.interfaceRow11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>A row value expression.interfaceRow12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>A row value expression.interfaceRow13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>A row value expression.interfaceRow14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>A row value expression.interfaceRow15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>A row value expression.interfaceRow16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>A row value expression.interfaceRow17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>A row value expression.interfaceRow18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>A row value expression.interfaceRow19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>A row value expression.interfaceRow2<T1,T2>A row value expression.interfaceRow20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>A row value expression.interfaceRow21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>A row value expression.interfaceRow22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>A row value expression.interfaceRow3<T1,T2,T3>A row value expression.interfaceRow4<T1,T2,T3,T4>A row value expression.interfaceRow5<T1,T2,T3,T4,T5>A row value expression.interfaceRow6<T1,T2,T3,T4,T5,T6>A row value expression.interfaceRow7<T1,T2,T3,T4,T5,T6,T7>A row value expression.interfaceRow8<T1,T2,T3,T4,T5,T6,T7,T8>A row value expression.interfaceRow9<T1,T2,T3,T4,T5,T6,T7,T8,T9>A row value expression.interfaceA row value expression.interfaceSelectField<T>AQueryPartto be used exclusively inSELECTclauses.interfaceTableField<R extends Record,T>A field contained in a table.interfaceA field contained in a UDT.interfaceVariable<T>A local variable reference.interfaceThis type is used for the window function DSL API.interfaceThis type is used for the window function DSL API.interfaceDeprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interfaceThis type is used for the window function DSL API.interfaceThis type is used for the window function DSL API.interfaceThis type is used for the window function DSL API.interfaceThe SQL standardARRAY_AGG()function.Methods in org.jooq with parameters of type SelectFieldOrAsteriskModifier and TypeMethodDescriptionvoidSelectQuery.addDistinctOn(SelectFieldOrAsterisk... fields)Add a PostgreSQL-specificDISTINCT ON (fields...)clause.voidSelectQuery.addSelect(SelectFieldOrAsterisk... fields)Add a list of select fields.@NotNull SelectIntoStep<R>SelectDistinctOnStep.distinctOn(SelectFieldOrAsterisk... fields)Add the PostgreSQL-specificON(...)clause to aSELECT DISTINCT ON (...)statement.@NotNull SelectIntoStep<R>SelectDistinctOnStep.on(SelectFieldOrAsterisk... fields)Add the PostgreSQL-specificON(...)clause to aSELECT DISTINCT ON (...)statement.@NotNull DeleteResultStep<R>DeleteReturningStep.returning(SelectFieldOrAsterisk... fields)Configure theDELETEstatement to return a list of fields inR.@NotNull InsertResultStep<R>InsertReturningStep.returning(SelectFieldOrAsterisk... fields)Configure theINSERTstatement to return a list of fields inR.@NotNull UpdateResultStep<R>UpdateReturningStep.returning(SelectFieldOrAsterisk... fields)Configure theUPDATEstatement to return a list of fields inR.@NotNull DeleteResultStep<Record>DeleteReturningStep.returningResult(SelectFieldOrAsterisk... fields)Configure theDELETEstatement to return a list of fields inR.@NotNull InsertResultStep<Record>InsertReturningStep.returningResult(SelectFieldOrAsterisk... fields)Configure theINSERTstatement to return a list of fields inR.@NotNull UpdateResultStep<Record>UpdateReturningStep.returningResult(SelectFieldOrAsterisk... fields)Configure theUPDATEstatement to return a list of fields inR.@NotNull SelectSelectStep<Record>DSLContext.select(SelectFieldOrAsterisk... fields)Create a new DSL select statement.@NotNull SelectSelectStep<Record>SelectSelectStep.select(SelectFieldOrAsterisk... fields)Add additional fields to theSELECTclause of this query@NotNull SelectSelectStep<Record>WithStep.select(SelectFieldOrAsterisk... fields)Create a new DSL select statement.@NotNull SelectSelectStep<Record>DSLContext.selectDistinct(SelectFieldOrAsterisk... fields)Create a new DSL select statement.@NotNull SelectSelectStep<Record>WithStep.selectDistinct(SelectFieldOrAsterisk... fields)Create a new DSL select statement.voidDeleteQuery.setReturning(SelectFieldOrAsterisk... fields)Configure theDELETEstatement to return a list of fields inR.voidInsertQuery.setReturning(SelectFieldOrAsterisk... fields)Configure theINSERTorUPDATEstatement to return a list of fields inR.voidStoreQuery.setReturning(SelectFieldOrAsterisk... fields)Configure theINSERTorUPDATEstatement to return a list of fields inR.voidUpdateQuery.setReturning(SelectFieldOrAsterisk... fields)Configure theINSERTorUPDATEstatement to return a list of fields inR.Method parameters in org.jooq with type arguments of type SelectFieldOrAsteriskModifier and TypeMethodDescriptionvoidSelectQuery.addDistinctOn(Collection<? extends SelectFieldOrAsterisk> fields)Add a PostgreSQL-specificDISTINCT ON (fields...)clause.voidSelectQuery.addSelect(Collection<? extends SelectFieldOrAsterisk> fields)Add a list of select fields.@NotNull SelectIntoStep<R>SelectDistinctOnStep.distinctOn(Collection<? extends SelectFieldOrAsterisk> fields)Add the PostgreSQL-specificON(...)clause to aSELECT DISTINCT ON (...)statement.@NotNull SelectIntoStep<R>SelectDistinctOnStep.on(Collection<? extends SelectFieldOrAsterisk> fields)Add the PostgreSQL-specificON(...)clause to aSELECT DISTINCT ON (...)statement.@NotNull DeleteResultStep<R>DeleteReturningStep.returning(Collection<? extends SelectFieldOrAsterisk> fields)Configure theDELETEstatement to return a list of fields inR.@NotNull InsertResultStep<R>InsertReturningStep.returning(Collection<? extends SelectFieldOrAsterisk> fields)Configure theINSERTstatement to return a list of fields inR.@NotNull UpdateResultStep<R>UpdateReturningStep.returning(Collection<? extends SelectFieldOrAsterisk> fields)Configure theUPDATEstatement to return a list of fields inR.@NotNull DeleteResultStep<Record>DeleteReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields)Configure theDELETEstatement to return a list of fields inR.@NotNull InsertResultStep<Record>InsertReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields)Configure theINSERTstatement to return a list of fields inR.@NotNull UpdateResultStep<Record>UpdateReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields)Configure theUPDATEstatement to return a list of fields inR.@NotNull SelectSelectStep<Record>DSLContext.select(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL select statement.@NotNull SelectSelectStep<Record>SelectSelectStep.select(Collection<? extends SelectFieldOrAsterisk> fields)Add additional fields to theSELECTclause of this query@NotNull SelectSelectStep<Record>WithStep.select(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL select statement.@NotNull SelectSelectStep<Record>DSLContext.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL select statement.@NotNull SelectSelectStep<Record>WithStep.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL select statement.voidDeleteQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields)Configure theDELETEstatement to return a list of fields inR.voidInsertQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields)Configure theINSERTorUPDATEstatement to return a list of fields inR.voidStoreQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields)Configure theINSERTorUPDATEstatement to return a list of fields inR.voidUpdateQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields)Configure theINSERTorUPDATEstatement to return a list of fields inR. -
Uses of SelectFieldOrAsterisk in org.jooq.impl
Classes in org.jooq.impl that implement SelectFieldOrAsteriskModifier and TypeClassDescriptionclassCustomField<T>A base class for customFieldimplementations in client code.Methods in org.jooq.impl with parameters of type SelectFieldOrAsteriskModifier and TypeMethodDescriptionstatic @NotNull AggregateFunction<Integer>DSL.count(SelectFieldOrAsterisk field)Get the count(field) function.static @NotNull AggregateFunction<Integer>DSL.countDistinct(SelectFieldOrAsterisk field)Get the count(distinct field) function.DefaultDSLContext.select(SelectFieldOrAsterisk... fields)static @NotNull SelectSelectStep<Record>DSL.select(SelectFieldOrAsterisk... fields)Create a new DSL subselect statement.DefaultDSLContext.selectDistinct(SelectFieldOrAsterisk... fields)static @NotNull SelectSelectStep<Record>DSL.selectDistinct(SelectFieldOrAsterisk... fields)Create a new DSL subselect statement.Method parameters in org.jooq.impl with type arguments of type SelectFieldOrAsteriskModifier and TypeMethodDescriptionDefaultDSLContext.select(Collection<? extends SelectFieldOrAsterisk> fields)static @NotNull SelectSelectStep<Record>DSL.select(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL subselect statement.DefaultDSLContext.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)static @NotNull SelectSelectStep<Record>DSL.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)Create a new DSL subselect statement.