Re: [GENERAL] Money in numeric field

2012-04-20 Thread Martín Marqués
El día 20 de abril de 2012 05:51, Albe Laurenz 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

Re: [GENERAL] Money in numeric field

2012-04-20 Thread Albe Laurenz
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

[GENERAL] Money in numeric field

2012-04-19 Thread Martín Marqués
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 lik