Uses of Interface
org.jooq.SelectFieldOrAsterisk

Packages that use SelectFieldOrAsterisk

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.

Uses of SelectFieldOrAsterisk in org.jooq

Subinterfaces of SelectFieldOrAsterisk in org.jooq

Modifier and Type	Interface	Description
interface	AggregateFilterStep<T>	The step in the specification of aggregate functions where the SQL:2003 standard FILTER clause can be added.
interface	AggregateFunction<T>	An aggregate function.
interface	ArrayAggOrderByStep<T>	The SQL standard ARRAY_AGG() function.
interface	Asterisk	An unqualified asterisk.
interface	CaseConditionStep<T>	The final step in creating a case statement of the type
interface	CaseWhenStep<V,T>	The final step in creating a case statement of the type
interface	CommonTableExpression<R extends Record>	A common table expression.
interface	Condition	A condition or predicate.
interface	False	A Condition that always yields false.
interface	Field<T>	A column expression.
interface	GroupConcatOrderByStep	MySQL's GROUP_CONCAT function.
interface	GroupConcatSeparatorStep	MySQL's GROUP_CONCAT function.
interface	JSONArrayAggNullStep<T>	A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the NULL clause can be defined.
interface	JSONArrayAggOrderByStep<J>	A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the ORDER BY clause can be defined.
interface	JSONArrayAggReturningStep<T>	A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the RETURNING clause can be defined.
interface	JSONArrayNullStep<T>	A step in the construction of the JSON ARRAY function.
interface	JSONArrayReturningStep<T>	A step in the construction of the JSON ARRAY function.
interface	JSONExistsOnStep	A step in the construction of DSL.jsonExists(Field, Field) or DSL.jsonbExists(Field, Field) functions where the ON ERROR clause can be defined.
interface	JSONObjectAggNullStep<T>	A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the NULL clause can be defined.
interface	JSONObjectAggReturningStep<T>	A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the RETURNING clause can be defined.
interface	JSONObjectNullStep<T>	A step in the construction of the JSON OBJECT function.
interface	JSONObjectReturningStep<T>	A step in the construction of the JSON OBJECT function.
interface	JSONTableColumnPathStep	A step in the construction of an JSON_TABLE expression.
interface	JSONTableColumnsStep	A step in the construction of an JSON_TABLE expression.
interface	JSONValueOnStep<J>	A step in the construction of DSL.jsonValue(Field, Field) or DSL.jsonbValue(Field, Field) functions where the ON EMPTY and ON ERROR clauses can be defined.
interface	JSONValueReturningStep<T>	A step in the construction of the JSON VALUE function.
interface	LikeEscapeStep	A step in the construction of the LIKE function.
interface	Null	A Condition that always yields null.
interface	OptionallyOrderedAggregateFunction<T>	An ordered-set aggregate function.
interface	Param<T>	A named parameter and/or bind value.
interface	Parameter<T>	A parameter to a stored procedure or function.
interface	ParamOrVariable<T>	A common super type of Param and Variable.
interface	QualifiedAsterisk	A qualified asterisk.
interface	Row1<T1>	A row value expression.
interface	Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	A row value expression.
interface	Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	A row value expression.
interface	Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	A row value expression.
interface	Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	A row value expression.
interface	Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	A row value expression.
interface	Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	A row value expression.
interface	Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	A row value expression.
interface	Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	A row value expression.
interface	Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	A row value expression.
interface	Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	A row value expression.
interface	Row2<T1,T2>	A row value expression.
interface	Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	A row value expression.
interface	Row21<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.
interface	Row22<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.
interface	Row3<T1,T2,T3>	A row value expression.
interface	Row4<T1,T2,T3,T4>	A row value expression.
interface	Row5<T1,T2,T3,T4,T5>	A row value expression.
interface	Row6<T1,T2,T3,T4,T5,T6>	A row value expression.
interface	Row7<T1,T2,T3,T4,T5,T6,T7>	A row value expression.
interface	Row8<T1,T2,T3,T4,T5,T6,T7,T8>	A row value expression.
interface	Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>	A row value expression.
interface	RowN	A row value expression.
interface	SelectField<T>	A QueryPart to be used exclusively in SELECT clauses.
interface	Table<R extends Record>	A table.
interface	TableField<R extends Record,T>	A field contained in a table.
interface	TableOnConditionStep<R extends Record>	An intermediate (optional) type for the construction of a JOIN clause, where the join criteria is added using an ON clause (with a Condition.
interface	TableOptionalOnStep<R extends Record>	An intermediate type for the construction of a JOIN clause, where there may optionally be a join criteria added using an ON clause (with a Condition), or using a USING clause (with a list of Field)
interface	True	A Condition that always yields true.
interface	UDTField<R extends UDTRecord<R>,T>	A field contained in a UDT.
interface	UDTPathField<R extends Record,U extends UDTRecord<U>,T>	A field dereferenced from a UDT path.
interface	UDTPathTableField<R extends Record,U extends UDTRecord<U>,T>	A field dereferenced from a UDT path.
interface	Variable<T>	A local variable reference.
interface	WindowBeforeOverStep<T>	This type is used for the window function DSL API.
interface	WindowExcludeStep<T>	This type is used for the window function DSL API.
interface	WindowFinalStep<T>	Deprecated, 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.
interface	WindowOrderByStep<T>	This type is used for the window function DSL API.
interface	WindowPartitionByStep<T>	This type is used for the window function DSL API.
interface	WindowRowsStep<T>	This type is used for the window function DSL API.
interface	XMLAggOrderByStep<T>	The SQL standard ARRAY_AGG() function.
interface	XMLTableColumnPathStep	A step in the construction of an XMLTABLE expression.
interface	XMLTableColumnsStep	A step in the construction of an XMLTABLE expression.

Methods in org.jooq that return types with arguments of type SelectFieldOrAsterisk

Modifier and Type	Method	Description
@NotNull QOM.UnmodifiableList<? extends SelectFieldOrAsterisk>	Select.$distinctOn()	Experimental query object model accessor method, see also QOM.
@NotNull QOM.UnmodifiableList<? extends SelectFieldOrAsterisk>	Select.$select()	Experimental query object model accessor method, see also QOM.

Methods in org.jooq with parameters of type SelectFieldOrAsterisk

Modifier and Type	Method	Description
void	SelectQuery.addDistinctOn(SelectFieldOrAsterisk... fields)	Add a PostgreSQL-specific DISTINCT ON (fields…) clause.
void	SelectQuery.addSelect(SelectFieldOrAsterisk... fields)	Add a list of select fields.
@NotNull SelectIntoStep<R>	SelectDistinctOnStep.distinctOn(SelectFieldOrAsterisk... fields)	Add the PostgreSQL-specific ON(…) clause to a SELECT DISTINCT ON (…) statement.
@NotNull SelectIntoStep<R>	SelectDistinctOnStep.on(SelectFieldOrAsterisk... fields)	Add the PostgreSQL-specific ON(…) clause to a SELECT DISTINCT ON (…) statement.
@NotNull DeleteResultStep<R>	DeleteReturningStep.returning(SelectFieldOrAsterisk... fields)	Configure the DELETE statement to return a list of fields in R.
@NotNull InsertResultStep<R>	InsertReturningStep.returning(SelectFieldOrAsterisk... fields)	Configure the INSERT statement to return a list of fields in R.
@NotNull UpdateResultStep<R>	UpdateReturningStep.returning(SelectFieldOrAsterisk... fields)	Configure the UPDATE statement to return a list of fields in R.
@NotNull DeleteResultStep<Record>	DeleteReturningStep.returningResult(SelectFieldOrAsterisk... fields)	Configure the DELETE statement to return a list of fields in R.
@NotNull InsertResultStep<Record>	InsertReturningStep.returningResult(SelectFieldOrAsterisk... fields)	Configure the INSERT statement to return a list of fields in R.
@NotNull UpdateResultStep<Record>	UpdateReturningStep.returningResult(SelectFieldOrAsterisk... fields)	Configure the UPDATE statement to return a list of fields in R.
@NotNull SelectSelectStep<Record>	DSLContext.select(SelectFieldOrAsterisk... fields)	Create a new DSL select statement.
@NotNull SelectSelectStep<Record>	SelectSelectStep.select(SelectFieldOrAsterisk... fields)	Add additional fields to the SELECT clause 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.
void	DeleteQuery.setReturning(SelectFieldOrAsterisk... fields)	Configure the DELETE statement to return a list of fields in R.
void	InsertQuery.setReturning(SelectFieldOrAsterisk... fields)	Configure the INSERT or UPDATE statement to return a list of fields in R.
void	StoreQuery.setReturning(SelectFieldOrAsterisk... fields)	Configure the INSERT or UPDATE statement to return a list of fields in R.
void	UpdateQuery.setReturning(SelectFieldOrAsterisk... fields)	Configure the INSERT or UPDATE statement to return a list of fields in R.

Method parameters in org.jooq with type arguments of type SelectFieldOrAsterisk

Modifier and Type	Method	Description
@NotNull Select<R>	Select.$distinctOn(Collection<? extends SelectFieldOrAsterisk> newDistinctOn)	Experimental query object model accessor method, see also QOM.
@NotNull Select<?>	Select.$select(Collection<? extends SelectFieldOrAsterisk> newSelect)	Experimental query object model accessor method, see also QOM.
void	SelectQuery.addDistinctOn(Collection<? extends SelectFieldOrAsterisk> fields)	Add a PostgreSQL-specific DISTINCT ON (fields…) clause.
void	SelectQuery.addSelect(Collection<? extends SelectFieldOrAsterisk> fields)	Add a list of select fields.
@NotNull SelectIntoStep<R>	SelectDistinctOnStep.distinctOn(Collection<? extends SelectFieldOrAsterisk> fields)	Add the PostgreSQL-specific ON(…) clause to a SELECT DISTINCT ON (…) statement.
@NotNull SelectIntoStep<R>	SelectDistinctOnStep.on(Collection<? extends SelectFieldOrAsterisk> fields)	Add the PostgreSQL-specific ON(…) clause to a SELECT DISTINCT ON (…) statement.
@NotNull DeleteResultStep<R>	DeleteReturningStep.returning(Collection<? extends SelectFieldOrAsterisk> fields)	Configure the DELETE statement to return a list of fields in R.
@NotNull InsertResultStep<R>	InsertReturningStep.returning(Collection<? extends SelectFieldOrAsterisk> fields)	Configure the INSERT statement to return a list of fields in R.
@NotNull UpdateResultStep<R>	UpdateReturningStep.returning(Collection<? extends SelectFieldOrAsterisk> fields)	Configure the UPDATE statement to return a list of fields in R.
@NotNull DeleteResultStep<Record>	DeleteReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields)	Configure the DELETE statement to return a list of fields in R.
@NotNull InsertResultStep<Record>	InsertReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields)	Configure the INSERT statement to return a list of fields in R.
@NotNull UpdateResultStep<Record>	UpdateReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields)	Configure the UPDATE statement to return a list of fields in R.
@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 the SELECT clause 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.
void	DeleteQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields)	Configure the DELETE statement to return a list of fields in R.
void	InsertQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields)	Configure the INSERT or UPDATE statement to return a list of fields in R.
void	StoreQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields)	Configure the INSERT or UPDATE statement to return a list of fields in R.
void	UpdateQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields)	Configure the INSERT or UPDATE statement to return a list of fields in R.

Uses of SelectFieldOrAsterisk in org.jooq.impl

Subinterfaces of SelectFieldOrAsterisk in org.jooq.impl

Modifier and Type	Interface	Description
static interface	QOM.Abs<T extends Number>	The ABS function.
static interface	QOM.Acos	The ACOS function.
static interface	QOM.Acosh	The ACOSH function.
static interface	QOM.Acoth	The ACOTH function.
static interface	QOM.Add<T>	The ADD operator.
static interface	QOM.And	The AND operator.
static interface	QOM.AnyValue<T>	The ANY VALUE function.
static interface	QOM.Array<T>
static interface	QOM.ArrayAgg<T>
static interface	QOM.ArrayAllMatch<T>	The ARRAY ALL MATCH function.
static interface	QOM.ArrayAnyMatch<T>	The ARRAY ANY MATCH function.
static interface	QOM.ArrayAppend<T>	The ARRAY APPEND function.
static interface	QOM.ArrayConcat<T>	The ARRAY CONCAT function.
static interface	QOM.ArrayFilter<T>	The ARRAY FILTER function.
static interface	QOM.ArrayGet<T>	The ARRAY GET function.
static interface	QOM.ArrayMap<T,U>	The ARRAY MAP function.
static interface	QOM.ArrayNoneMatch<T>	The ARRAY NONE MATCH function.
static interface	QOM.ArrayOverlap<T>	The ARRAY OVERLAP function.
static interface	QOM.ArrayPrepend<T>	The ARRAY PREPEND function.
static interface	QOM.ArrayQuery<T>
static interface	QOM.ArrayRemove<T>	The ARRAY REMOVE function.
static interface	QOM.ArrayReplace<T>	The ARRAY REPLACE function.
static interface	QOM.Ascii	The ASCII function.
static interface	QOM.Asin	The ASIN function.
static interface	QOM.Asinh	The ASINH function.
static interface	QOM.Atan	The ATAN function.
static interface	QOM.Atan2	The ATAN2 function.
static interface	QOM.Atanh	The ATANH function.
static interface	QOM.Avg	The AVG function.
static interface	QOM.Between<T>	The BETWEEN predicate.
static interface	QOM.BinaryBitLength	The BINARY BIT LENGTH function.
static interface	QOM.BinaryConcat	The BINARY CONCAT function.
static interface	QOM.BinaryLength	The BINARY LENGTH function.
static interface	QOM.BinaryLike	The BINARY LIKE operator.
static interface	QOM.BinaryLikeQuantified	The BINARY LIKE operator.
static interface	QOM.BinaryLtrim	The BINARY LTRIM function.
static interface	QOM.BinaryMd5	The BINARY MD5 function.
static interface	QOM.BinaryOctetLength	The BINARY OCTET LENGTH function.
static interface	QOM.BinaryOverlay	The BINARY OVERLAY function.
static interface	QOM.BinaryPosition	The BINARY POSITION function.
static interface	QOM.BinaryRtrim	The BINARY RTRIM function.
static interface	QOM.BinarySubstring	The BINARY SUBSTRING function.
static interface	QOM.BinaryTrim	The BINARY TRIM function.
static interface	QOM.BinToUuid	The BIN TO UUID function.
static interface	QOM.BitAnd<T extends Number>	The BIT AND operator.
static interface	QOM.BitAndAgg<T extends Number>	The BIT AND AGG function.
static interface	QOM.BitCount	The BIT COUNT function.
static interface	QOM.BitGet<T extends Number>	The BIT GET function.
static interface	QOM.BitLength	The BIT LENGTH function.
static interface	QOM.BitNand<T extends Number>	The BIT NAND operator.
static interface	QOM.BitNandAgg<T extends Number>	The BIT NAND AGG function.
static interface	QOM.BitNor<T extends Number>	The BIT NOR operator.
static interface	QOM.BitNorAgg<T extends Number>	The BIT NOR AGG function.
static interface	QOM.BitNot<T extends Number>	The BIT NOT operator.
static interface	QOM.BitOr<T extends Number>	The BIT OR operator.
static interface	QOM.BitOrAgg<T extends Number>	The BIT OR AGG function.
static interface	QOM.BitSet<T extends Number>	The BIT SET function.
static interface	QOM.BitXNor<T extends Number>	The BIT X NOR operator.
static interface	QOM.BitXNorAgg<T extends Number>	The BIT X NOR AGG function.
static interface	QOM.BitXor<T extends Number>	The BIT XOR operator.
static interface	QOM.BitXorAgg<T extends Number>	The BIT XOR AGG function.
static interface	QOM.BoolAnd	The BOOL AND function.
static interface	QOM.BoolOr	The BOOL OR function.
static interface	QOM.Cardinality	The CARDINALITY function.
static interface	QOM.CaseSearched<T>
static interface	QOM.CaseSimple<V,T>
static interface	QOM.Cast<T>
static interface	QOM.Cbrt	The CBRT function.
static interface	QOM.Ceil<T extends Number>	The CEIL function.
static interface	QOM.CharLength	The CHAR LENGTH function.
static interface	QOM.Choose<T>
static interface	QOM.Chr	The CHR function.
static interface	QOM.Coalesce<T>
static interface	QOM.Coerce<T>
static interface	QOM.Collated
static interface	QOM.Collect<T,A extends ArrayRecord<T>>
static interface	QOM.CombinedCondition<R extends QOM.CombinedCondition<R>>	A Condition consisting of two Condition operands and a binary logic Operator.
static interface	QOM.CompareCondition<T,R extends QOM.CompareCondition<T,R>>	A Condition consisting of two Field operands and a Comparator operator.
static interface	QOM.Concat
static interface	QOM.ConditionAsField	The FIELD function.
static interface	QOM.ConnectByIsCycle	The CONNECT BY ISCYCLE function.
static interface	QOM.ConnectByIsLeaf	The CONNECT BY ISLEAF function.
static interface	QOM.ConnectByRoot<T>	The CONNECT BY ROOT function.
static interface	QOM.Contains<T>	The CONTAINS operator.
static interface	QOM.ContainsIgnoreCase<T>	The CONTAINS IGNORE CASE operator.
static interface	QOM.Convert<T>
static interface	QOM.Corr	The CORR function.
static interface	QOM.Cos	The COS function.
static interface	QOM.Cosh	The COSH function.
static interface	QOM.Cot	The COT function.
static interface	QOM.Coth	The COTH function.
static interface	QOM.Count	The COUNT function.
static interface	QOM.CountTable
static interface	QOM.CovarPop	The COVAR POP function.
static interface	QOM.CovarSamp	The COVAR SAMP function.
static interface	QOM.CrossApply<R extends Record>
static interface	QOM.CrossJoin<R extends Record>
static interface	QOM.CumeDist
static interface	QOM.CurrentCatalog	The CURRENT CATALOG function.
static interface	QOM.CurrentDate<T>
static interface	QOM.CurrentSchema	The CURRENT SCHEMA function.
static interface	QOM.CurrentTime<T>
static interface	QOM.CurrentTimestamp<T>
static interface	QOM.CurrentUser	The CURRENT USER function.
static interface	QOM.DataChangeDeltaTable<R extends Record>
static interface	QOM.DateAdd<T>	The DATE ADD function.
static interface	QOM.Decode<V,T>
static interface	QOM.Default<T>
static interface	QOM.Degrees	The DEGREES function.
static interface	QOM.Deleting	The DELETING function.
static interface	QOM.DenseRank
static interface	QOM.DerivedTable<R extends Record>
static interface	QOM.Digits	The DIGITS function.
static interface	QOM.Div<T>	The DIV operator.
static interface	QOM.Dual
static interface	QOM.EndsWith<T>	The ENDS WITH operator.
static interface	QOM.EndsWithIgnoreCase<T>	The ENDS WITH IGNORE CASE operator.
static interface	QOM.Eq<T>	The EQ operator.
static interface	QOM.EqQuantified<T>	The EQ operator.
static interface	QOM.Euler	The E function.
static interface	QOM.Excluded<T>	The EXCLUDED function.
static interface	QOM.Exists	The EXISTS function.
static interface	QOM.Exp	The EXP function.
static interface	QOM.Extract
static interface	QOM.False	A Condition that is always FALSE.
static interface	QOM.FieldAlias<T>
static interface	QOM.FieldCondition	The CONDITION function.
static interface	QOM.FieldFunction<T>
static interface	QOM.FirstValue<T>
static interface	QOM.Floor<T extends Number>	The FLOOR function.
static interface	QOM.FullJoin<R extends Record>
static interface	QOM.Function<T>
static interface	QOM.Ge<T>	The GE operator.
static interface	QOM.GenerateSeries<T>
static interface	QOM.GeQuantified<T>	The GE operator.
static interface	QOM.Greatest<T>
static interface	QOM.Gt<T>	The GT operator.
static interface	QOM.GtQuantified<T>	The GT operator.
static interface	QOM.HintedTable<R extends Record>	A table with a MySQL style index access hint.
static interface	QOM.Iif<T>
static interface	QOM.In<T>	The IN operator.
static interface	QOM.InList<T>	The IN predicate accepting a list of values.
static interface	QOM.Inserting	The INSERTING function.
static interface	QOM.IsDistinctFrom<T>	The IS DISTINCT FROM operator.
static interface	QOM.IsDocument	The IS DOCUMENT operator.
static interface	QOM.IsJson	The IS JSON operator.
static interface	QOM.IsNotDistinctFrom<T>	The IS NOT DISTINCT FROM operator.
static interface	QOM.IsNotDocument	The IS NOT DOCUMENT operator.
static interface	QOM.IsNotJson	The IS NOT JSON operator.
static interface	QOM.IsNotNull	The IS NOT NULL operator.
static interface	QOM.IsNull	The IS NULL operator.
static interface	QOM.Join<R extends Record>
static interface	QOM.JoinTable<R extends Record,J extends QOM.JoinTable<R,J>>
static interface	QOM.JSONArray<T>	The JSON ARRAY function.
static interface	QOM.JSONArrayAgg<J>
static interface	QOM.JSONArrayLength	The JSON ARRAY LENGTH function.
static interface	QOM.JSONBArrayLength	The JSONB ARRAY LENGTH function.
static interface	QOM.JSONBGetAttribute	The JSONB GET ATTRIBUTE function.
static interface	QOM.JSONBGetAttributeAsText	The JSONB GET ATTRIBUTE AS TEXT function.
static interface	QOM.JSONBGetElement	The JSONB GET ELEMENT function.
static interface	QOM.JSONBGetElementAsText	The JSONB GET ELEMENT AS TEXT function.
static interface	QOM.JSONBInsert	The JSONB INSERT function.
static interface	QOM.JSONBKeyExists	The JSONB KEY EXISTS function.
static interface	QOM.JSONBKeys	The JSONB KEYS function.
static interface	QOM.JSONBRemove	The JSONB REMOVE function.
static interface	QOM.JSONBReplace	The JSONB REPLACE function.
static interface	QOM.JSONBSet	The JSONB SET function.
static interface	QOM.JSONGetAttribute	The JSON GET ATTRIBUTE function.
static interface	QOM.JSONGetAttributeAsText	The JSON GET ATTRIBUTE AS TEXT function.
static interface	QOM.JSONGetElement	The JSON GET ELEMENT function.
static interface	QOM.JSONGetElementAsText	The JSON GET ELEMENT AS TEXT function.
static interface	QOM.JSONInsert	The JSON INSERT function.
static interface	QOM.JSONKeyExists	The JSON KEY EXISTS function.
static interface	QOM.JSONKeys	The JSON KEYS function.
static interface	QOM.JSONObject<T>	The JSON OBJECT function.
static interface	QOM.JSONObjectAgg<J>
static interface	QOM.JSONRemove	The JSON REMOVE function.
static interface	QOM.JSONReplace	The JSON REPLACE function.
static interface	QOM.JSONSet	The JSON SET function.
static interface	QOM.Lag<T>
static interface	QOM.LastValue<T>
static interface	QOM.Lateral<R extends Record>
static interface	QOM.Le<T>	The LE operator.
static interface	QOM.Lead<T>
static interface	QOM.Least<T>
static interface	QOM.Left	The LEFT function.
static interface	QOM.LeftAntiJoin<R extends Record>
static interface	QOM.LeftJoin<R extends Record>
static interface	QOM.LeftSemiJoin<R extends Record>
static interface	QOM.LeQuantified<T>	The LE operator.
static interface	QOM.Level	The LEVEL function.
static interface	QOM.Like	The LIKE operator.
static interface	QOM.LikeIgnoreCase	The LIKE IGNORE CASE operator.
static interface	QOM.LikeQuantified	The LIKE operator.
static interface	QOM.LinkedTable<R extends Record>	A table with a database link.
static interface	QOM.Ln	The LN function.
static interface	QOM.Log	The LOG function.
static interface	QOM.Log10	The LOG10 function.
static interface	QOM.Lower	The LOWER function.
static interface	QOM.Lpad	The LPAD function.
static interface	QOM.Lt<T>	The LT operator.
static interface	QOM.LtQuantified<T>	The LT operator.
static interface	QOM.Ltrim	The LTRIM function.
static interface	QOM.Max<T>	The MAX function.
static interface	QOM.MaxBy<T>	The MAX BY function.
static interface	QOM.Md5	The MD5 function.
static interface	QOM.Median	The MEDIAN function.
static interface	QOM.Min<T>	The MIN function.
static interface	QOM.MinBy<T>	The MIN BY function.
static interface	QOM.Mod<T extends Number>	The MOD operator.
static interface	QOM.Mode<T>
static interface	QOM.Mul<T>	The MUL operator.
static interface	QOM.Multiset<R extends Record>
static interface	QOM.MultisetAgg<R extends Record>
static interface	QOM.NaturalFullJoin<R extends Record>
static interface	QOM.NaturalJoin<R extends Record>
static interface	QOM.NaturalLeftJoin<R extends Record>
static interface	QOM.NaturalRightJoin<R extends Record>
static interface	QOM.Ne<T>	The NE operator.
static interface	QOM.Neg<T>
static interface	QOM.NeQuantified<T>	The NE operator.
static interface	QOM.Not	The NOT operator.
static interface	QOM.NotBinaryLike	The NOT BINARY LIKE operator.
static interface	QOM.NotBinaryLikeQuantified	The NOT BINARY LIKE operator.
static interface	QOM.NotField	The NOT operator.
static interface	QOM.NotIn<T>	The NOT IN operator.
static interface	QOM.NotInList<T>	The NOT IN predicate accepting a list of values.
static interface	QOM.NotLike	The NOT LIKE operator.
static interface	QOM.NotLikeIgnoreCase	The NOT LIKE IGNORE CASE operator.
static interface	QOM.NotLikeQuantified	The NOT LIKE operator.
static interface	QOM.NotSimilarTo	The NOT SIMILAR TO operator.
static interface	QOM.NotSimilarToQuantified	The NOT SIMILAR TO operator.
static interface	QOM.NthValue<T>
static interface	QOM.Ntile
static interface	QOM.Null	A Condition that is always NULL.
static interface	QOM.Nullif<T>	The NULLIF function.
static interface	QOM.Nvl<T>	The NVL function.
static interface	QOM.Nvl2<T>
static interface	QOM.OctetLength	The OCTET LENGTH function.
static interface	QOM.Or	The OR operator.
static interface	QOM.OuterApply<R extends Record>
static interface	QOM.Overlay	The OVERLAY function.
static interface	QOM.PercentRank
static interface	QOM.Pi	The PI function.
static interface	QOM.PlusJoin<T>	The PLUS operator.
static interface	QOM.Position	The POSITION function.
static interface	QOM.Power	The POWER operator.
static interface	QOM.Prior<T>	The PRIOR function.
static interface	QOM.Product	The PRODUCT function.
static interface	QOM.QualifiedJoin<R extends Record,J extends QOM.QualifiedJoin<R,J>>
static interface	QOM.QualifiedRowid	The ROWID operator.
static interface	QOM.Radians	The RADIANS function.
static interface	QOM.Rand	The RAND function.
static interface	QOM.Rank
static interface	QOM.RatioToReport
static interface	QOM.RegexpLike
static interface	QOM.RegrAvgX	The REGR AVGX function.
static interface	QOM.RegrAvgY	The REGR AVGY function.
static interface	QOM.RegrCount	The REGR COUNT function.
static interface	QOM.RegrIntercept	The REGR INTERCEPT function.
static interface	QOM.RegrR2	The REGR R2 function.
static interface	QOM.RegrSlope	The REGR SLOPE function.
static interface	QOM.RegrSxx	The REGR SXX function.
static interface	QOM.RegrSxy	The REGR SXY function.
static interface	QOM.RegrSyy	The REGR SYY function.
static interface	QOM.Repeat	The REPEAT function.
static interface	QOM.Replace	The REPLACE function.
static interface	QOM.Reverse	The REVERSE function.
static interface	QOM.Right	The RIGHT function.
static interface	QOM.RightJoin<R extends Record>
static interface	QOM.Root	The ROOT function.
static interface	QOM.Round<T extends Number>	The ROUND function.
static interface	QOM.RowAsField<R extends Record>
static interface	QOM.RowEq<T extends Row>	The ROW EQ operator.
static interface	QOM.RowGe<T extends Row>	The ROW GE operator.
static interface	QOM.RowGt<T extends Row>	The ROW GT operator.
static interface	QOM.RowIsNotNull
static interface	QOM.RowIsNull
static interface	QOM.RowLe<T extends Row>	The ROW LE operator.
static interface	QOM.RowLt<T extends Row>	The ROW LT operator.
static interface	QOM.RowNe<T extends Row>	The ROW NE operator.
static interface	QOM.Rownum	The ROWNUM function.
static interface	QOM.RowNumber
static interface	QOM.RowOverlaps
static interface	QOM.RowsFrom
static interface	QOM.Rpad	The RPAD function.
static interface	QOM.Rtrim	The RTRIM function.
static interface	QOM.ScalarSubquery<T>
static interface	QOM.SelectIsNotNull
static interface	QOM.SelectIsNull
static interface	QOM.Shl<T extends Number>	The SHL operator.
static interface	QOM.Shr<T extends Number>	The SHR operator.
static interface	QOM.Sign	The SIGN function.
static interface	QOM.SimilarTo	The SIMILAR TO operator.
static interface	QOM.SimilarToQuantified	The SIMILAR TO operator.
static interface	QOM.Sin	The SIN function.
static interface	QOM.Sinh	The SINH function.
static interface	QOM.Space	The SPACE function.
static interface	QOM.SplitPart	The SPLIT PART function.
static interface	QOM.Sqrt	The SQRT function.
static interface	QOM.Square<T extends Number>	The SQUARE function.
static interface	QOM.StArea	The ST AREA function.
static interface	QOM.StartsWith<T>	The STARTS WITH operator.
static interface	QOM.StartsWithIgnoreCase<T>	The STARTS WITH IGNORE CASE operator.
static interface	QOM.StAsBinary	The ST ASBINARY function.
static interface	QOM.StAsText	The ST ASTEXT function.
static interface	QOM.StBoundary<T extends Spatial>	The ST BOUNDARY function.
static interface	QOM.StCentroid	The ST CENTROID function.
static interface	QOM.StContains<T extends Spatial>	The ST CONTAINS function.
static interface	QOM.StCoveredBy<T extends Spatial>	The ST COVEREDBY function.
static interface	QOM.StCovers<T extends Spatial>	The ST COVERS function.
static interface	QOM.StCrosses	The ST CROSSES function.
static interface	QOM.StddevPop	The STDDEV POP function.
static interface	QOM.StddevSamp	The STDDEV SAMP function.
static interface	QOM.StDifference<T extends Spatial>	The ST DIFFERENCE function.
static interface	QOM.StDimension	The ST DIMENSION function.
static interface	QOM.StDisjoint<T extends Spatial>	The ST DISJOINT function.
static interface	QOM.StDistance<T extends Spatial>	The ST DISTANCE function.
static interface	QOM.StEndPoint<T extends Spatial>	The ST ENDPOINT function.
static interface	QOM.StEquals<T extends Spatial>	The ST EQUALS function.
static interface	QOM.StExteriorRing	The ST EXTERIORRING function.
static interface	QOM.StGeometryN<T extends Spatial>	The ST GEOMETRYN function.
static interface	QOM.StGeometryType	The ST GEOMETRYTYPE function.
static interface	QOM.StGeomFromText	The ST GEOMFROMTEXT function.
static interface	QOM.StGeomFromWKB	The ST GEOMFROMWKB function.
static interface	QOM.StInteriorRingN	The ST INTERIORRINGN function.
static interface	QOM.StIntersection<T extends Spatial>	The ST INTERSECTION function.
static interface	QOM.StIntersects<T extends Spatial>	The ST INTERSECTS function.
static interface	QOM.StIsClosed	The ST ISCLOSED function.
static interface	QOM.StIsEmpty	The ST ISEMPTY function.
static interface	QOM.StIsRing	The ST ISRING function.
static interface	QOM.StIsSimple	The ST ISSIMPLE function.
static interface	QOM.StIsValid	The ST ISVALID function.
static interface	QOM.StLength	The ST LENGTH function.
static interface	QOM.StNumGeometries	The ST NUMGEOMETRIES function.
static interface	QOM.StNumInteriorRings	The ST NUMINTERIORRING function.
static interface	QOM.StNumPoints	The ST NUMPOINTS function.
static interface	QOM.StOverlaps<T extends Spatial>	The ST OVERLAPS function.
static interface	QOM.StPerimeter<T extends Spatial>	The ST PERIMETER function.
static interface	QOM.StPointN<T extends Spatial>	The ST POINTN function.
static interface	QOM.StraightJoin<R extends Record>
static interface	QOM.StSrid	The ST SRID function.
static interface	QOM.StStartPoint<T extends Spatial>	The ST STARTPOINT function.
static interface	QOM.StTouches<T extends Spatial>	The ST TOUCHES function.
static interface	QOM.StTransform<T extends Spatial>	The ST TRANSFORM function.
static interface	QOM.StUnion<T extends Spatial>	The ST UNION function.
static interface	QOM.StWithin<T extends Spatial>	The ST WITHIN function.
static interface	QOM.StX	The ST X function.
static interface	QOM.StXMax	The ST XMAX function.
static interface	QOM.StXMin	The ST XMIN function.
static interface	QOM.StY	The ST Y function.
static interface	QOM.StYMax	The ST YMAX function.
static interface	QOM.StYMin	The ST YMIN function.
static interface	QOM.StZ	The ST Z function.
static interface	QOM.StZMax	The ST ZMAX function.
static interface	QOM.StZMin	The ST ZMIN function.
static interface	QOM.Sub<T>	The SUB operator.
static interface	QOM.Substring	The SUBSTRING function.
static interface	QOM.SubstringIndex	The SUBSTRING INDEX function.
static interface	QOM.Sum	The SUM function.
static interface	QOM.SysConnectByPath	The SYS CONNECT BY PATH function.
static interface	QOM.TableAlias<R extends Record>
static interface	QOM.TableAsField<R extends Record>
static interface	QOM.TableEq<R extends Record>	The EQ operator.
static interface	QOM.TableNe<R extends Record>	The NE operator.
static interface	QOM.Tan	The TAN function.
static interface	QOM.Tanh	The TANH function.
static interface	QOM.Tau	The TAU function.
static interface	QOM.TimestampDiff<T>
static interface	QOM.ToChar	The TO CHAR function.
static interface	QOM.ToDate	The TO DATE function.
static interface	QOM.ToHex	The TO HEX function.
static interface	QOM.ToTimestamp	The TO TIMESTAMP function.
static interface	QOM.Translate	The TRANSLATE function.
static interface	QOM.Trim	The TRIM function.
static interface	QOM.True	A Condition that is always TRUE.
static interface	QOM.Trunc<T extends Number>	The TRUNC function.
static interface	QOM.TryCast<T>	The TRY CAST function.
static interface	QOM.Unique	The UNIQUE function.
static interface	QOM.Updating	The UPDATING function.
static interface	QOM.Upper	The UPPER function.
static interface	QOM.Uuid	The UUID function.
static interface	QOM.UuidToBin	The UUID TO BIN function.
static interface	QOM.Values<R extends Record>
static interface	QOM.VarPop	The VAR POP function.
static interface	QOM.VarSamp	The VAR SAMP function.
static interface	QOM.WidthBucket<T extends Number>	The WIDTH BUCKET function.
static interface	QOM.WindowFunction<T>
static interface	QOM.WithOrdinalityTable<R extends Record>	A collection derived table or table valued function with a WITH ORDINALITY clause.
static interface	QOM.WithTable<R extends Record>	A table with a T-SQL style WITH hint.
static interface	QOM.XMLAgg
static interface	QOM.XMLComment	The XMLCOMMENT function.
static interface	QOM.XMLConcat	The XMLCONCAT function.
static interface	QOM.XMLDocument	The XMLDOCUMENT function.
static interface	QOM.XMLElement
static interface	QOM.XMLExists
static interface	QOM.XMLForest	The XMLFOREST function.
static interface	QOM.XMLParse
static interface	QOM.XMLPi	The XMLPI function.
static interface	QOM.XMLQuery
static interface	QOM.XMLSerialize<T>	The XMLSERIALIZE function.
static interface	QOM.Xor	The XOR operator.

Classes in org.jooq.impl that implement SelectFieldOrAsterisk

Modifier and Type	Class	Description
class	CustomCondition	A base class for custom Condition implementations in client code.
class	CustomField<T>	A base class for custom Field implementations in client code.
class	CustomTable<R extends TableRecord<R>>	A base class for custom Table implementations in client code.
class	TableImpl<R extends Record>	A common base type for tables
class	UDTPathFieldImpl<R extends Record,U extends UDTRecord<U>,T>	A common base type for UDT path fields.
class	UDTPathTableFieldImpl<R extends Record,U extends UDTRecord<U>,T>	A common base type for table fields that are also UDTPathField.

Methods in org.jooq.impl that return types with arguments of type SelectFieldOrAsterisk

Modifier and Type	Method	Description
@NotNull QOM.UnmodifiableList<? extends SelectFieldOrAsterisk>	QOM.DeleteReturning.$returning()
@NotNull QOM.UnmodifiableList<? extends SelectFieldOrAsterisk>	QOM.InsertReturning.$returning()
@NotNull QOM.UnmodifiableList<? extends SelectFieldOrAsterisk>	QOM.UpdateReturning.$returning()

Methods in org.jooq.impl with parameters of type SelectFieldOrAsterisk

Modifier and Type	Method	Description
static @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.
SelectSelectStep<Record>	DefaultDSLContext.select(SelectFieldOrAsterisk... fields)
static @NotNull SelectSelectStep<Record>	DSL.select(SelectFieldOrAsterisk... fields)	Create a new DSL subselect statement.
SelectSelectStep<Record>	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 SelectFieldOrAsterisk

Modifier and Type	Method	Description
@NotNull QOM.DeleteReturning<?>	QOM.DeleteReturning.$returning(Collection<? extends SelectFieldOrAsterisk> returning)
@NotNull QOM.InsertReturning<?>	QOM.InsertReturning.$returning(Collection<? extends SelectFieldOrAsterisk> returning)
@NotNull QOM.UpdateReturning<?>	QOM.UpdateReturning.$returning(Collection<? extends SelectFieldOrAsterisk> returning)
SelectSelectStep<Record>	DefaultDSLContext.select(Collection<? extends SelectFieldOrAsterisk> fields)
static @NotNull SelectSelectStep<Record>	DSL.select(Collection<? extends SelectFieldOrAsterisk> fields)	Create a new DSL subselect statement.
SelectSelectStep<Record>	DefaultDSLContext.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
static @NotNull SelectSelectStep<Record>	DSL.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)	Create a new DSL subselect statement.