| 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: | Whole Thread | Raw Message | 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
| 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 |