v.25.10Improvement
Add optional start_value parameter to generateSerialID
Added optionalstart_valueparameter togenerateSerialIDfunction to specify custom starting values for new series. #88085 (Manuel).
Why it matters
This feature enables users to define the initial value of the serial ID sequence generated bygenerateSerialID. 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 thegenerateSerialID 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;