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
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 |