Postgres Pro
Downloads
Home   >   mailing lists

BUG #1441: casting problem when lower limit, ERROR out of range - Mailing list pgsql-bugs

From Koei Kim
Subject BUG #1441: casting problem when lower limit, ERROR out of range
Date
Msg-id 20050127044022.46EBA9A5827@www.postgresql.com
Whole thread Raw
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Dennis Hübner
Date:
Subject: No connection to Server
Next
From: PFC
Date:
Subject: Re: [GENERAL] My postmaster just crashed !