Thread

Re: [HACKERS] float --> int

Maurice Gittens <mgittens@gits.nl> — 1998-05-11T13:27:52Z

-----Original Message-----
From: Andreas Zeugswetter <andreas.zeugswetter@telecom.at>
To: 'hackers@postgresql.org' <hackers@postgreSQL.org>
Date: maandag 11 mei 1998 21:31
Subject: [HACKERS] float --> int


>Maurice wrote:
>> Making an int from a float is only defined for "small" values of the
float.
>> So for the general case such a conversion would simply overflow the int,
>> giving it an undefined value. Does this make sense to you?
>
>This sure sounds good:
>select (4.00000 !); -- would work, but
>select (4.30000 !); -- would throw a runtime error like
>ERROR: float to integer conversion error, value out of range.
>


I agree. I'm just trying to say that the error should be flagged as such.

Maurice