Re: Cast double precision to integer & check for overflow

Поиск
Список
Период
Сортировка
От Ian Pilcher
Тема Re: Cast double precision to integer & check for overflow
Дата
Msg-id 5104623B.40404@gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Cast double precision to integer & check for overflow  ("Alexander Gataric" <gataric@usa.net>)
Ответы Re: Cast double precision to integer & check for overflow  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
On 01/26/2013 05:06 PM, Alexander Gataric wrote:
> Just cast to integer. Decimal portion will be lost.

That part I've got.  :-)

It's checking that the double precision value will actual fit within the
range of the integer type (-2147483648 to +2147483647).  I could
certainly hard-code these values, but I'd like to use a more expressive
syntax, if it is available.

--
========================================================================
Ian Pilcher                                         arequipeno@gmail.com
Sometimes there's nothing left to do but crash and burn...or die trying.
========================================================================


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

Предыдущее
От: "Alexander Gataric"
Дата:
Сообщение: Re: [GENERAL] Cast double precision to integer & check for overflow
Следующее
От: Gavan Schneider
Дата:
Сообщение: Re: Cast double precision to integer & check for overflow