Re: Invoice number - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Invoice number
Date
Msg-id web-1168222@davinci.ethosmedia.com
Whole thread Raw
In response to Invoice number  (Kaare Rasmussen <kar@webline.dk>)
List 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



pgsql-sql by date:

Previous
From: Mike Castle
Date:
Subject: Re: Invoice number
Next
From: Mike Castle
Date:
Subject: Re: Create table doesn't work in plpgsql