Subject Re: [firebird-support] One more sequence related question
Author Fidel Viegas
On Fri, Feb 15, 2008 at 10:17 AM, Helen Borrie <helebor@...> wrote:
> The first thing you're going to have to decide is what you mean by "saved".
> The whole idea looks too vague and undefined yet to advise without wasting a
> lot of energy on IFs and BUTs.

The time it was inserted in the table.

> The second thing you'll need to face is that here is a model case where the
> PK of the table should NOT be this non-atomic "thing", this invoice number,
> that has to be unique and not just sequential, but CONsequential. You'll
> need at least one non-atomic column to use as the PK and you'll need a
> bomb-proof management system for those invoice numbers...

I am really looking for a solution of this bomb-proof management system.

Fidel.