On Wed, Mar 23, 2005 at 20:47:36 +0200,
Andrus [EMAIL PROTECTED] wrote:
I thought about this.
1. It seems that user prefer to see separate numbers for each sequence.
First invoice has number 1 , second invoice has number 2
This suggests that invoices for different categories can have
Reply from Bruno Wolff III, re-posted from mail:
I have 120 concurrent users inserting documents. Mostly they are using
10
different document types. Each type should have separate numbering.
They
insert 30 documents per minute in peak hours.
You really should think about this. What are
I'm trying to move existing ERP database to Postgres
My database contains table of document headers:
CREATE TABLE document (
category CHAR,
sequence NUMERIC(7),
... a lot of other columns ... ,
PRIMARY KEY (category, sequence) ) ;
and document rows:
CREATE TABLE rows (
category
I have table containing different types of documents (type A, B and C).
Each document type must have separate sequential ID starting at 1
ID of first inserted record of type A must be set to 1
ID of first inserted record of type B must be also set to 1
ID of second record of type A
On Tue, 15 Mar 2005 08:39 pm, Andrus wrote:
I have table containing different types of documents (type A, B and C).
Each document type must have separate sequential ID starting at 1
ID of first inserted record of type A must be set to 1
ID of first inserted record of type B must
I have table containing different types of documents (type A, B and C).
Each document type must have separate sequential ID starting at 1
ID of first inserted record of type A must be set to 1
ID of first inserted record of type B must be also set to 1
ID of second record of type A must be
On Sat, Mar 19, 2005 at 22:37:55 +0200,
Andrus Moor [EMAIL PROTECTED] wrote:
I have table containing different types of documents (type A, B and C).
Each document type must have separate sequential ID starting at 1
ID of first inserted record of type A must be set to 1
ID of first
On Sat, Mar 12, 2005 at 23:05:41 +0200,
Andrus Moor [EMAIL PROTECTED] wrote:
I have table containing different types of documents (type A, B and C).
Each document type must have separate sequential ID starting at 1
ID of first inserted record of type A must be set to 1
ID of first
On Sun, 13 Mar 2005 02:59 pm, Bruno Wolff III wrote:
On Sat, Mar 12, 2005 at 23:05:41 +0200,
Andrus Moor [EMAIL PROTECTED] wrote:
I have table containing different types of documents (type A, B and C).
Each document type must have separate sequential ID starting at 1
ID of first
