[BUGS] BUG #1444: ::int2 parser bug

#1

The following bug has been logged online:

Bug reference: 1444
Logged by: Ioseph Kim
Email address: pgsql-kr (AT) postgresql (DOT) or.kr
PostgreSQL version: 7.4x ~
Operating system: ALL
Description: ::int2 parser bug
Details:

Quote:

select int2(-32768);
int2

--------
-32768

--------------------------

Quote:

select -32768::int2;
ERROR: integer out of range

--------------------------

Quote:

select '-32768'::int2;
int2

--------
-32768

--------------------------

It seems to bug.

This bug occured ::int4 parsing too.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#2

"Ioseph Kim" <pgsql-kr (AT) postgresql (DOT) or.kr> writes:

Quote:

select -32768::int2;
ERROR: integer out of range

This is not a bug, because the interpretation is -(32768::int2)
which indeed is out of range.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[BUGS] BUG #1444: ::int2 parser bug

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

[BUGS] BUG #1444: ::int2 parser bug - 01-29-2005 , 01:47 PM

Re: [BUGS] BUG #1444: ::int2 parser bug - 01-29-2005 , 03:10 PM