Re: LONG - Question on dealing w/ numerics - Mailing list pgsql-sql

From Josh Berkus
Subject Re: LONG - Question on dealing w/ numerics
Date
Msg-id web-2526955@davinci.ethosmedia.com
Whole thread Raw
In response to LONG - Question on dealing w/ numerics  ("David Durst" <ddurst@larubber.com>)
List pgsql-sql
David,
> Cash - Debit  100
> A/R  - Credit 100
> Cash - Credit 100
> A/R  - Debit  100
> (Which should have a net affect of 0 on both accounts)
> 
> But here is the resulting balance on accounts,
> 
> Cash Debit  Balance 200
> A/R  Credit Balance 200

Here may your problem, and it's in the schema:  is "A/R" and account or
is "A/R Credit" an account?   You're being unclear in your e-mail,
which makes me suspect that you're being vague in your code as well.

If I'm totally off the mark, then please post the four calls to your
function that produced the above mis-balance, and I can easily spot the
problem for you.

-Josh


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: LONG - Question on dealing w/ numerics
Next
From: "Rodger Donaldson"
Date:
Subject: Re: CSV import