public interface WithAsStep18
This type is part of the jOOQ DSL to create
Select
, Insert
,
Update
, Delete
, Merge
statements prefixed with a
WITH
clause and with CommonTableExpression
s.
Example:
DSL.with("table", "col1", "col2")
.as(
select(one(), two())
)
.select()
.from("table")
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@NotNull WithStep
as(ResultQuery<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)
Associate a subselect with a common table expression's table and column names.@NotNull WithStep
asMaterialized(ResultQuery<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)
Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
asNotMaterialized(ResultQuery<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)
Associate a non-materialized subselect with a common table expression's table and column names.
-
Method Details
-
as
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WithStep as(ResultQuery<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)Associate a subselect with a common table expression's table and column names. -
asMaterialized
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WithStep asMaterialized(ResultQuery<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)Associate a materialized subselect with a common table expression's table and column names.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 @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WithStep asNotMaterialized(ResultQuery<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> query)Associate a non-materialized subselect with a common table expression's table and column names.This adds the PostgreSQL 12
NOT MATERIALIZED
hint to the common table expression definition, or silently ignores it, if the hint is not supported.
-