Top Description Methods
org.jooq

public non-sealed Interface QualifiedAsterisk

extends SelectFieldOrAsterisk
Known Direct Implementers
org.jooq.impl.QualifiedAsteriskImpl, org.jooq.impl.QualifiedAsteriskProxy
Imports
org.jooq.impl.QOM, .QOM.UnmodifiableList, org.jetbrains.annotations.NotNull, .ApiStatus.Experimental
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, including RETURNING on DML statements. Asterisks are syntax sugar in SQL, which are expanded to a column list by the parser once all the columns in the FROM 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

Modifier and TypeMethod and Description
public @NotNull QOM.UnmodifiableList<? extends Field<?>>
$except()

Experimental query object model accessor method, see also QOM.

public @NotNull Table<?>
$table()

Experimental query object model accessor method, see also QOM.

public @NotNull QualifiedAsterisk
except(String... fieldNames)

The qualified asterisk (t.* EXCEPT (fields)) expression to be used in SELECT clauses.

public @NotNull QualifiedAsterisk
except(Name... fieldNames)

The qualified asterisk (t.* EXCEPT (fields)) expression to be used in SELECT clauses.

public @NotNull QualifiedAsterisk
except(Field<?>... fields)

Deprecated as a consequence of Field being deprecated.
The qualified asterisk (t.* EXCEPT (fields)) expression to be used in SELECT clauses.
public @NotNull Table<?>
qualifier()

The qualifier.

Method Detail

$exceptback to summary
public @NotNull QOM.UnmodifiableList<? extends Field<?>> $except()

Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.

Annotations
@Experimental
@NotNull
$tableback to summary
public @NotNull Table<?> $table()

Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.

Annotations
@Experimental
@NotNull
exceptback to summary
public @NotNull QualifiedAsterisk except(String... fieldNames)

The qualified asterisk (t.* EXCEPT (fields)) expression to be used in SELECT 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.

Annotations
@NotNull
@Support
exceptback to summary
public @NotNull QualifiedAsterisk except(Name... fieldNames)

The qualified asterisk (t.* EXCEPT (fields)) expression to be used in SELECT 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.

Annotations
@NotNull
@Support
exceptback to summary
public @NotNull QualifiedAsterisk except(Field<?>... fields)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

The qualified asterisk (t.* EXCEPT (fields)) expression to be used in SELECT 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.

Annotations
@NotNull
@Support
qualifierback to summary
public @NotNull Table<?> qualifier()

The qualifier.

Annotations
@NotNull