org.jooq

Interface DeleteReturningStep<R extends Record>

All Known Subinterfaces:

DeleteConditionStep<R>

public interface DeleteReturningStep<R extends Record>

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(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.

Method Detail

returning

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

Configure the DELETE statement to return all fields in R.

See Also:

UpdateResultStep

returning

@Support(value={DB2,FIREBIRD,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,POSTGRES})
DeleteResultStep<R> returning(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