Module org.jooq
Package org.jooq

Interface QualifiedAsterisk

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, 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 Details

    • qualifier

      @NotNull @NotNull Table<?> qualifier()
      The qualifier.
    • except

      @NotNull @Support @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.

    • except

      @NotNull @Support @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.

    • except

      @NotNull @Support @NotNull QualifiedAsterisk except(Field<?>... fields)
      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.

    • except

      @NotNull @Support @NotNull QualifiedAsterisk except(Collection<? extends Field<?>> fields)
      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.

    • $table

      @Experimental @NotNull @NotNull Table<?> $table()
      Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.
    • $except

      @Experimental @NotNull @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.