From: | Martín Marqués <martin(dot)marques(at)gmail(dot)com> |
---|---|
To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Money in numeric field |
Date: | 2012-04-20 10:59:20 |
Message-ID: | CABeG9Ls54MoDXa=HBGAsx7YWvet=qHjsjgEC+WeO1qRpT2NLKA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
El día 20 de abril de 2012 05:51, Albe Laurenz
<laurenz(dot)albe(at)wien(dot)gv(dot)at> escribió:
> Martín Marqués wrote:
>> I have a question involving money data stored in a numeric(9,2) field,
>> and posible errors with there manipulation.
>>
>> in short, the table has these columns:
>>
>> store: int
>> amount: int2
>> cost: numeric(9,2)
>>
>> What I need to find is the total amount of money spent in a particular
>> store, so I do something like the second query:
>>
>> SELECT count(*) from material where store = 9;
>> count
>> -------
>> 360
>> (1 fila)
>>
>> SELECT sum(cost*amount) from material where store = 9;
>> sum
>> ----------
>> 48244.35
>> (1 fila)
>>
>>
>> Is it posible to have errors after multipling the numeric value by and
>> int and then adding them all with the SUM() function?
>
> Not really.
> "numeric" represents numbers exactly up to 131072 digits before
> the decimal point and up to 16383 digits after the decimal point.
Yes, I read that it's stored in a PACKED DECIMAL or BCD, but I was
worried abouit the SUM() function.
For what I read so far, I guess I won't have any problem, but just
wanted to be sure.
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
From | Date | Subject | |
---|---|---|---|
Next Message | F. BROUARD / SQLpro | 2012-04-20 14:15:37 | Re: Why did pg_relation_filepath does not give a correct path ? |
Previous Message | Guillaume Lelarge | 2012-04-20 10:05:26 | Re: Why did pg_relation_filepath does not give a correct path ? |