jOOQ 3.18.7 · org.jooq.WithAsStep18

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

Example:


DSL.with("table", "col1", "col2")
   .as(
       select(one(), two())
   )
   .select()
   .from("table")

Method Summary

Modifier and Type	Method and Description
public @NotNull WithStep	as(ResultQuery<? extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.
public @NotNull WithStep	asMaterialized(ResultQuery<? extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.
public @NotNull WithStep	asNotMaterialized(ResultQuery<? extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.

as	back to summary
public @NotNull WithStep as(ResultQuery<? extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names. Annotations @NotNull @CheckReturnValue @Support

public @NotNull WithStep as(ResultQuery<? extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query)

Associate a subselect with a common table expression's table and column names.

Annotations

asMaterialized back to summary

asMaterialized	back to summary
public @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. Annotations @NotNull @CheckReturnValue @Support

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

Annotations

asNotMaterialized back to summary

asNotMaterialized	back to summary
public @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. Annotations @NotNull @CheckReturnValue @Support

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

Annotations