Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer
От | Justin Clift |
---|---|
Тема | Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer |
Дата | |
Msg-id | 01062212433204.13202@justin обсуждение исходный текст |
Ответы |
Re: Suggested improvement : Adjust SEQUENCES to accept an
INCREMENT of functionname(parameters) instead of an integer
Re: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer Re: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer Re: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer |
Список | pgsql-general |
Hi all, Am doing some work with sequences at the moment, and I'm finding it would be useful to have sequences which use an increment amount decided by a function call, instead of just a straight integer amount (as we presently do). For my example, I'd use this to add random positive increments (specifically to avoid easy predictability of the sequence), but it would be quite flexible. i.e. CREATE SEQUENCE newseq INCREMENT trunc(random() * 10); Could do the same for the START, MINVALUE and MAXVALUE parameters also. Would others also benefit from this alteration? If so, we might like to ask for it to be added to Bruce's TODO list. Regards and best wishes, Justin Clift
В списке pgsql-general по дате отправления: