UpdateReturningStep (jOOQ 3.11.12 API)

All Superinterfaces:

Attachable, AutoCloseable, Query, QueryPart, Serializable, Statement, Update<R>, UpdateFinalStep<R>

All Known Subinterfaces:

UpdateConditionStep<R>, UpdateFromStep<R>, UpdateSetMoreStep<R>, UpdateWhereStep<R>
```
public interface UpdateReturningStep<R extends Record>
extends UpdateFinalStep<R>
```
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 ...)
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:
- They're operating on mutable implementations (as of jOOQ 3.x)
- They're less composable and not easy to get right when dynamic SQL gets complex
- They're less readable
- They might have binary incompatible changes between minor releases
Author:

Lukas Eder

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`UpdateResultStep<R>`	`returning()` Configure the `UPDATE` statement to return all fields in `R`.
`UpdateResultStep<R>`	`returning(Collection<? extends SelectFieldOrAsterisk> fields)` Configure the `UPDATE` statement to return a list of fields in `R`.
`UpdateResultStep<R>`	`returning(SelectFieldOrAsterisk... fields)` Configure the `UPDATE` statement to return a list of fields in `R`.
`UpdateResultStep<Record>`	`returningResult(Collection<? extends SelectFieldOrAsterisk> fields)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1> UpdateResultStep<Record1<T1>>`	`returningResult(SelectField<T1> field1)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2> UpdateResultStep<Record2<T1,T2>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3> UpdateResultStep<Record3<T1,T2,T3>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4> UpdateResultStep<Record4<T1,T2,T3,T4>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5> UpdateResultStep<Record5<T1,T2,T3,T4,T5>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6> UpdateResultStep<Record6<T1,T2,T3,T4,T5,T6>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7> UpdateResultStep<Record7<T1,T2,T3,T4,T5,T6,T7>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8> UpdateResultStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9> UpdateResultStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> UpdateResultStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> UpdateResultStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> UpdateResultStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> UpdateResultStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> UpdateResultStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> UpdateResultStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> UpdateResultStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> UpdateResultStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> UpdateResultStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>`	`returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18)` Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> UpdateResultStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>`	returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19) Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> UpdateResultStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>`	returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20) Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> UpdateResultStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>`	returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21) Configure the `UPDATE` statement to return a list of fields in `R`.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> UpdateResultStep<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>`	returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22) Configure the `UPDATE` statement to return a list of fields in `R`.
`UpdateResultStep<Record>`	`returningResult(SelectFieldOrAsterisk... fields)` Configure the `UPDATE` 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={AURORA_POSTGRES,DB2,FIREBIRD,ORACLE,POSTGRES})
UpdateResultStep<R> returning()

Configure the UPDATE statement to return all fields in R.

See Also:: UpdateResultStep

returning
```
@Support(value={AURORA_POSTGRES,DB2,FIREBIRD,ORACLE,POSTGRES})
UpdateResultStep<R> returning(SelectFieldOrAsterisk... fields)
```
Configure the UPDATE statement to return a list of fields in R.
[#5070] Due to an early API design flaw, this method historically returns the type R, not a more generic type Record. This means that only actual columns in R can be returned. For a more generic set of column expressions, use returningResult(SelectFieldOrAsterisk...) instead.

Parameters:

fields - Fields to be returned

See Also:

UpdateResultStep

returning
```
@Support(value={AURORA_POSTGRES,DB2,FIREBIRD,ORACLE,POSTGRES})
UpdateResultStep<R> returning(Collection<? extends SelectFieldOrAsterisk> fields)
```
Configure the UPDATE statement to return a list of fields in R.
[#5070] Due to an early API design flaw, this method historically returns the type R, not a more generic type Record. This means that only actual columns in R can be returned. For a more generic set of column expressions, use returningResult(Collection) instead.

Parameters:

fields - Fields to be returned

See Also:

UpdateResultStep

returningResult
```
@Support(value={AURORA_POSTGRES,DB2,FIREBIRD,ORACLE,POSTGRES})
UpdateResultStep<Record> returningResult(SelectFieldOrAsterisk... fields)
```
Configure the UPDATE statement to return a list of fields in R.

Parameters:

fields - Fields to be returned

See Also:

UpdateResultStep