setval()

Set the value of the sequence to the specified value. If is_called is true, the sequence is called. If is_called is false, the sequence is not called.

Reference: Haybarn WASM 2.0.0-rc12

Arguments & returns

2 overloads

setval(sequence_name, value)

Scalar
Overload link sequence_namevalue Returns
#01 VARCHARBIGINT BIGINT

setval(sequence_name, value, is_called)

Scalar
Overload link sequence_namevalueis_called Returns
#02 VARCHARBIGINTBOOLEAN BIGINT

Catalog examples

SELECT
  setval ('my_sequence_name', 100, true);