Re: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Justin Clift <aa2(at)bigpond(dot)net(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer
Date: 2001-06-22 03:13:44
Message-ID: 200106220313.f5M3DiW27253@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-22 03:23:32 Re: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer
Previous Message Justin Clift 2001-06-22 02:43:32 Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer