The range of a twos-complement 32-bit integer is -2147483648 through 2147483647. Yet in Postgres: # select -2147483647::int4; ?column? ------------- -2147483647 (1 row) # select -2147483648::int4; ERROR: integer out of range Is this a bug? Or something required by the SQL standard? (8.3.7, OS X 10.5.8, 32-bit build) -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxx http://www.killerbytes.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
