Database & utility
Scalar
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: DuckDB 2.0.0
Arguments & returns
2 overloadssetval(sequence_name, value)
Scalar
| Overload link | sequence_name | value |
Returns |
|---|---|---|---|
| #01 | VARCHAR | BIGINT |
BIGINT |
setval(sequence_name, value, is_called)
Scalar
| Overload link | sequence_name | value | is_called |
Returns |
|---|---|---|---|---|
| #02 | VARCHAR | BIGINT | BOOLEAN |
BIGINT |
Catalog examples
SELECT
setval ('my_sequence_name', 100, true);