Re: HELP ! With Money type

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: HELP ! With Money type
Дата
Msg-id 19885.1090591980@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: HELP ! With Money type  (Oliver Elphick <olly@lfix.co.uk>)
Список pgsql-admin
Oliver Elphick <olly@lfix.co.uk> writes:
> The Money type is deprecated.  It uses a floating point representation,
> which is not good for precise values.

Actually the underlying storage is integer (int4), which is precise but
has a very limited range.  Terry is seeing overflows (which are
evidently not being tested for :-().

            regards, tom lane

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

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: HELP ! With Money type
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Seq scan with a like operator