- All Superinterfaces:
QueryPart
,Serializable
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
Modifier and TypeMethodDescription<R extends Record13<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record13<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record13<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.
-
Method Details
-
as
@NotNull @Support <R extends Record13<?,?, @NotNull CommonTableExpression<R> as?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> (ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression. -
asMaterialized
@NotNull @Support <R extends Record13<?,?, @NotNull CommonTableExpression<R> asMaterialized?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> (ResultQuery<R> query) 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 <R extends Record13<?,?, @NotNull CommonTableExpression<R> asNotMaterialized?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> (ResultQuery<R> query) 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.
-