v.25.10Improvement

Add optional start_value parameter to generateSerialID

Added optional start_value parameter to generateSerialID function to specify custom starting values for new series. #88085 (Manuel).
Added an optional start_value parameter to the generateSerialID function, allowing users to specify custom starting values for new ID series.

Why it matters

This feature enables users to define the initial value of the serial ID sequence generated by generateSerialID. It provides greater flexibility in ID generation, especially when integrating with existing datasets or requiring non-default starting points for IDs.

How to use it

Use the generateSerialID function with the new optional start_value argument to specify the starting number of the ID series. For example:

SELECT generateSerialID(series_name, start_value) FROM table;