Re: Invoice number

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Invoice number
Date: 2000-12-21 15:49:46
Message-ID: web-1168222@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mike Castle 2000-12-21 15:52:57 Re: Invoice number
Previous Message Volker Paul 2000-12-21 11:01:57 Re: Invoice number