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

From: Matt Beauregard <matt(at)designscape(dot)com(dot)au>
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 17:45:48
Message-ID: 20010623034548.E51660@designscape.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 22, 2001 at 12:43:32PM +1000, Justin Clift wrote:
> 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.
>
> Would others also benefit from this alteration? If so, we might like to ask
> for it to be added to Bruce's TODO list.

We would like a way to increment sequences by a random amount, to add
some spice to order number generation and such. However it's never
made it up the priorities list high enough for us to work out how it
might be done. As someone suggested, a trigger might take care of it.

--
Matt Beauregard
Technical Director, Designscape
Ph: +61 2 9361 4233 Fx: +61 2 9361 4633

Permission is given for unlimited distribution of this work under the
Copyright Act 1968 (2001 amended). Unless otherwise stated, you agree
that these terms also cover works which you send in response.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message will trillich 2001-06-22 18:02:45 Re: where's the reference to a view, here?
Previous Message Sam Tregar 2001-06-22 17:39:22 Re: Indexes not being used.