Re: Reuse serial numbers?

Oh, I just thought of having a boolean field for indicating usage...I
don't know if it will be more efficient. But as a novice... I think
that will be sufficient.

2008/3/27, Emil Obermayr <nobs@nobswolf.info>:
> 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
>
>
>
>  --
>  Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
>  To make changes to your subscription:
>  http://www.postgresql.org/mailpref/pgsql-novice
>