Re: Format of the Money field
От | Mitch Vincent |
---|---|
Тема | Re: Format of the Money field |
Дата | |
Msg-id | 012e01c08d3a$9af522f0$0200000a@windows обсуждение исходный текст |
Ответ на | Re: Format of the Money field (The Hermit Hacker <scrappy@hub.org>) |
Ответы |
Re: Format of the Money field
|
Список | pgsql-hackers |
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? > > >
В списке pgsql-hackers по дате отправления: