pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Clarification With Money data type 3+ messages / 3 participants [nested] [flat]
* Clarification With Money data type @ 2010-03-10 07:19 Navanethan Muthusamy <navanethanmca@gmail.com> 2010-03-11 08:49 ` Re: Clarification With Money data type Jasen Betts <jasen@xnet.co.nz> 0 siblings, 1 reply; 3+ messages in thread From: Navanethan Muthusamy @ 2010-03-10 07:19 UTC (permalink / raw) To: pgsql-jdbc@postgresql.org; pgsql-sql 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 in advance. Regards, Navanethan ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Clarification With Money data type 2010-03-10 07:19 Clarification With Money data type Navanethan Muthusamy <navanethanmca@gmail.com> @ 2010-03-11 08:49 ` Jasen Betts <jasen@xnet.co.nz> 2010-03-12 08:10 ` Re: Clarification With Money data type Ireneusz Pluta <ipluta@wp.pl> 0 siblings, 1 reply; 3+ messages in thread From: Jasen Betts @ 2010-03-11 08:49 UTC (permalink / raw) To: pgsql-sql On 2010-03-10, Navanethan Muthusamy <navanethanmca@gmail.com> 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 deprecated. > I want to store the money and retrieve. Please give me idea to work on that. for that you use a bank, not a database :) > 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) ??? it's better to use some sort of numeric ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Clarification With Money data type 2010-03-10 07:19 Clarification With Money data type Navanethan Muthusamy <navanethanmca@gmail.com> 2010-03-11 08:49 ` Re: Clarification With Money data type Jasen Betts <jasen@xnet.co.nz> @ 2010-03-12 08:10 ` Ireneusz Pluta <ipluta@wp.pl> 0 siblings, 0 replies; 3+ messages in thread From: Ireneusz Pluta @ 2010-03-12 08:10 UTC (permalink / raw) To: Jasen Betts <jasen@xnet.co.nz>; +Cc: pgsql-sql <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> <br> <blockquote cite="mid:hnaare$jh$1@reversiblemaps.ath.cx" type="cite"> <pre wrap=""> it's better to use some sort of numeric </pre> </blockquote> <font face="Courier New, Courier, monospace">or integer and store amounts of cents, not dollars. </font><br> </body> </html> ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-03-12 08:10 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2010-03-10 07:19 Clarification With Money data type Navanethan Muthusamy <navanethanmca@gmail.com> 2010-03-11 08:49 ` Jasen Betts <jasen@xnet.co.nz> 2010-03-12 08:10 ` Ireneusz Pluta <ipluta@wp.pl>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox