Re: Invoice number

From: John Hasler <john(at)dhh(dot)gt(dot)org>
To: PostgreSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Invoice number
Date: 2000-12-21 20:41:31
Message-ID: 878zp9qzgk.fsf@toncho.dhh.gt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Mike Castle writes:
> Client 3 comes along. Do they use invoice #1, out of order, or invoice
> #3?

It shouldn't matter, as long as every number is accounted for.

Seems to me that a trigger could make a log entry every time the serial is
incremented. Workable?

> What happens in a paper world if a cup of coffee is spilt on some
> invoices, and these precious items are thrown in the trash?

They are returned to accounting with an explanatory note, the numbers are
logged as "voided", and the spoiled forms are shredded.
--
John Hasler
john(at)dhh(dot)gt(dot)org
Dancing Horse Hill
Elmwood, Wisconsin

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Miyabara-McCaskey 2000-12-22 05:37:46 regcomp failed with error empty (sub)expression?
Previous Message Kaare Rasmussen 2000-12-21 19:17:18 Re: Invoice number