Обсуждение: Avoiding in underflow in double -> real conversions

Поиск
Список
Период
Сортировка

Avoiding in underflow in double -> real conversions

От
David Wilson
Дата:
List-

I've got a calculation that, due to its use of exp(), is produces double precision intermediate results which I ultimately need to cast back to real to store in a table column. However, with certain inputs, this results in an underflow error. Is there any way outside of an exception-trapping plpgsql function to performance the conversion and simply cause underflows to result in a 0?

Thanks for any ideas.

--
- David T. Wilson
david.t.wilson@gmail.com