Re: postgres arithmetic: raising to nth power

Поиск
Список
Период
Сортировка
От Andrej Ricnik-Bay
Тема Re: postgres arithmetic: raising to nth power
Дата
Msg-id b356039305092915343fb4c167@mail.gmail.com
обсуждение исходный текст
Ответ на postgres arithmetic: raising to nth power  (Ennio-Sr <nasr.laili@tin.it>)
Ответы Re: postgres arithmetic: raising to nth power  (Ennio-Sr <nasr.laili@tin.it>)
Список pgsql-novice
> Hi all,

> testing a few arithmetic calculations to make sure I understood how
> they worked before including them in a a query I met with the following
> results:
I'm not sure I understand what you're trying to say.


Except for the fact that you encounter rounding errors (which
shouldn't come as a surprise with an exponent of 54) everything
seems to work "normally" as far as I'm concerned.

If you need arbitrary precision don't do the calculation using
a select statement but rather utilise CLN or some other special
maths library.


Cheers,
Andrej

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: postgres arithmetic: raising to nth power
Следующее
От: Ennio-Sr
Дата:
Сообщение: Re: postgres arithmetic: raising to nth power