BUG #1441: casting problem when lower limit, ERROR out of range

The following bug has been logged online:

Bug reference:      1441
Logged by:          Koei Kim
Email address:      koeikim@gmail.com
PostgreSQL version: 7.4.6, 8.0
Operating system:   Linux
Description:        casting problem when lower limit, ERROR out of range
Details:

when casting numeric types with lower limit value, postgresql report ERROR
out of range.

koei~# select -32768::int2 ;
ERROR:  integer out of range

koei~# select -2147483648::int4;
ERROR:  integer out of range

test=# SELECT -9223372036854775808::int8;
ERROR:  integer out of range