pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / 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>
  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-11 08:49  Jasen Betts <jasen@xnet.co.nz>
  parent: Navanethan Muthusamy <navanethanmca@gmail.com>
  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-12 08:10  Ireneusz Pluta <ipluta@wp.pl>
  parent: Jasen Betts <jasen@xnet.co.nz>
  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