Re: Format of the Money field

Just a question on this for my own personal satisfaction...

What's the standard on Money type (if there is one) and if it doesn't
include the $ (of course that would change based on what currency you were
using) then is it any different than numeric(9,2)? numeric(9,2) is what I
use for all fields that need to hold a dollar amount so I'm curious.. I
remember reading in the documentation that money was numeric(9,2) with the
dollar sign added but I wanted to check with the man :-)

-Mitch


----- Original Message -----
From: "Peter Mount" <peter@retep.org.uk>
To: "Mitch Vincent" <mitch@venux.net>; "The Hermit Hacker" <scrappy@hub.org>
Cc: <pgsql-hackers@postgresql.org>
Sent: Saturday, February 03, 2001 5:50 AM
Subject: Re: Format of the Money field


> At 12:07 02/02/01 -0500, Mitch Vincent wrote:
>
> >hhs=> select version();
> >version
> >-------------------------------------------------------------------
> >PostgreSQL 6.4.2 on i386-unknown-freebsd3.1, compiled by gcc 2.7.2.
>
> [snip]
>
>
> >  If it changed, it looks like it changed a long time ago! :-)
>
> Hmm, shows how many people use Money via JDBC then, as no one's reported
it
> before. I only found out while testing JBuilder's interaction with the
JDBC
> driver.
>
> Peter
>
> >-Mitch
> >
> >
> >----- Original Message -----
> >From: "The Hermit Hacker" <scrappy@hub.org>
> >To: "Peter T Mount" <peter@retep.org.uk>
> >Cc: <pgsql-hackers@postgresql.org>
> >Sent: Friday, February 02, 2001 11:55 AM
> >Subject: Re: Format of the Money field
> >
> >
> > > On Fri, 2 Feb 2001, Peter T Mount wrote:
> > >
> > > > When did the MONEY type change it's output format?
> > > >
> > > > While working on the JDBC test suite, Money broke. It seems to
output:
> > > > $10.99
> > > > ($10.99) for negative values
> > > >
> > > > While since ages past, the PGMoney class interprets it as a number
(no
> > > > currency symbol).
> > >
> > > Looking over at Thomas and asking him, his recollection is that it
always
> > > had the currency symbol ... but he's not 100% certain about that ...
> > >
> > > Can you confirm with the 7.0.3 server?
> > >
> > >
> > >
>
>