-
- All Superinterfaces:
QueryPart,SelectFieldOrAsterisk,Serializable
public interface QualifiedAsterisk extends SelectFieldOrAsterisk
A qualified asterisk.Asterisks (qualified and unqualified) are expressions that can be used exclusively in
SELECTclauses and a few other clauses that explicitly allow for asterisks, includingRETURNINGon DML statements. Asterisks are syntax sugar in SQL, which are expanded to a column list by the parser once all the columns in theFROMclause are known.Example:
// Assuming import static org.jooq.impl.DSL.*; using(configuration) .select(ACTOR.asterisk()) .from(ACTOR) .fetch();Instances can be created using
Table.asterisk().- Author:
- Lukas Eder
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description QualifiedAsteriskexcept(String... fieldNames)The qualified asterisk (t.* EXCEPT (fields)) expression to be used inSELECTclauses.QualifiedAsteriskexcept(Field<?>... fields)The qualified asterisk (t.* EXCEPT (fields)) expression to be used inSELECTclauses.QualifiedAsteriskexcept(Name... fieldNames)The qualified asterisk (t.* EXCEPT (fields)) expression to be used inSELECTclauses.Table<?>qualifier()The qualifier.
-
-
-
Method Detail
-
qualifier
Table<?> qualifier()
The qualifier.
-
except
@Support QualifiedAsterisk except(String... fieldNames)
The qualified asterisk (t.* EXCEPT (fields)) expression to be used inSELECTclauses.This expression is a convenient way to select "all but some fields". Some dialects (e.g.
SQLDialect.H2) implement this feature natively. In other dialects, jOOQ expands the asterisk if possible.
-
except
@Support QualifiedAsterisk except(Name... fieldNames)
The qualified asterisk (t.* EXCEPT (fields)) expression to be used inSELECTclauses.This expression is a convenient way to select "all but some fields". Some dialects (e.g.
SQLDialect.H2) implement this feature natively. In other dialects, jOOQ expands the asterisk if possible.
-
except
@Support QualifiedAsterisk except(Field<?>... fields)
The qualified asterisk (t.* EXCEPT (fields)) expression to be used inSELECTclauses.This expression is a convenient way to select "all but some fields". Some dialects (e.g.
SQLDialect.H2) implement this feature natively. In other dialects, jOOQ expands the asterisk if possible.
-
-