On 27.02.22 10:42, Jille Timmermans wrote:
I wanted to be able to allocate a bunch of numbers from a sequence at
once. Multiple people seem to be struggling with this
(https://stackoverflow.com/questions/896274/select-multiple-ids-from-a-postgresql-sequence,
https://www.depesz.com/2008/03/20/getting-multiple-values-from-sequences/).
I propose to add an extra argument to nextval() that specifies how many
numbers you want to allocate (default 1).
What is the use of this?
I note that the stackoverflow question wanted to return multiple
sequence values as a result set, whereas your implementation just skips
a number of values and returns the last one. At least we should be
clear about what we are trying to achieve.