Re: Format of the Money field

hhs=> select version();
version
-------------------------------------------------------------------
PostgreSQL 6.4.2 on i386-unknown-freebsd3.1, compiled by gcc 2.7.2.

| currentsalary                    | money                            |
4 |

hhs=> select currentsalary from applicants;

$77,000.00
$43,500.00
$0.00
$93,000.00
...
If it changed, it looks like it changed a long time ago! :-)

-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?
>
>
>