[SQL] Clarification With Money data type

2010-03-15 Thread Navanethan Muthusamy
Hi, I am using Postgresql 8.4, Can you tell me How Can I use Money data type? I want to store the money and retrieve. Please give me idea to work on that. I am using Java with Postgresql, I have tried java.math.BigDecimal with Money, but its giving error. (Its asking me to do the casing) Thanks

Re: [SQL] Clarification With Money data type

2010-03-12 Thread Ireneusz Pluta
it's better to use some sort of numeric or integer and store amounts of cents, not dollars.

Re: [SQL] Clarification With Money data type

2010-03-11 Thread Jasen Betts
On 2010-03-10, Navanethan Muthusamy wrote: > --0016e68e9a5510f1f504816d1fcb > Content-Type: text/plain; charset=ISO-8859-1 > > Hi, > > I am using Postgresql 8.4, Can you tell me How Can I use Money data type? it's best not to, "money" is a fixed-point fromat based on 32 bit integers, abn it's