-
- All Superinterfaces:
QueryPart
,Serializable
public interface DerivedColumnList1 extends QueryPart
A derived column list.Thist type models a table name and an optional "derived column list", which can be used to name both tables and columns in one go, e.g. when aliasing a derived table or a
CommonTableExpression
.Example:
// Assuming import static org.jooq.impl.DSL.*; Table<?> t = name("t").fields("v").as(select(one())); // ^^^^^^^^^^^^^^^^^^^^^ -- DerivedColumnList using(configuration) .select() .from(t) .fetch();
Instances can be created using
Name.fields(String...)
and overloads.- Author:
- Lukas Eder
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description <R extends Record1<?>>
@NotNull CommonTableExpression<R>as(Select<R> select)
Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record1<?>>
@NotNull CommonTableExpression<R>asMaterialized(Select<R> select)
Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record1<?>>
@NotNull CommonTableExpression<R>asNotMaterialized(Select<R> select)
Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.
-
-
-
Method Detail
-
as
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <R extends Record1<?>> @NotNull CommonTableExpression<R> as(Select<R> select)
Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.
-
asMaterialized
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <R extends Record1<?>> @NotNull CommonTableExpression<R> asMaterialized(Select<R> select)
Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.This adds the PostgreSQL 12
MATERIALIZED
hint to the common table expression definition, or silently ignores it, if the hint is not supported.
-
asNotMaterialized
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) <R extends Record1<?>> @NotNull CommonTableExpression<R> asNotMaterialized(Select<R> select)
Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.This adds the PostgreSQL 12
NOT MATERIALIZED
hint to the common table expression definition, or silently ignores it, if the hint is not supported.
-
-