Re: [SQL] TG_TABLE_NAME as identifier

2008-02-07 Thread Tiziano Slack
Thanks, T. _ Organizza le tue feste e condividine le foto con Windows Live Eventi! http://home.services.spaces.live.com/events/

Re: [SQL] accounting schema

2008-02-07 Thread John Hasler
Look at LedgerSMB at www.ledgersmb.org. It uses Postgresql. -- John Hasler [EMAIL PROTECTED] Elmwood, WI USA ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [SQL] accounting schema

2008-02-07 Thread Tony Wasson
On Feb 6, 2008 6:08 PM, Medi Montaseri [EMAIL PROTECTED] wrote: I am learning my way into Accounting and was wondering how Accounting applications are designed. perhaps you could point the way SNIP As a DBA, (and keeping it simple) I am thinking I need a table for every account which migh

Re: [SQL] accounting schema

2008-02-07 Thread johnf
On Wednesday 06 February 2008 06:54:36 pm Medi Montaseri wrote: I suppose instead of AR and AP tables, I can just have one table called Entry (thanks Joe) with an attribute indicating AR vs AP. I recommend you not do have only one table for transaction. AR and AP are different animals and