Top Description Methods
org.jooq

public Interface CreateIndexWhereStep

extends CreateIndexFinalStep
Known Direct Subinterfaces
org.jooq.CreateIndexIncludeStep
Known Direct Implementers
org.jooq.impl.CreateIndexImpl
Annotations
@SuppressWarnings:unused
Static Imports
org.jooq.SQLDialect.*, org.jooq.impl.DSL.*

Deprecated

as a consequence of CreateIndexFinalStep being deprecated. See corresponding docs for further information.

A step in the construction of the CREATE INDEX statement.

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

Method Summary

Modifier and TypeMethod and Description
public @NotNull CreateIndexFinalStep
excludeNullKeys()

Deprecated as a consequence of CreateIndexFinalStep being deprecated.
Add the EXCLUDE NULL KEYS clause to the CREATE INDEX statement.
public @NotNull CreateIndexFinalStep
where(Field<Boolean> where)

Deprecated as a consequence of Field and CreateIndexFinalStep being deprecated.
Add the WHERE clause to the CREATE INDEX statement.
public @NotNull CreateIndexFinalStep
where(Condition... where)

Deprecated as a consequence of Condition and CreateIndexFinalStep being deprecated.
Add the WHERE clause to the CREATE INDEX statement.
public @NotNull CreateIndexFinalStep
where(Collection<? extends Condition> where)

Deprecated as a consequence of CreateIndexFinalStep being deprecated.
Add the WHERE clause to the CREATE INDEX statement.
public @NotNull CreateIndexFinalStep
where(Condition where)

Deprecated as a consequence of Condition and CreateIndexFinalStep being deprecated.
Add the WHERE clause to the CREATE INDEX statement.
public @NotNull CreateIndexFinalStep
where(String where, QueryPart... parts)

Deprecated as a consequence of CreateIndexFinalStep being deprecated.
Add the WHERE clause to the CREATE INDEX statement.
public @NotNull CreateIndexFinalStep
where(String where, Object... bindings)

Deprecated as a consequence of CreateIndexFinalStep being deprecated.
Add the WHERE clause to the CREATE INDEX statement.
public @NotNull CreateIndexFinalStep
where(String where)

Deprecated as a consequence of CreateIndexFinalStep being deprecated.
Add the WHERE clause to the CREATE INDEX statement.
public @NotNull CreateIndexFinalStep
where(SQL where)

Deprecated as a consequence of CreateIndexFinalStep being deprecated.
Add the WHERE clause to the CREATE INDEX statement.

Method Detail

excludeNullKeysback to summary
public @NotNull CreateIndexFinalStep excludeNullKeys()

Deprecated

as a consequence of CreateIndexFinalStep being deprecated. See corresponding docs for further information.

Add the EXCLUDE NULL KEYS clause to the CREATE INDEX statement.

Annotations
@Support:POSTGRES, SQLITE, YUGABYTEDB
@NotNull
@CheckReturnValue
whereback to summary
public @NotNull CreateIndexFinalStep where(Field<Boolean> where)

Deprecated

as a consequence of Field and CreateIndexFinalStep being deprecated. See corresponding docs for further information.

Add the WHERE clause to the CREATE INDEX statement.

Annotations
@Support:POSTGRES, SQLITE, YUGABYTEDB
@NotNull
@CheckReturnValue
whereback to summary
public @NotNull CreateIndexFinalStep where(Condition... where)

Deprecated

as a consequence of Condition and CreateIndexFinalStep being deprecated. See corresponding docs for further information.

Add the WHERE clause to the CREATE INDEX statement.

Annotations
@Support:POSTGRES, SQLITE, YUGABYTEDB
@NotNull
@CheckReturnValue
whereback to summary
public @NotNull CreateIndexFinalStep where(Collection<? extends Condition> where)

Deprecated

as a consequence of CreateIndexFinalStep being deprecated. See corresponding docs for further information.

Add the WHERE clause to the CREATE INDEX statement.

Annotations
@Support:POSTGRES, SQLITE, YUGABYTEDB
@NotNull
@CheckReturnValue
whereback to summary
public @NotNull CreateIndexFinalStep where(Condition where)

Deprecated

as a consequence of Condition and CreateIndexFinalStep being deprecated. See corresponding docs for further information.

Add the WHERE clause to the CREATE INDEX statement.

Annotations
@Support:POSTGRES, SQLITE, YUGABYTEDB
@NotNull
@CheckReturnValue
whereback to summary
public @NotNull CreateIndexFinalStep where(String where, QueryPart... parts)

Deprecated

as a consequence of CreateIndexFinalStep being deprecated. See corresponding docs for further information.

Add the WHERE clause to the CREATE INDEX statement.

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Annotations
@Support:POSTGRES, SQLITE, YUGABYTEDB
@PlainSQL
@NotNull
@CheckReturnValue
See Also
SQL
whereback to summary
public @NotNull CreateIndexFinalStep where(String where, Object... bindings)

Deprecated

as a consequence of CreateIndexFinalStep being deprecated. See corresponding docs for further information.

Add the WHERE clause to the CREATE INDEX statement.

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Annotations
@Support:POSTGRES, SQLITE, YUGABYTEDB
@PlainSQL
@NotNull
@CheckReturnValue
See Also
SQL
whereback to summary
public @NotNull CreateIndexFinalStep where(String where)

Deprecated

as a consequence of CreateIndexFinalStep being deprecated. See corresponding docs for further information.

Add the WHERE clause to the CREATE INDEX statement.

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Annotations
@Support:POSTGRES, SQLITE, YUGABYTEDB
@PlainSQL
@NotNull
@CheckReturnValue
See Also
SQL
whereback to summary
public @NotNull CreateIndexFinalStep where(SQL where)

Deprecated

as a consequence of CreateIndexFinalStep being deprecated. See corresponding docs for further information.

Add the WHERE clause to the CREATE INDEX statement.

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Annotations
@Support:POSTGRES, SQLITE, YUGABYTEDB
@PlainSQL
@NotNull
@CheckReturnValue
See Also
SQL