org.jooq

Interface DeleteReturningStep<R extends Record>

All Superinterfaces:

Attachable, java.lang.AutoCloseable, Delete<R>, DeleteFinalStep<R>, Query, QueryPart, java.io.Serializable

All Known Subinterfaces:

DeleteConditionStep<R>, DeleteWhereStep<R>

public interface DeleteReturningStep<R extends Record>
extends DeleteFinalStep<R>

This type is used for the Delete's DSL API.

Example:

 DSLContext create = DSL.using(configuration);

 create.delete(table)
       .where(field1.greaterThan(100))
       .execute();
 

This implemented differently for every dialect:

• Firebird and Postgres have native support for UPDATE .. RETURNING clauses
• DB2 allows to execute SELECT .. FROM FINAL TABLE (DELETE ...)

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
DeleteResultStep<R>	returning() Configure the DELETE statement to return all fields in R.
DeleteResultStep<R>	returning(java.util.Collection<? extends Field<?>> fields) Configure the DELETE statement to return a list of fields in R.
DeleteResultStep<R>	returning(Field<?>... fields) Configure the DELETE statement to return a list of fields in R.

Methods inherited from interface org.jooq.Query

bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Methods inherited from interface org.jooq.Attachable

attach, configuration, detach

Method Detail

returning

@Support(value={DB2,FIREBIRD,ORACLE,POSTGRES})
DeleteResultStep<R> returning()

Configure the DELETE statement to return all fields in R.

See Also:

UpdateResultStep

returning

@Support(value={DB2,FIREBIRD,ORACLE,POSTGRES})
DeleteResultStep<R> returning(Field<?>... fields)

Configure the DELETE statement to return a list of fields in R.

Parameters:

fields - Fields to be returned

See Also:

UpdateResultStep

returning

@Support(value={DB2,FIREBIRD,ORACLE,POSTGRES})
DeleteResultStep<R> returning(java.util.Collection<? extends Field<?>> fields)

Configure the DELETE statement to return a list of fields in R.

Parameters:

fields - Fields to be returned

See Also:

UpdateResultStep