Re: Reuse serial numbers?

On Thu, Mar 27, 2008 at 10:49:06AM +0100, A. Kretschmer wrote:
>
> Why do you think you need the numbers?

A typical application for low numbers (not letting them increase over
time) is the "human readabilitly" if you need them outside the DB as
labels on boxes for "real life transactions".

One solution is writing a function using a self join on the column
on a.n + 1 = b.n searching for NULL results; then returning the a.n+1.

I have this somewhere in the jungle of my source code snippets. Tell me
if you need me searching for it :)

Emil