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(at)hub(dot)org>
>To: "Peter T Mount" <peter(at)retep(dot)org(dot)uk>
>Cc: <pgsql-hackers(at)postgresql(dot)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?
> >
> >
> >