Re: numeric precision when raising one numeric to another.

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: numeric precision when raising one numeric to another.
Дата
Msg-id 20050520140408.GA23910@wolff.to
обсуждение исходный текст
Ответ на Re: numeric precision when raising one numeric to another.  ("John D. Burger" <john@mitre.org>)
Список pgsql-general
On Fri, May 20, 2005 at 08:19:58 -0400,
  "John D. Burger" <john@mitre.org> wrote:
> I find all these statements about the near-uselessness of
> NUMERIC^NUMERIC to be pretty amazing.  It's fine to say, "no one seems
> to be asking for this, so we haven't implemented it yet", but, c'mon,
> folks, Postgres gets used for more than "business cases".

It is pretty useless. If you are doing exact math, fractional exponents
don't fit. If you are using integer exponents, you can store usable
exponents in an int (arguably an an int2).

People may be interested in NUMERIC^NUMERIC MOD N, but if so they aren't
going to do the exponentation first and then the mod operation.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Inherited constraints and search paths (was Re: Preserving data after updates)
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: numeric precision when raising one numeric to another.