Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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
Dancing Horse Hill
Elmwood, Wisconsin

In response to

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group