Re: function to format floats as money?

Поиск
Список
Период
Сортировка
От John Hasler
Тема Re: function to format floats as money?
Дата
Msg-id 87ae5ftl3z.fsf@toncho.dhh.gt.org
обсуждение исходный текст
Ответ на Re: function to format floats as money?  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: function to format floats as money?  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Список pgsql-sql
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.
-- 
John Hasler
john@dhh.gt.org (John Hasler)
Dancing Horse Hill
Elmwood, WI


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

Предыдущее
От: clayton cottingham
Дата:
Сообщение: any proper benchmark scripts?
Следующее
От: clayton cottingham
Дата:
Сообщение: is this proper sql?