-
- 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
SELECT
clauses and a few other clauses that explicitly allow for asterisks, includingRETURNING
on DML statements. Asterisks are syntax sugar in SQL, which are expanded to a column list by the parser once all the columns in theFROM
clause 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 QualifiedAsterisk
except(String... fieldNames)
The qualified asterisk (t.* EXCEPT (fields)
) expression to be used inSELECT
clauses.QualifiedAsterisk
except(Field<?>... fields)
The qualified asterisk (t.* EXCEPT (fields)
) expression to be used inSELECT
clauses.QualifiedAsterisk
except(Name... fieldNames)
The qualified asterisk (t.* EXCEPT (fields)
) expression to be used inSELECT
clauses.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 inSELECT
clauses.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 inSELECT
clauses.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 inSELECT
clauses.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.
-
-