Re: function to format floats as money?

Поиск
Список
Период
Сортировка
От Ross J. Reedstrom
Тема Re: function to format floats as money?
Дата
Msg-id 20010417145943.B19087@rice.edu
обсуждение исходный текст
Ответ на Re: function to format floats as money?  (John Hasler <john@dhh.gt.org>)
Список pgsql-sql
On Tue, Apr 17, 2001 at 01:52:16PM -0500, John Hasler wrote:
> Ross writes:
> > But seriously, numeric(10,2) (or whatever precision and scale is correct
> > for your application) is the standard answer.
> 
> Floats are fine for money as long as you only add and subtract and don't
> deal in amounts that won't fit in the mantissa.

Or you're writing software in Germany (all of the EU now?) that _might_
get used in an offical capacity.

Ross


В списке pgsql-sql по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: RTREE on points
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: is this proper sql?