Re: [GENERAL] Running Totals and other stuff....

2004-06-02 Thread Richard Huxton
Mike Nolan wrote: Adding a cheque number primary key would work tho' Depending on the specifics of the application, check number may not be a 'unique' field. Automatic bank checks come to mind, on my monthy statments they tend to always have the same check number or none at all. In this case I'd

Re: [GENERAL] Running Totals and other stuff....

2004-06-01 Thread Mike Nolan
> Adding a cheque number primary key would work tho' Depending on the specifics of the application, check number may not be a 'unique' field. Automatic bank checks come to mind, on my monthy statments they tend to always have the same check number or none at all. In this case I'd use a serial c

[GENERAL] Running Totals and other stuff....

2004-06-01 Thread Levan, Jerry
Title: Running Totals and other stuff Humpfff...Last night I tried posting this and found that dynamic IP's are now prevented from posting to the list... Did I miss the announcement? Hi, I keep all of my financial data in Postgresql ( 7.4.2). My "