Avoiding in underflow in double -> real conversions

Поиск
Список
Период
Сортировка
От David Wilson
Тема Avoiding in underflow in double -> real conversions
Дата
Msg-id AANLkTimAyMgvd-QGYg1mD3dk5qA+WsNGLdbyxwkyZits@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
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

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

Предыдущее
От: Leif Biberg Kristensen
Дата:
Сообщение: Re: Front End Application (OFF-TOPIC)
Следующее
От: Lincoln Yeoh
Дата:
Сообщение: Re: Trade Study on Oracle vs. PostgreSQL