Re: [SQL] Invoice number

[Josh Berkus]

Kaare,

> How many times have I tried this
> mailing list with no 
> success :-(

Hey!  It's a peer-to-peer mailing list.  You want guarenteed
answers, pay for support (I do)  <shrug>

> I'm wondering how people creates guaranteed sequential
> numbers - in my case 
> for invoice numbers.
> 
> - Sequences are not rollback'able.
> - It seems overkill to have a table just for this.
> - What else?

Given a full set of business rules for invoice numbers, I
could probably throw you a solution.  Gods know that I've
devised enough invoicing systems in the past.  Please post
more detail.

-Josh Berkus