/*
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *  http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * Other licenses:
 * -----------------------------------------------------------------------------
 * Commercial licenses for this work are available. These replace the above
 * ASL 2.0 and offer limited warranties, support, maintenance, and commercial
 * database integrations.
 *
 * For more information, please visit: http://www.jooq.org/licenses
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 */

package org.jooq;

// ...
// ...
// ...
// ...
import static org.jooq.SQLDialect.FIREBIRD;
import static org.jooq.SQLDialect.H2;
// ...
import static org.jooq.SQLDialect.HSQLDB;
// ...
// ...
import static org.jooq.SQLDialect.POSTGRES;
// ...
// ...
// ...

import java.util.Collection;

import org.jetbrains.annotations.NotNull;
import org.jetbrains.annotations.Nullable;

An UPDATE statement (model API).

This type is the model API representation of a Update statement, which can be mutated after creation. The advantage of this API compared to the DSL API is a more simple approach to writing dynamic SQL.

Instances can be created using DSLContext.updateQuery(Table<Record>) and overloads.

Author:Lukas Eder
Type parameters:
  • <R> – The record type of the table being updated
/** * An <code>UPDATE</code> statement (model API). * <p> * This type is the model API representation of a {@link Update} statement, * which can be mutated after creation. The advantage of this API compared to * the DSL API is a more simple approach to writing dynamic SQL. * <p> * Instances can be created using {@link DSLContext#updateQuery(Table)} and * overloads. * * @param <R> The record type of the table being updated * @author Lukas Eder */
@SuppressWarnings("deprecation") public interface UpdateQuery<R extends Record> extends StoreQuery<R>, ConditionProvider, Update<R> {
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1> void addValues(Row1<T1> row, Row1<T1> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2> void addValues(Row2<T1, T2> row, Row2<T1, T2> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3> void addValues(Row3<T1, T2, T3> row, Row3<T1, T2, T3> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4> void addValues(Row4<T1, T2, T3, T4> row, Row4<T1, T2, T3, T4> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5> void addValues(Row5<T1, T2, T3, T4, T5> row, Row5<T1, T2, T3, T4, T5> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6> void addValues(Row6<T1, T2, T3, T4, T5, T6> row, Row6<T1, T2, T3, T4, T5, T6> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7> void addValues(Row7<T1, T2, T3, T4, T5, T6, T7> row, Row7<T1, T2, T3, T4, T5, T6, T7> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8> void addValues(Row8<T1, T2, T3, T4, T5, T6, T7, T8> row, Row8<T1, T2, T3, T4, T5, T6, T7, T8> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9> void addValues(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> row, Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> void addValues(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row, Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> void addValues(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> row, Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> void addValues(Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> row, Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> void addValues(Row13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> row, Row13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> void addValues(Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> row, Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> void addValues(Row15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> row, Row15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> void addValues(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row, Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> void addValues(Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> row, Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> void addValues(Row18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> row, Row18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> void addValues(Row19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> row, Row19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> void addValues(Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> row, Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> void addValues(Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> row, Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> void addValues(Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> row, Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support void addValues(RowN row, RowN value);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1> void addValues(Row1<T1> row, Select<? extends Record1<T1>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2> void addValues(Row2<T1, T2> row, Select<? extends Record2<T1, T2>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3> void addValues(Row3<T1, T2, T3> row, Select<? extends Record3<T1, T2, T3>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4> void addValues(Row4<T1, T2, T3, T4> row, Select<? extends Record4<T1, T2, T3, T4>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5> void addValues(Row5<T1, T2, T3, T4, T5> row, Select<? extends Record5<T1, T2, T3, T4, T5>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6> void addValues(Row6<T1, T2, T3, T4, T5, T6> row, Select<? extends Record6<T1, T2, T3, T4, T5, T6>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7> void addValues(Row7<T1, T2, T3, T4, T5, T6, T7> row, Select<? extends Record7<T1, T2, T3, T4, T5, T6, T7>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8> void addValues(Row8<T1, T2, T3, T4, T5, T6, T7, T8> row, Select<? extends Record8<T1, T2, T3, T4, T5, T6, T7, T8>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9> void addValues(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> row, Select<? extends Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> void addValues(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row, Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> void addValues(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> row, Select<? extends Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> void addValues(Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> row, Select<? extends Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> void addValues(Row13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> row, Select<? extends Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> void addValues(Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> row, Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> void addValues(Row15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> row, Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> void addValues(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row, Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> void addValues(Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> row, Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> void addValues(Row18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> row, Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> void addValues(Row19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> row, Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> void addValues(Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> row, Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> void addValues(Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> row, Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> void addValues(Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> row, Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select);
Specify a multi-column set clause for the UPDATE statement.
/** * Specify a multi-column set clause for the <code>UPDATE</code> statement. */
@Support({ H2, HSQLDB, POSTGRES }) void addValues(RowN row, Select<?> select);
Add tables to the table product.
Params:
  • from – The added tables
/** * Add tables to the table product. * * @param from The added tables */
@Support({ POSTGRES }) void addFrom(TableLike<?> from);
Add tables to the table product.
Params:
  • from – The added tables
/** * Add tables to the table product. * * @param from The added tables */
@Support({ POSTGRES }) void addFrom(TableLike<?>... from);
Add tables to the table product.
Params:
  • from – The added tables
/** * Add tables to the table product. * * @param from The added tables */
@Support({ POSTGRES }) void addFrom(Collection<? extends TableLike<?>> from); // ------------------------------------------------------------------------ // XXX: Methods from ConditionProvider // ------------------------------------------------------------------------ @Override @Support void addConditions(Condition condition); @Override @Support void addConditions(Condition... conditions); @Override @Support void addConditions(Collection<? extends Condition> conditions); @Override @Support void addConditions(Operator operator, Condition condition); @Override @Support void addConditions(Operator operator, Condition... conditions); @Override @Support void addConditions(Operator operator, Collection<? extends Condition> conditions);
Adds ordering fields.
Params:
  • fields – The ordering fields
/** * Adds ordering fields. * * @param fields The ordering fields */
@Support void addOrderBy(OrderField<?>... fields);
Adds ordering fields.
Params:
  • fields – The ordering fields
/** * Adds ordering fields. * * @param fields The ordering fields */
@Support void addOrderBy(Collection<? extends OrderField<?>> fields);
Limit the results of this select.
Params:
  • numberOfRows – The number of rows to return
/** * Limit the results of this select. * * @param numberOfRows The number of rows to return */
@Support void addLimit(Number numberOfRows);
Limit the results of this select using named parameters.
Params:
  • numberOfRows – The number of rows to return
/** * Limit the results of this select using named parameters. * * @param numberOfRows The number of rows to return */
@Support void addLimit(Param<? extends Number> numberOfRows); // ------------------------------------------------------------------------ // XXX: Methods for the UPDATE .. RETURNING syntax // ------------------------------------------------------------------------
{@inheritDoc}

This feature works with UPDATE statements for a subset of SQL dialects

/** * {@inheritDoc} * <p> * This feature works with <code>UPDATE</code> statements for a subset of * SQL dialects */
@Override @Support({ FIREBIRD, POSTGRES }) void setReturning();
{@inheritDoc}

This feature works with UPDATE statements for a subset of SQL dialects

/** * {@inheritDoc} * <p> * This feature works with <code>UPDATE</code> statements for a subset of * SQL dialects */
@Override @Support({ FIREBIRD, POSTGRES }) void setReturning(Identity<R, ?> identity);
{@inheritDoc}

This feature works with UPDATE statements for a subset of SQL dialects

/** * {@inheritDoc} * <p> * This feature works with <code>UPDATE</code> statements for a subset of * SQL dialects */
@Override @Support({ FIREBIRD, POSTGRES }) void setReturning(SelectFieldOrAsterisk... fields);
{@inheritDoc}

This feature works with UPDATE statements for a subset of SQL dialects

/** * {@inheritDoc} * <p> * This feature works with <code>UPDATE</code> statements for a subset of * SQL dialects */
@Override @Support({ FIREBIRD, POSTGRES }) void setReturning(Collection<? extends SelectFieldOrAsterisk> fields);
{@inheritDoc}

This feature works with UPDATE statements for a subset of SQL dialects

/** * {@inheritDoc} * <p> * This feature works with <code>UPDATE</code> statements for a subset of * SQL dialects */
@Override @Nullable @Support({ FIREBIRD, POSTGRES }) R getReturnedRecord();
{@inheritDoc}

This feature works with UPDATE statements for a subset of SQL dialects

/** * {@inheritDoc} * <p> * This feature works with <code>UPDATE</code> statements for a subset of * SQL dialects */
@Override @NotNull @Support({ FIREBIRD, POSTGRES }) Result<R> getReturnedRecords(); }