Re: Clarification With Money data type - Mailing list pgsql-sql

From Jasen Betts
Subject Re: Clarification With Money data type
Date
Msg-id hnaare$jh$1@reversiblemaps.ath.cx
Whole thread Raw
Responses Re: Clarification With Money data type  (Ireneusz Pluta <ipluta@wp.pl>)
List 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 bitintegers, 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


pgsql-sql by date:

Previous
From: Ben Morrow
Date:
Subject: Re: Help : insert a bytea data into new table
Next
From: Ben Morrow
Date:
Subject: Re: Help : insert a bytea data into new table