Package org.jooq

Interface QualifiedAsterisk

  • All Superinterfaces:
    QueryPart, SelectFieldOrAsterisk, java.io.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 Detail

      • qualifier

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

        @Support
        QualifiedAsterisk except​(java.lang.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

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

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