Subject | Re: [firebird-support] One more sequence related question |
---|---|
Author | Fidel Viegas |
Post date | 2008-02-15T09:46:16Z |
On Fri, Feb 15, 2008 at 10:17 AM, Helen Borrie <helebor@...> wrote:
Fidel.
> The first thing you're going to have to decide is what you mean by "saved".The time it was inserted in the table.
> The whole idea looks too vague and undefined yet to advise without wasting a
> lot of energy on IFs and BUTs.
> The second thing you'll need to face is that here is a model case where theI am really looking for a solution of this bomb-proof management system.
> 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...
Fidel.