Re: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer
Date
Msg-id 200106220313.f5M3DiW27253@candle.pha.pa.us
Whole thread Raw
In response to Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer  (Justin Clift <aa2@bigpond.net.au>)
List 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.

Sorry but my initial impression is that this functionality is pretty
strange.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer
Next
From: Tom Lane
Date:
Subject: Re: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer