org.jooq

Interface UpdateReturningStep<R extends Record>

All Known Subinterfaces:

UpdateConditionStep<R>, UpdateFromStep<R>, UpdateSetMoreStep<R>, UpdateWhereStep<R>

public interface UpdateReturningStep<R extends Record>

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

Example:

 DSLContext create = DSL.using(configuration);

 TableRecord<?> record =
 create.update(table)
       .set(field1, value1)
       .set(field2, value2)
       .returning(field1)
       .fetchOne();
 

This implemented differently for every dialect:

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

Author:

Lukas Eder

Method Summary

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

Method Detail

returning

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

Configure the UPDATE statement to return all fields in R.

See Also:

UpdateResultStep

returning

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

Configure the UPDATE 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})
UpdateResultStep<R> returning(Collection<? extends Field<?>> fields)

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

Parameters:

fields - Fields to be returned

See Also:

UpdateResultStep