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

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 > As a DBA, (and keeping it simple) I am thinking I need a table for every > account which mig

Re: [SQL] accounting schema

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